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
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