Re: Help: Need to defrag a tablespace

If you are using 8i, the following excerpt from http://www.dbazine.com/foot2.html
may be of interest...

"ALTER TABLE MOVE Statement
If you are using Oracle8i, don't use the export/import utilities to change initial storage settings for a table, defragment it, or move it to a different tablespace. Oracle8i introduces the ALTER TABLE MOVE statement that allows administrators to move data from one tablespace to another and change initial storage settings while the table is online."

Theoretically, you can ALTER TABLE tablename MOVE; to "move" the table to the same tablespace it's already in. Of course, you can only use this option if you have enough space somewhere in the database to temporarily hold a copy of the table. This particular method was recommended to me by an Oracle instructor.

I have to admit that I haven't tried it myself yet... Received on Thu Jan 17 2002 - 09:02:13 CST