How will you move a table from one schema to other ?

Showing Answers 1 - 6 of 6 Answers

Debojyoti Roy

  • Oct 22nd, 2011

Dear All,

As per my understanding , Inspite of "to move a table from one schema to another" , we can do it this way.

SQL> create table table1 unrecoverable as select * from other_schema.table1; [ By logging to Existing Table Schema ].

In case of, if there are another ways . Please let me know .

Debojyoti .

  Was this answer useful?  Yes


  • Nov 9th, 2011

We can use Export/Import tool to move a table from one schema to another schema.


  Was this answer useful?  Yes

rohan makode

  • Feb 25th, 2012

By creating a dump file of one schema and then exporting it to other schema

  Was this answer useful?  Yes

remil chalat

  • May 2nd, 2012

We can use dbms_redefinition package to achieve this

  Was this answer useful?  Yes


  • Jun 1st, 2012

Using alter table command we can move one table from one schema to other

  1. SQL>create TABLE t1

  2. unrecoverable AS SELECT * FROM other_schema.t1;


  Was this answer useful?  Yes


  • Oct 7th, 2012

alter table move tablespace USERS

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions