Re: Coelesce Tablespace in 7.2?

David R. Gilbert wrote:
>
> Is there any way to force Oracle 7.2 to coelesce a
> tablespace right away?
>
> I know it's available in 7.3, but that's not an option
> for us right now.
>
> Thanks in advance.
>
> doc_at_balr.com
>
> --
> David Gilbert Internet: doc_at_balr.com, xanadu_at_mcs.net
> Consultant BALR Corporation - Information Technologies
> Web - PERSONAL: http://www.mcs.net/~xanadu WORK: http://www.balr.com

Hi.

Use the following. run as sys.

define ts_name = &tablespace_name
set heading off
set feedback off
set termout off
set verify off
spool /tmp/coal.sql
select 'alter session set events ''immediate trace name coalesce level '||ts#||''';'
from ts$
where name like upper('%&ts_name%')
/
spool off
set heading on
set feedback on
set termout on
set verify on
_at_/tmp/coal.sql Received on Tue Aug 20 1996 - 00:00:00 CEST