Table Rebuild Options

I have a table that uses a lob column that was setup incorrectly(32k chunk size, 50 PCTVERSION for rows with an average length of 400). The table has been running this way for quite some time and has grown significantly. This is within an oracle 8.0.4 database and I don't believe there is any way to rebuild the lob segment(if there is, please inform me). So based on that assumption, I am going to rebuild the table with more optimal lob settings. Unfortunately, this table has a primary key that is referenced as a foreign key within many tables. This table also has some columns that are part of some indexes.

Now my question, is the simplest way to rebuild this table in 8.0.4 to just disable the constraints, drop the indexes, move the data out via export or just to another table, then drop the table, create the new table with the same name and same settings, then put the data back and enable constrants and create indexes? I am prepared to go this route, but wanted to ask and make sure I didn't have any other options before proceding. Thanks for any help you can provide.

Joe Received on Tue Apr 08 2003 - 22:44:33 CDT