I have 4 table(s) in a database that are showing a high number of chained rows, should I :
-open the database in mount mode, export the table(s), truncate the table & import the data back in
-open the database in mount mode, use the TOAD rebuild table utility to build the script, and run the script?
The latter seems like a lot simpler/faster process, but are there any potential pitfalls?
What is the best method to determine the optimal PCTFREE for these tables to prevent this in the future?
thanks in advance
Click Here to Expand Forum to Full Width