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
Re: Move a table from one schema to another
Quote:
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