OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » datapump error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

datapump error [message #561581]

Tue, 24 July 2012 01:53

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

hi expert
i have perform following operation of datapump that is complete with one errror.

C:\>expdp full=y directory=preet dumpfile=full_database_migration.dmp logfile
=full_database_migration.log;
it gives me following error.

ORA-39139: Data Pump does not support XMLSchema objects.
it takes full backup but with one error.that i maintain above.
******************************************************************************
Dump file set for SYS.SYS_EXPORT_FULL_01 is:
D:\PRITESH\FULL_DATABASE_MIGRATION.DMP
Job "SYS"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 12:13:14

please suggest me how can i resolve this error.

thanks & regards
pritesh ranjan

Report message to a moderator

Re: datapump error [message #561583 is a reply to message #561581]

Tue, 24 July 2012 02:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

ORA-39139: Data Pump does not support XMLType objects in version string. string will be skipped.

Cause: Object had an XMLType column using either an object relational or binary storage format, which is unsupported by Data Pump in the target version.

Action: Use the original export and import utilities to move this object.

Report message to a moderator

Previous Topic:	Recovery process
Next Topic:	Cloning database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:18:19 CST 2024