OraFAQ Forum: Backup & Recovery » DATA PUMP IMP & EXP

Home » RDBMS Server » Backup & Recovery » DATA PUMP IMP & EXP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DATA PUMP IMP & EXP [message #264559]

Mon, 03 September 2007 14:11

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

Report message to a moderator

Re: DATA PUMP IMP & EXP [message #264566 is a reply to message #264559]

Mon, 03 September 2007 14:27

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exp owner=... / imp fromuser=... touser=...

Regards
Michel

Report message to a moderator

Re: DATA PUMP IMP & EXP [message #264567 is a reply to message #264559]

Mon, 03 September 2007 14:29

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: DATA PUMP IMP & EXP [message #264592 is a reply to message #264567]

Mon, 03 September 2007 21:18

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

Report message to a moderator

Previous Topic:	Logminer
Next Topic:	FRA size issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 20:06:57 CDT 2024