-
Move a table from one schema to another
Hi all
I have TOAD related tables created under my application schema. I wanted to create a new schema called TOAD and move all TOAD table from the application owner schema into TOAD schema.
I know you can use the MOVE commnand to move tables from one tablespace to another. Can it be used as well in the context of one schema to another?
Please advise
Thanks
Last edited by Ablakios; 01-22-2004 at 12:40 AM.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
-
Re: Move a table from one schema to another
Originally posted by Ablakios
I know you can use the MOVE commnand to move tables from one tablespace to another. Can it be used as well in the context of one schema to another?
No
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Thanks for the response.
If I was to use the export/import with the fromuser=x touser=y .
It will import all of the table from user x to y, then I have to go back to x schema and drop all of the tables(about 70) that I do not want in that schema right ?
Is there any simplier way just get the 70 tables out of that schema rather the whole list of tables? I see that I have the
list the name of all the tables
tables= table1,table2,table3,table4xxxxxxxxx
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
-
use CTAS -> very simple..very fast..very relaiable
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
...else exp tables=(t1,t1..)
-
Thanks for the response.EXP/IMP worked just fine.
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|