Home » RDBMS Server » Backup & Recovery » datapump error
datapump error [message #561581] Tue, 24 July 2012 01:53 Go to next message
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
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:
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
Messages: 21687
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator

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: Mon Sep 20 15:04:36 CDT 2021