Home » RDBMS Server » Backup & Recovery » datapump error
datapump error [message #561581] Tue, 24 July 2012 01:53 Go to next message
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

Re: datapump error [message #561583 is a reply to message #561581] Tue, 24 July 2012 02:00 Go to previous message
Littlefoot
Messages: 19892
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.
Previous Topic: Recovery process
Next Topic: Cloning database
Goto Forum:
  


Current Time: Sun Dec 21 15:07:50 CST 2014

Total time taken to generate the page: 0.13755 seconds