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
Printable View
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
what do you mean "save an entire schema"?? you mean you have exported entire schema?Quote:
Today I used expdp to save an entire schema,
check out the logs what you exported and what you imported.
Thanks,
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.
there is NO such utilities (exportdp & importdp) in Oracle.Quote:
Actually, Export/Exportdp & Import/Importdp will take the meta data of the schema.
depends on the utility (exp / expdp) we can tell Oracle to export only meta data but that is not the default behaviour.
Thanks,