3 Replies Latest reply: Dec 16, 2013 7:02 AM by 7b850548-f50e-4b04-abc5-507f7d82e5ef RSS

    impdp does not import table

    7b850548-f50e-4b04-abc5-507f7d82e5ef

      When I run this command:

      expdp tosandata/tosandata tables=(acact2act)  directory=dumpdir dumpfile=acact2actdmp.dmp

      A dump file and a log file is created which the log content is as follows:

       

      ;;;

      Export: Release 11.2.0.1.0 - Production on Mon Dec 16 14:45:53 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

      ;;;

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      Starting "TOSANDATA"."SYS_EXPORT_TABLE_01":  tosandata/******** tables=(acact2act) directory=dumpdir dumpfile=acact2actdmp.dmp

      Estimate in progress using BLOCKS method...

      Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

      Total estimation using BLOCKS method: 128 KB

      Processing object type TABLE_EXPORT/TABLE/TABLE

      Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

      Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

      . . exported "TOSANDATA"."ACACT2ACT"                     45.03 KB 1313 rows

      Master table "TOSANDATA"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded

      ******************************************************************************

      Dump file set for TOSANDATA.SYS_EXPORT_TABLE_01 is:

        F:\TOSAN\DATADUMP\ACACT2ACTDMP.DMP

      Job "TOSANDATA"."SYS_EXPORT_TABLE_01" successfully completed at 14:45:57

       

       

      when I want to import the dump file with the following command:

      impdp MYTESTUSER/123456 tables=(acact2act)  directory=dumpdir dumpfile=acact2actdmp.dmp

      The table does not import and the following log is generated

      ;;;

      Import: Release 11.2.0.1.0 - Production on Mon Dec 16 14:54:05 2013

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

      ;;;

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      Master table "MYTESTUSER"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded

      ORA-39166: Object MYTESTUSER.ACACT2ACT was not found.

      Job "MYTESTUSER"."SYS_IMPORT_TABLE_01" successfully completed at 14:54:06

      Job "MYTESTUSER"."SYS_IMPORT_TABLE_01" successfully completed at 14:54:06

       

      But when I use the following commands:

      exp tosandata/tosandata tables=(acact2act)  file=F:\Tosan\DataDump\expdptool.dmp

      imp MYTESTUSER/123456 tables=(acact2act)  file=F:\Tosan\DataDump\expdptool.dmp

      export and import is done correctly