Re: Help ...
From: Charles Dye <cdye_at_dnt.dialog.com>
Date: 1996/04/16
Message-ID: <4l0gsd$s93_at_iserv.dnt.dialog.com>#1/1
Date: 1996/04/16
Message-ID: <4l0gsd$s93_at_iserv.dnt.dialog.com>#1/1
Naren,
It looks like you are using too small a block size -- the failure happened when building an index on sys.ind$; key length cannot exceed block size. Did you do something like specify a 1K (or less) block size in your config.ora?
If that is not the problem, it could also be that the size of you system tablespace is too small -- try 40M as a mininum, also, your redo logs should be around 5M to 10M.
Regards,
Chas.
-- Chas. Dye Oracle Database Administrator Charles_Dye_at_krinfo.com In article <4kukkc$oq2_at_engnews2.Eng.Sun.COM>, NARENDRANATH KALLE <naren.kalle_at_Sun.COM> writes:Received on Tue Apr 16 1996 - 00:00:00 CEST
> Hi,
>
> Can any one help me with this :
>
> OS : Solaris 2.5
>
> Oracle 7.2.3
>
> >create database DELI
> logfile 'delhi1' size 100K,
>
> 'delhi2' size 100K
>
> datafile 'delhi_data' size 2M
>
> ORA-01501: CREATE DATABASE failed
>
> ORA-01519: error while processing file '?/dbs/sql.bsq' near line 334
>
> ORA-00604: error occurred at recursive SQL level 1
>
> ORA-01450: maximum key length (146) exceeded