|
|
| Re: shifting of table from one tablespace to another [message #368183 is a reply to message #368175] |
Tue, 26 September 2000 05:46  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
