issue in export/import via datapump [message #567783] |
Fri, 05 October 2012 05:18 |
|
neetesh87
Messages: 280 Registered: September 2011 Location: bhopal
|
Senior Member |
|
|
hello experts,
i want to exp/imp emp and dept tables of scott schema to HR schema.
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\Neetesh>expdp scott/tiger@localdb tables=emp,dept directory=DATA_PUMP_D
IR dumpfile=exp_scott_tbl.dmp
Export: Release 11.2.0.1.0 - Production on Fri Oct 5 15:32:02 2012
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 "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** tables=emp,dept director
y=DATA_PUMP_DIR dumpfile=exp_scott_tbl.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/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SCOTT"."DEPT" 5.937 KB 4 rows
. . exported "SCOTT"."EMP" 8.570 KB 14 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
C:\ADMIN\LOCALDB\DPDUMP\EXP_SCOTT_TBL.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 15:34:25
C:\Users\Neetesh>impdp hr/hr@localdb tables=emp directory=DATA_PUMP_DIR dumpfil
e=exp_scott_tbl.dmp remap_schema=hr:scott
Import: Release 11.2.0.1.0 - Production on Fri Oct 5 15:37:36 2012
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
ORA-39002: invalid operation
ORA-39166: Object HR.EMP was not found.
or
C:\Users\Neetesh>impdp hr/hr@localdb tables=emp directory=DATA_PUMP_DIR dumpfil
e=exp_scott_tbl.dmp remap_schema=scott:hr
Import: Release 11.2.0.1.0 - Production on Fri Oct 5 15:40:48 2012
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
ORA-39002: invalid operation
ORA-39166: Object HR.EMP was not found.
or
C:\Users\Neetesh>impdp hr/hr@localdb tables=emp directory=DATA_PUMP_DIR dumpfil
e=exp_scott_tbl.dmp table_exists_action=replace
Import: Release 11.2.0.1.0 - Production on Fri Oct 5 15:41:29 2012
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
ORA-39002: invalid operation
ORA-39166: Object HR.EMP was not found.
C:\Users\Neetesh>
why the import process does not get suceesfully complted?
please tell me.
thanks....
|
|
|