| Oracle 10g Data Pump [message #348630] |
Wed, 17 September 2008 07:58  |
@rpita
Messages: 7
Registered: February 2008
Location: Mumbai,India
|
Junior Member |
|
|
Hi,
Need help using the datapump utility.
1) If the source db from where the dump file was generated is version 10.2.0.4.0 and the destination db is 10.2.0.1.0, 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
"USERNAME"
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!
Thanks.
|
|
|
|
| Re: Oracle 10g Data Pump [message #348766 is a reply to message #348630] |
Wed, 17 September 2008 22:36  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
ttp://www.orafaq.com/forum/t/88153/0/
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
