Home » RDBMS Server » Server Administration » Re: urgent: shifting of table from 1 tablespace to another
Re: urgent: shifting of table from 1 tablespace to another [message #369443] Fri, 22 September 2000 06:13
JOHN
Messages: 182
Registered: April 1998
Senior Member
Quick and dirty way is to change the table owner's default tablespace to the new tablespace -
- Create Table_A1 as select * from Table_A -
Drop Table_A - rename Table_A1 Table_A - change the owners default tablespace back.

Hope this helps
Previous Topic: how do I....?
Next Topic: Does anyone know if you can get a record from a dynamic query cursor?
Goto Forum:
  


Current Time: Thu Mar 28 14:44:19 CDT 2024