Re: Coalesce Tablespace in 7.2?

From: John Verhoeven <johnv_at_acix.DIALix.oz.au>
Date: 1996/08/25
Message-ID: <johnv.09xs_at_acix.DIALix.oz.au>#1/1


In article dated Sat, 24 Aug 1996 03:52:49 -0400, Steve White (stwhite_at_amp.com) wrote:
> If you don't mind a little bit of 'strange' syntax, you can use the
> following command:
>
> alter session set events 'immediate trace name coalesce level TS#';
>
> where TS# is the tablespace number of the tablespace you want to
> coalesce.

[ deleted ]

> There is also a way to do it on 7.1.6, but that is a little more
> complex...

The 'alter session..' etc works just fine on Oracle 7.1.6.2. What other way is there to do it that is more complex under 7.1.6?

-- 
 _--_|\  John Verhoeven (johnv_at_acix.DIALix.oz.au or johnv_at_DIALix.oz.au)
/      \ >>>> Writing programs in assembler is like digging post <<<<
*_.--._/ >>>> holes with a teaspoon:  it takes a long time, but  <<<<
      v  >>>> you have complete control over all the dirt.       <<<<
Received on Sun Aug 25 1996 - 00:00:00 CEST

Original text of this message