Re: Large number of Tablespaces 8.1.6

From: Big Al <db-guru_at_att.net>
Date: Thu, 17 Aug 2000 20:46:41 GMT
Message-ID: <399C4EDD.F22A2351@att.net>

Jonathan Lewis wrote:
>
> Valid point.
>
> I'm just not keen on extremely large tablespaces.
> The 32Gb is an artificially limit based on the
> fact fact that I want to build a historical read-only
> library with one tablespace per DLT - and I want
> to GUARANTEE that a tablespace will always
> fit on a DLT.

How about with compression? I currently average better than 4:1 compression on export. You could use hardware compression on the DLT and conservatively double your tablespace sizes. Also, aren't there new DLT drives with a 70GB limit? I'm not a hardware guy but I seem to remember that.
>
> PS If I had a table over 50Gb, I would partition it.
Not currently available for SAP systems if you want SAP support.

Big Al Received on Thu Aug 17 2000 - 15:46:41 CDT