Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: import problems Solaris 8 and 8.1.7 - urgent

Re: import problems Solaris 8 and 8.1.7 - urgent

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Fri, 6 Dec 2002 10:46:34 +0100
Message-ID: <uv0snd6ga83197@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.

Did a little test yielding a similar message:



OID> create tablespace peter datafile
'/oradata/oid/peter.dbf' size 1m
uniform size 128k;

Tablespace created.

OID> create table p(a char(1000))
tablespace peter;

Table created.

OID> begin
for i in 1..1000 loop
insert into p values('a');
end loop;
end;
/

OID> /
begin
*
ERROR at line 1:
ORA-01653: unable to extend table SYSTEM.P by 16 in tablespace PETER ORA-06512: at line 3

OID> show parameter block_size
...

NAME                                 TYPE        VALUE
------------------------------------ ----------- ---------------------------
---
db_block_size                        integer     8192


extent_size/block_size=128/8=16 (blocks)

QED This does not necessarily mean the same applies for the ORA-1691, but it seems logical, don't you agree?

kind regards,
Peter

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> schreef in bericht news:E2F6A70FE45242488C865C3BC1245DA703012DB1_at_lnewton.leeds.lfs.co.uk...
> Hi Peter,
>
> 138254 is the number of BYTES not blocks isn't it ?
>
> 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: Peter van Rijn [mailto:p.vanrijnREMOVE_at_THISzhew.nl]
> Posted At: Wednesday, December 04, 2002 1:32 PM
> Posted To: server
> Conversation: import problems Solaris 8 and 8.1.7 - urgent
> Subject: Re: import problems Solaris 8 and 8.1.7 - urgent
>
>
> Dunno what your block size. If it's 8k you need 138254 * 8 = appr. 1Gb
> of
> *contiguous* free space. Are you sure that's available? Use
> DBA_FREE_SPACE
> to find out.
>
> hth,
> Peter
>
>
>
Received on Fri Dec 06 2002 - 03:46:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US