Re: Compact Oracle Database (Shrink it using SQL Plus)

Hi there,

  Or you can use BMC SQL ReOrg ($$$) to do the hot reorg for you.

 To Howard,

>> However, you could also make all your data
>> files autoextensible for the purposes of import only (alter database
>> datafile 'etc etc etc' autoextend on), and then when all the data is back,
>> change all the files to being 'autoextensible off'

  I think this is a few rare ocassions that I will ever use AUTOEXTEND ON.   

Allan W. Tham
DBA Received on Thu Nov 01 2001 - 03:59:37 CST