asked on Oracle database exports and imports question
I need to learn how to do database exports and imports at user level and full ones.
Can someone guide me through the process?
I also need to learn how to clone a database using expdp/impdp
Can someone guide me through the process?
I also need to learn how to clone a database using expdp/impdp
Oracle DatabaseUnix OS
Last Comment
YZlat
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am just running throught the process for learning purposes. I have a test database on one server.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I just tried to run full export on my db and got permissions errors. What permissions does a user need to run a full database export?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
so most likely I cannot do that as an oracle user or as myself?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
OK, both exports worked for me, I just have to do imports now.
What about database cloning?
What about database cloning?
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for all your help!