Oracle Database Discussions

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!

expdp > How to recplace every DB objects within schema

3528418Jan 23 2018 — edited Jan 25 2018

Hi Team,

DB Env: Oracle 11g R2

I want to import whole scheme (everything like table and its data, views, packages, sequence, trigger etc) from dump files of another DB server.

Source Schema: SchemaA

Target Schema: SchemaB

Using impdp command like this ...

----------

impdb SchemaA/password@SchemaA REMAP_SCHEMA=SchemaA:SchemaB directory=DirName PARALLEL=10 CLUSTER=N TABLE_EXISTS_ACTION=REPLACE DUMPFILE=DumpFile_17jan18%U.dmp LOGFILE=LogFile_imp_23Jan18.log

----------

But from initial logs its look like is not replacing sequences...

Can you guys tell me how to replace every db objects within schema.

Any hint is helpful.

Regards

This post has been answered by John Thorton on Jan 23 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2018

Added on Jan 23 2018

#general-database-discussions, #import

7 comments

429 views