-
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
or
-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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|