OraFAQ Forum: Server Utilities » move data from one schema to another

Home » RDBMS Server » Server Utilities » move data from one schema to another (10.2)

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

move data from one schema to another [message #576756]

Thu, 07 February 2013 14:27

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

I am trying to move data from one schema in database A to another schema in database B and only move data not others (procedure,view,function...). What is the best way to do it? I am thinking database link then insert into select from database link. Is there a better way?

Thanks!!

Report message to a moderator

Re: move data from one schema to another [message #576757 is a reply to message #576756]

Thu, 07 February 2013 14:29

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Exp/expdp and imp/impdp should work. These are meant for this purpose.

Report message to a moderator

Re: move data from one schema to another [message #576759 is a reply to message #576756]

Thu, 07 February 2013 14:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>Is there a better way?
quantify better

which metric measures better?

export & import is an alterntive

Report message to a moderator

Re: move data from one schema to another [message #576760 is a reply to message #576757]

Thu, 07 February 2013 14:35

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

I am thinking about expdp and impdp too, but how do you only import data without procudure, view....?

[Updated on: Thu, 07 February 2013 14:35]

Report message to a moderator

Re: move data from one schema to another [message #576762 is a reply to message #576760]

Thu, 07 February 2013 14:38

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

Senior Member
Account Moderator

Use INCLUDE option.

Regards
Michel

Report message to a moderator

Re: move data from one schema to another [message #576763 is a reply to message #576760]

Thu, 07 February 2013 14:41

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#IncludeExclude

Report message to a moderator

Re: move data from one schema to another [message #576764 is a reply to message #576756]

Thu, 07 February 2013 14:42

william7001
Messages: 8
Registered: October 2009
Location: MD

Junior Member

I do not want to change procedure, view or fuctions in new DB, but only data. Will following works?

impdp .... Content=data_only

Report message to a moderator

Re: move data from one schema to another [message #576766 is a reply to message #576764]

Thu, 07 February 2013 15:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

EXCLUDE
Exclude specific object types.
For example, EXCLUDE=SCHEMA:"='HR'".

Report message to a moderator

Re: move data from one schema to another [message #576767 is a reply to message #576764]

Thu, 07 February 2013 15:07

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

Senior Member
Account Moderator

Do you read what we post you?

Regards
Michel

Report message to a moderator

Previous Topic:	System crashed
Next Topic:	ORA-00904: "POLTYP": invalid identifier

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 29 21:58:45 CDT 2023