I have a full expdp export of my database. How to recreate a user's schema ?
This is my first post here.
I am a bewbie in the world of Oracle administration.
I have an Oracle 10g database.
I have completed an expdp export full=Y.
I have another machine on which I will install the same version of Oracle as on the first server.
I want to replicate the schema of an user from the database (data+metadata) on the new server using impdp and the previously mentioned export.
I need instructions on how to create schema and all of the required steps in order to replicate a user's schema on the second server and be able to use it as if it were the one from which the export was made.
Pls. help and bear in mind that I am a beginner.
Tks. in advance
Click Here to Expand Forum to Full Width