Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: import problems Solaris 8 and 8.1.7 - urgent
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:
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