|
Re: how to shift tables from one tablespace to another [message #369489 is a reply to message #369441] |
Sun, 01 October 2000 11:19 |
S. Vijaya Kumar
Messages: 5 Registered: September 2000
|
Junior Member |
|
|
Hi Alka,
You don't have any direct method. You can try any one of the following steps:
1. Create a temporary table and specify a tablespace for that based on the original table.
2. Drop the main table.
3. Rename the temporary table to main table.
2nd Method:
1. Export the original table.
2. Drop the table.
3. Import the table back into a differnt tablespace.
|
|
|