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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 29 00:08:23 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.