-
expdp: don't save some tables
Today I used expdp to save an entire schema, and I seen some tables (with USER_OBJECTS.DATA_OBJECT_ID is null) are not exported.
Why ?
Regards,
Dave
-
Today I used expdp to save an entire schema,
what do you mean "save an entire schema"?? you mean you have exported entire schema?
check out the logs what you exported and what you imported.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Today I used expdp to save an entire schema, and I seen some tables (with USER_OBJEC
Actually, Export/Exportdp & Import/Importdp will take the meta data of the schema.
After importing. you can able to see the the column with null values in the table.
Regards,
Anil.
-
Actually, Export/Exportdp & Import/Importdp will take the meta data of the schema.
there is NO such utilities (exportdp & importdp) in Oracle.
depends on the utility (exp / expdp) we can tell Oracle to export only meta data but that is not the default behaviour.
Thanks,
Last edited by vnktummala; 04-12-2010 at 08:15 AM.
Reason: typo
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|