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 #369455] Mon, 25 September 2000 19:40
Daniel Lim
Messages: 3
Registered: September 2000
Junior Member
Try doing this:

Create table new table storage(...) tablespace (new tablespace name) as select * from existing table ;

After doing so you may drop the existing table and rename the new table to the existing table name.
Hope this might help you.

Report message to a moderator

Previous Topic: Set Numwidth
Next Topic: Recycle of Sequence values
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 01:52:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.