Re: Large number of Tablespaces 8.1.6

I think the latest DLTs offer 70 - 75GB
with compression on a basic 35GB tape,
but I'm not too keen at this point to trust hardware compression to get much mileage because the way I've put the system
together I've packed the data space and
eliminated almost all chance of effective compression.

 I appreciate your problem with SAP -
On the other hand, partitioning is a physical thing, and SAP shouldn't need to know what you have done with your physical database.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Big Al wrote in message <399C4EDD.F22A2351_at_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