how eliminate the tables and index fragements
dear all:
solaris and oracle version 8.1.6.3
a table as a temporary table, when I load the data into the table, after other operation,I will delete all records. thus can fragement, how can I find the fragement level of the user schemas and how to eliminate the fragements!
please help me!
Re: how eliminate the tables and index fragements
Quote:
Originally posted by joyloce
dear all:
solaris and oracle version 8.1.6.3
a table as a temporary table, when I load the data into the table, after other operation,I will delete all records. thus can fragement, how can I find the fragement level of the user schemas and how to eliminate the fragements!
please help me!
Do you have any other objects in that tablespace? Instead of delete you can truncate the table and coalesce tablespace.
Sanjay