| table shift to another tablespace [message #130262] |
Fri, 29 July 2005 01:36  |
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
|
Member |
|
|
I have a table with the size of 50mb under 'ts1' tablespace. now 'ts1' tablespace doesnt have any freespace. so i am not able to insert any data into my table. i dont want to increase the size of ts1 tablespace.
How do i shift the whole table into another tablespace ts2 which has the capacity of 150mb free space.
what is the syntax to shift whole table into another tablespace?
Regards,
Praveen
|
|
|
|
|
|
| Re: table shift to another tablespace [message #130331 is a reply to message #130262] |
Fri, 29 July 2005 07:17  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Just to add, since you will be moving / rebuilding the table anyway, you can use the opportunity to change the storage parameters if you so desire. Also you'll need to rebuild indexes. Oh and if your table is one that is only added to, and you don't do updates or deletes on older existing data, you can probably compress the table during the move as well.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
