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!

import schema data using oracle data pump

pikuNov 18 2013 — edited Nov 19 2013

Hi All,

I want to import One schema on one server using IMPDP. But on that server the user does not exists.is it possible to import all objects to that sever including creation the schema.In exp/imp it can be possible.But in data pump I can not do the same.Its giving the error that user does not exists.For your reference I am giving the below import code.

impdp system directory=DIR_DUMP logfile=expdp_tsadmin_tcgadmin_11182013_2_2.log

dumpfile=expdp_tsadmin_tcgadmin_11182013_2.dmp SCHEMAS=TS_ADMIN version= 10.1.0.2.0

Pls help and thanks in advance,

Thanks

piku

This post has been answered by Richard Harrison . on Nov 18 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2013

Added on Nov 18 2013

#database-key-features, #export-import-sql-loader-external-tables

15 comments

2,951 views