Home » RDBMS Server » Server Utilities » shifting of table from one tablespace to another
shifting of table from one tablespace to another [message #368175] Fri, 22 September 2000 02:22 Go to next message
Rajendra
Messages: 23
Registered: September 2000
Junior Member
hi all,
I have a problem.I want to shift a table from one table space to another.Pls somebody help me.
thanks in advance.
Re: shifting of table from one tablespace to another [message #368183 is a reply to message #368175] Tue, 26 September 2000 05:46 Go to previous message
satish
Messages: 112
Registered: September 2000
Senior Member
Rajendra,
This can be carried out by carrying out the following
steps:
Say U want a table XYZ in tablespace DATA_Small to be
copied to tablespace DATA_Large then
1. Create table ABC as select * from XYZ tablespace
DATA_Large NOLOGGING
2. Check whether the table ABC has been created and
also the row count.
3. Drop the table XYZ (which is there in tablespace
DATA_Small)
4. rename the table ABC to XYZ

There are advantages of Nologging as the table would
be created faster as no entry would be logged in the
redo log. If possible use parallel option during table
creation.
This would be a fast way to shift a table from one
tablespace to anaother.

Satish
Previous Topic: Help:Net8 Assistant can't run???
Next Topic: Control File Problem
Goto Forum:
  


Current Time: Fri Mar 29 00:08:54 CDT 2024