Home » RDBMS Server » Server Utilities » Moving tables between schemas using command line
Moving tables between schemas using command line [message #309595] Fri, 28 March 2008 01:43 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Moving tables between schemas using command line [message #309637 is a reply to message #309595] Fri, 28 March 2008 04:31 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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!
Re: Moving tables between schemas using command line [message #309691 is a reply to message #309595] Fri, 28 March 2008 08:23 Go to previous message
BlackSwan
Messages: 25046
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"?
Previous Topic: import
Next Topic: UTL_FILE question part 2
Goto Forum:
  


Current Time: Wed Dec 07 22:17:42 CST 2016

Total time taken to generate the page: 0.06598 seconds