Re: import problems Solaris 8 and 8.1.7 - urgent

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70303BB7B_at_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>

Thanks for all the info on this - As it happens i crated another datafile with an initial size of 1200 megs and a max size of 1500 megs and re ran the import. It faile dgain with the same message but this time got to just over 1600 rows imported - the table is just over 1900 currently.

I created another datafile with a initial and max size of 2 gigs and this time the import worked.

thanks for the input all

Tom Received on Sun Dec 08 2002 - 16:01:12 CST