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 .

Thanks
Debojyoti .

mallikarjunreddy

• Nov 9th, 2011

 

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

Thanks,
Mallikarjunreddy.

rohan makode

• Feb 25th, 2012

 

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

remil chalat

• May 2nd, 2012

 

We can use dbms_redefinition package to achieve this

chandrasekar.s

• Jun 1st, 2012

 

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

Code
SQL>create TABLE t1 


unrecoverable AS SELECT * FROM other_schema.t1;


 

Nony

• Oct 7th, 2012

 

alter table move tablespace USERS