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

Showing Answers 1 - 0 of 0 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 .

Thanks
Debojyoti .

  Was this answer useful?  Yes

mallikarjunreddy

  • Nov 9th, 2011
 

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

Thanks,
Mallikarjunreddy.

  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

chandrasekar.s

  • Jun 1st, 2012
 

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


Code
  1. SQL>create TABLE t1

  2. unrecoverable AS SELECT * FROM other_schema.t1;

  3.  

  Was this answer useful?  Yes

Nony

  • 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