Moving table to another tablespace

Hi,
What is the best way to move a table ( or several tables) from one tablespace to another? I would like to avoid the obvious - creating the table structure in the new tablespace with a different name, and using 'insert into....' statements to populate it with the data from the original table, dropping the original and renaming the new one....

Any other way?

Thanks,
John Greco
System : Oracle 7.3, Netware 4.11

Reply here or email to : john.greco_at_dot.state.mn.us

Thanks.... Received on Mon Jul 27 1998 - 11:32:13 CDT