Move a table from one schema to another

[Ablakios]

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

[aspdba]

exp/imp

[abhaysk]

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

[Ablakios]

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

[abhaysk]

use CTAS -> very simple..very fast..very relaiable

[aspdba]

...else exp tables=(t1,t1..)

[Ablakios]

Thanks for the response.EXP/IMP worked just fine.