Can't move tables with columns of type long

When issuing the command "alter table THIS_TABLE move tablespace ANOTHER_TS" this command fails when the table has columns of type long or lob. This is annoying me for a while now.

How can recreate such tables in a different tablespace with "normal" SQL commands? And what should I be aware of? What about constaints, triggers, indexes related to this table? Which will be the availability impact while recreating the table in another tablespace?

Please consider that I am not acquainted with the data as such. I don't do any development work and refrain myself from doing anything that put the logic of relations in the DB in danger. (I must recognize that this is also due to my lack of skillness in this area). I am the Unix and DB admin and just keep things working. Recently I had to reorganize the whole DB because this collegues of mine doing development work quite soon rendered the DB almost unusuable (fragmentation, migrated rows etc.).

Thanks

Rick Denoire Received on Sun May 11 2003 - 15:39:55 CDT