View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 04:15 AM
sandip
 
Posts: n/a
Default Change a table's tablespace

Hi,

i need to change the tablespace of a table, ie. use another tablespace
for the table and stop the use of the existing tablespace. Is there any
way i can accomplish this? One solution might be export the data from
the table, re-create the tables in the new tablespace, drop the
original tablespace and load the data. But i would prefer another
simple and less time-consuming way.

Any suggestions would be highly appreciated.

Thanks in advance,
Sandip.

Reply With Quote