Link to home
Create AccountLog in
Avatar of YZlat
YZlatFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Steve Wales
Steve Wales
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of YZlat

ASKER

I am just running throught the process for learning purposes. I have a test database on one server.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of YZlat

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
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of YZlat

ASKER

so most likely I cannot do that as an oracle user or as myself?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of YZlat

ASKER

OK, both exports worked for me, I just have to do imports now.

What about database cloning?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of YZlat

ASKER

Thanks for all your help!