expdp/impdp problem

I have a table called return_sets that exists in two different schemas (xmltest and xmltestb) with the same structures. The table in schema xmltestb contains data that includes an xmldata datatype, but is not indexed. The table in schema xmltest contains no data but has an xmlindex on the xmldata column. I tried to load the data from the xmltestb table into the xmltest table using expdp and impdp, but am getting errors. The commands I've used are:
expdp xmltestb/bpword@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS CONTENT=DATA_ONLY
impdp xmltest/pword@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS REMAP_SCHEMA=xmltestb:xmltest
Execution of the expdp command completes successfully, but the impdp command shows the following error messages:
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning and Data Mining options
Master table "XMLTEST"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "XMLTEST"."SYS_IMPORT_TABLE_01":  xmltest/********@xmldev DUMPFILE=ret_sets_data.dmp DIRECTORY=BIN_DIRECTORY TABLES=RETURN_SETS REMAP_SCHEMA=xmltestb:xmltest
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "XMLTEST"."RETURN_SETS" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-00600: internal error code, arguments: [kglslod:subheap], [8], [0x3E1D712E8], [], [], [], [], [], [], [], [], []
Job "XMLTEST"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 09:47:03

The error message documentation below doesn't seem to provide too much help in resolving the problem.
ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string Cause: Table failed to load or unload due to some error.
Action: Check load/unload error, correct problem and retry command.

ORA-29913: error in executing string callout Cause: The execution of the specified callout caused an error.
Action: Examine the error messages take appropriate action.

ORA-29875: failed in the execution of the ODCIINDEXINSERT routine Cause: Failed to successfully execute the ODCIIndexInsert routine.
Action: Check to see if the routine has been coded correctly.

I would appreciate any help in resolving this issue.
LVL 33
awking00Information Technology SpecialistAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
you also getting and ORA-600 error which oracle internal error.

if you have oracle support then use ORA-600 lookup tool on MOS or raise an incident to the oracle support center.

Also check this note 780848.1 for that particular ORA-600 error.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Wasim Akram ShaikCommented:
--expdp xmltestb/bpword@xmldev
--impdp xmltest/pword@xmldev??

is there any need to use expdp when you are in same database server??

you can simply use as insert into schema.table select * from schema.table;

I am not sure why ORA-0600 have got triggered...? also if you have to use datapump only then add a (table_exists_action=append) and see if this resolves your problem..
0
FaherCommented:
kindly take full export of particular table dont use content=data_only
import that table with table_exists_action=append or replace

If exported table is on different tablespace then imported schema (xmltest) then also use remap_tablespace=exported_Tablespace:imported_tablespace

let suppose if xmltestb schema has different tablespace then xmltest schema then you have to use repmap_tablespace option too. If boht schemas are using same tablespace then you dont need to define remap_tablespace
0
Wasim Akram ShaikCommented:
Expert Faher(table_exists_action=append) has already been suggested, you don't have to repeat an information which has already posted..!!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.