Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump

Nigel GardnerDec 4 2024

Hi

I am currently exporting schemas from a Datawarehouse from 11G to 19C.

We have an old schema called DIP which I believe is an Oracle system user in 19C (Directory Integration Platform).

I was planning to rename it during import but I can't export it, when I run impdp from 11g I get ORA-39165 schema DIP not found.

There are many partitioned tables in the schema which makes it messy using dbms_metadata to extract the metadata to create a new schema from our DIP schema.

Any advice on this?

Thanks

Nigel

Comments
Post Details
Added on Dec 4 2024
3 comments
256 views