Re: Coalesce prior to Version 7.3

John Durst wrote:
>
> I remember a while back using an alter system (or alter session?) command
> to coalesce a tablespace in versions prior to 7.3. I called oracle
> support and they said there was no such option prior to 7.3. I know I am
> not crazy (or at least not mistaken) so does anyone know what the command
> is. It had something to do with specifying the file# of the datafile if I
> recall correctly.
>
> Thanx,
> John DurstDEAR JOHN

I THINK THIS IS WHAT YOU ARE AFTER :-    ALTER SESSION SET EVENTS 'IMMEDIATE TRACE NAME COALESCE LEVEL 1'; HOPE THAT HELPS. ALPESH MISTRY Received on Wed Dec 11 1996 - 00:00:00 CET