Hello we have two database on different servers. both running same platform windows 2008 ORacle11r2. we have two stars(schema) on both server. both schema have partition table and every partition has it own tablespace. Star one is empty its name is Say "Msoon" i want to populate Msoon with ONLY DATA of Other star say M2 i have tried different command but every time i get error. here is my command in which i'm extracting one table from database
expdp M1396_1447/Aa123456 DIRECTORY=data_pump_dir DUMPFILE=quest_dg2.dmp tables=M1396_1447.M1396_1447_DG2 CONTENT= DATA_ONLY
Now i want to import its data in Msoon star table MSOON02_DG2 which is same. just name is change but i get the following error
impdp MSOON/Aa123456 DIRECTORY=data_pumpdir DUMPFILE=QUEST_DG22.dmp remap_table=M1396_1447.M1396_1447_DG2:MSOON02.MSOON02_DG2 CONTENT= DATA_ONLY
;;;
Import: Release 11.2.0.1.0 - Production on Wed Jan 12 20:34:17 2011
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 "MSOON"."SYS_IMPORT_FULL_12" successfully loaded/unloaded
Starting "MSOON"."SYS_IMPORT_FULL_12": MSOON/******** DIRECTORY=data_pump_dir DUMPFILE=QUEST_DG22.dmp logfile=MY_L.log remap_table=M1396_1447.M1396_1447_DG2:MSOON02.MSOON02_DG2 CONTENT= DATA_ONLY
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [15]
TABLE_DATA:"M1396_1447"."MSOON02.MSOON02_DG2":"DEF_PART_M1396_1447_DG2"
ORA-31603: object "MSOON02.MSOON02_DG2" of type TABLE not found in schema "M1396_1447"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8171
----- PL/SQL Call Stack -----
object line object
handle number name
00000003B2AD5BB0 18990 package body SYS.KUPW$WORKER
00000003B2AD5BB0 8192 package body SYS.KUPW$WORKER
00000003B2AD5BB0 18552 package body SYS.KUPW$WORKER
00000003B2AD5BB0 4105 package body SYS.KUPW$WORKER
00000003B2AD5BB0 8875 package body SYS.KUPW$WORKER
00000003B2AD5BB0 1649 package body SYS.KUPW$WORKER
00000003B29D51D0 2 anonymous block
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.UPATE_TD_ROW_IMP [15]
TABLE_DATA:"M1396_1447"."MSOON02.MSOON02_DG2":"DEF_PART_M1396_1447_DG2"
ORA-31603: object "MSOON02.MSOON02_DG2" of type TABLE not found in schema "M1396_1447"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 8171
----- PL/SQL Call Stack -----
object line object
handle number name
00000003B2AD5BB0 18990 package body SYS.KUPW$WORKER
00000003B2AD5BB0 8192 package body SYS.KUPW$WORKER
00000003B2AD5BB0 18552 package body SYS.KUPW$WORKER
00000003B2AD5BB0 4105 package body SYS.KUPW$WORKER
00000003B2AD5BB0 8875 package body SYS.KUPW$WORKER
00000003B2AD5BB0 1649 package body SYS.KUPW$WORKER
00000003B29D51D0 2 anonymous block
Job "MSOON"."SYS_IMPORT_FULL_12" stopped due to fatal error at 20:34:19
Edited by: Oracle Studnet on Jan 12, 2011 7:36 AM