About
Pricing
Community
Teams
Start Free Trial
Log in
YZlat
asked on
1/8/2013
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
Oracle Database
Unix OS
10
5
Last Comment
YZlat
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Steve Wales
1/8/2013
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
YZlat
1/8/2013
ASKER
I am just running throught the process for learning purposes. I have a test database on one server.
SOLUTION
Steve Wales
1/8/2013
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
YZlat
1/8/2013
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
Steve Wales
1/8/2013
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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
YZlat
1/8/2013
ASKER
so most likely I cannot do that as an oracle user or as myself?
Your help has saved me hundreds of hours of internet surfing.
fblack61
SOLUTION
Steve Wales
1/8/2013
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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
YZlat
1/8/2013
ASKER
OK, both exports worked for me, I just have to do imports now.
What about database cloning?
SOLUTION
Steve Wales
1/9/2013
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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
YZlat
1/10/2013
ASKER
Thanks for all your help!