Home » RDBMS Server » Server Utilities » Oracle 10g Data Pump (Oracle
Oracle 10g Data Pump [message #348630] Wed, 17 September 2008 07:58 Go to next message
Messages: 7
Registered: February 2008
Location: Mumbai,India
Junior Member

Need help using the datapump utility.
1) If the source db from where the dump file was generated is version and the destination db is, will it matter?

2) Am trying to import data on a blank schema. Shouldnt the datapump utility generate the schema from the export file?
Currently getting errors:
ORA-31693: Table data object "USERNAME"."TABLE_NAME" failed to lo
ad/unload and is being skipped due to error:
ORA-31603: object "TABLE_NAME" of type TABLE not found in schema
Not sure if this is some access issue.
The said USERNAME has roles -
connect,resource and IMP_FULL_DATABASE

3) If I try to import on some created schema, it is trying to do in some random order so that many tables are not getting loaded that were referring to some other table not alreay loaded(FK violation)
Is not the order maintained automatically while importing so that all the referential integrities are maintained or do we need to specify the order explicity while exporting.

Appreciate any help!
Re: Oracle 10g Data Pump [message #348766 is a reply to message #348630] Wed, 17 September 2008 22:36 Go to previous message
Messages: 24975
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the Posting Guidelines as stated in URL above

As a general rule you are precluded & prevented from exporting from a higher version & importing into a lower version.
The higher version could contain data types & objects which simply do not exist & are not supported in the lower version.
Previous Topic: Control File for Listener.log
Next Topic: Create a External Table in Oracle 10g:==> ERROR: KUP-01005
Goto Forum:

Current Time: Fri Oct 28 15:39:27 CDT 2016

Total time taken to generate the page: 0.12999 seconds