Skip to Main Content
Forums

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!

Creating an Empty schema before Import

VitaminDApr 9 2010 — edited Apr 9 2010
DB version:11g

I used to create an empty schema using CREATE USER command before i did an import from a dump file.Today i ran the impdp command before creating the empty schema by accident. But everything seems to be fine.
I never knew that you don't have to create an empty user before import. Is this new from datapump? For Original Imp/exp, does this apply?
The newly created user even has the same default tablespace as the original one !
This post has been answered by Dean Gagne-Oracle on Apr 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2010
Added on Apr 9 2010
#database-key-features, #export-import-sql-loader-external-tables
3 comments
4,313 views