OraFAQ Forum: Server Utilities » Moving tables between schemas using command line

Home » RDBMS Server » Server Utilities » Moving tables between schemas using command line

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

Moving tables between schemas using command line [message #309595]

Fri, 28 March 2008 01:43

andi_raj
Messages: 55
Registered: February 2008

Member

I don't want to start a new topic so i am continuing. Is it possible to export table from one schema to another schema using command line?After the purpose is over i dont want to keep the reduntant tables in the schema my application is using. so as a backup i want to push the data into another schema to keep it away from users. thanx in advance. raj

[Topic SPLIT by LF]

[Updated on: Fri, 28 March 2008 04:27] by Moderator

Report message to a moderator

Re: Import without dropping tables [message #309598 is a reply to message #309595]

Fri, 28 March 2008 01:47

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

Senior Member
Account Moderator

Start a new topic!
A topic is for ONE question and others very close.
This is not your case.
Start a new topic.

Regards
Michel

Report message to a moderator

Re: Moving tables between schemas using command line [message #309637 is a reply to message #309595]

Fri, 28 March 2008 04:31

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

Is it possible to export table from one schema to another schema using command line?

Export and Import ARE command line utilities (so the answer is obvious).

Quote:

I dont want to keep the reduntant tables in the schema

So drop them!

Report message to a moderator

Re: Moving tables between schemas using command line [message #309691 is a reply to message #309595]

Fri, 28 March 2008 08:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i dont want to keep the reduntant tables in the schema my application
How do you programatically identify which schemas are "redundant"?

Report message to a moderator

Previous Topic:	import
Next Topic:	UTL_FILE question part 2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:13:08 CDT 2024