import problems Solaris 8 and 8.1.7

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 6 Dec 2002 11:58:24 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70303BB7B@lnewton.leeds.lfs.co.uk>

Thanks gents - blocks it is then !

This means that Tom's original error message where there was insufficient room to create 138254 in the tablespace, and assuming an 8K block size (just for the hell of it) means that it is trying to create an extent of just over 1 GB. As each of his 12 datafiles are set to an Autoextend max size of 1GB, I don't think it will fit.

I'm with Niall on the COMPRESS=Y thing, time to get a shovel and visit the exporter for some therapy !

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Friday, December 06, 2002 10:50 AM Posted To: server
Conversation: import problems Solaris 8 and 8.1.7 - urgent Subject: Re: import problems Solaris 8 and 8.1.7 - urgent

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> wrote in message news:uv0snd6ga83197_at_corp.supernews.com...
> Hi Norman,
>
> Sorry, had a day off yesterday. I am pretty sure it is in blocks but
cannot
> find any evidence for it so far. Not on Metalink, not in the Oracle
doc's.
> They simply never tell us if we're dealing with blocks or bytes.

I believe that the following test demonstrates that Peter is correct. demo.txt is a 554k file. I have an 8k block size and a uniform extent size
in my lob tablespace of 128k or 16 blocks. There should be room for exactly
3 extents (if my maths is correct). The ora-01691 comes up with 16 when trying to allocate the 4th extent not 128k.( or170k which would be the amount of the clob not loaded again assuming I can add up). Any corrections/debunkings welcomed as usual.

<SNIP> Received on Fri Dec 06 2002 - 05:58:24 CST