Re: unload/load

Sadagopan, Sathish, CFCTR wrote: > > Hi, > 1) I have a table in a dedicated dbspace with many chunks in the > dbspace.Since there has a been a lot of activity on that table of late , I > want to free up the many holes in the dbspace and force contiguity of data.I > cannot do an 'alter fragment' since I do not have enough log space to > prevent a long.Tx. > Setting LTAPEDEV to null is ruled out since the system is online. > Unload will create a file >2GB, Is there a workaround to tide over this > apart from writing a program to > unload the table in parts to several files and loading them in one after the > other. > 2)In this case the table does not have any referential constraints , what if > the table has associated referential constraints , do all the associated > tables need to be touched ? > Does 'set constraints deferred' help ? How would it help if I unload to > several files and reload them ? First, you can change LTAPEDEV for a running engine in online mode you just have to do it from onmonitor you cannot do it in the onconfig file directly. That does not however solve the logging problem any online rebuild, whether ALTER FRAGMENT or ALTER INDEX TO CLUSTER will create a mass of log entries. Can't you add several logical logs temporarily and drop them later when the rebuild is complete? Second, there should be no "holes" if the dbspace is truly dedicated to the one table unless you also have detached indexes on that table in the same dbspace? Otherwise you should have only one extent per chunk. What does oncheck -pT report about the table? I suspect you are getting yourself worked up over nothing. Art S. Kagel