Home » RDBMS Server » Server Utilities » move data from one schema to another (10.2)
move data from one schema to another [message #576756] Thu, 07 February 2013 14:27 Go to next message
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!!
Re: move data from one schema to another [message #576757 is a reply to message #576756] Thu, 07 February 2013 14:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Exp/expdp and imp/impdp should work. These are meant for this purpose.
Re: move data from one schema to another [message #576759 is a reply to message #576756] Thu, 07 February 2013 14:31 Go to previous messageGo to next message
BlackSwan
Messages: 23133
Registered: January 2009
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
Re: move data from one schema to another [message #576760 is a reply to message #576757] Thu, 07 February 2013 14:35 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use INCLUDE option.

Regards
Michel
Re: move data from one schema to another [message #576763 is a reply to message #576760] Thu, 07 February 2013 14:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#IncludeExclude
Re: move data from one schema to another [message #576764 is a reply to message #576756] Thu, 07 February 2013 14:42 Go to previous messageGo to next message
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

Re: move data from one schema to another [message #576766 is a reply to message #576764] Thu, 07 February 2013 15:05 Go to previous messageGo to next message
BlackSwan
Messages: 23133
Registered: January 2009
Senior Member
EXCLUDE
Exclude specific object types.
For example, EXCLUDE=SCHEMA:"='HR'".
Re: move data from one schema to another [message #576767 is a reply to message #576764] Thu, 07 February 2013 15:07 Go to previous message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you read what we post you?

Regards
Michel
Previous Topic: System crashed
Next Topic: ORA-00904: "POLTYP": invalid identifier
Goto Forum:
  


Current Time: Wed Dec 17 14:31:08 CST 2014

Total time taken to generate the page: 0.09294 seconds