Home » RDBMS Server » Backup & Recovery » DATA PUMP IMP & EXP
DATA PUMP IMP & EXP [message #264559] Mon, 03 September 2007 14:11 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
I want to export EMP table from SCOTT schema in STANDBY and
import it into PUBS schema in ORCL.

I need help please, possibly with the codes

Thanks.

Cherish
Re: DATA PUMP IMP & EXP [message #264566 is a reply to message #264559] Mon, 03 September 2007 14:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
exp owner=... / imp fromuser=... touser=...

Regards
Michel
Re: DATA PUMP IMP & EXP [message #264567 is a reply to message #264559] Mon, 03 September 2007 14:29 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
If you are incapable or unwilling to read how to solve your problem here:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm,
then I won't waste my time typing the same information here.
Re: DATA PUMP IMP & EXP [message #264592 is a reply to message #264567] Mon, 03 September 2007 21:18 Go to previous message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hey...

this may be helpful.
http://www.oracle.com/technology/pub/articles/10gdba/week4_10gdba.html
Regards,

mson77
Previous Topic: Logminer
Next Topic: FRA size issue
Goto Forum:
  


Current Time: Thu Dec 08 18:06:21 CST 2016

Total time taken to generate the page: 0.10553 seconds