Re: Max Extents reached !!

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 03 Mar 1999 15:30:22 +0800
Message-ID: <36DCE50E.7029@bhp.com.au>

John P. Higgins wrote:
>
> The myth lives on!
>
> John0725 wrote:
>
> > If possible, you really should rebuild your table so that all of the data can
> > fit into one extent. You can do so with the exp and imp utilites using the
> > parameter COMPRESS = Y.

I am sure that some people's dream database language would be:

create one_mega_extent size 10000000M;

create tablespace system in mega_extent; create tablespace rbs in mega_extent;
create tablespace tools in mega_extent; create tablespace data in mega_extent;
create tablespace index in mega_extent;

hee hee

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Wed Mar 03 1999 - 01:30:22 CST