Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

9.2 create Database fails in sql.bsq

350803Sep 8 2003 — edited Sep 10 2003
I have installed Oracle 9.2.0.1.0. It appears to have installed correctly.

I am attempting to create a new database. The script sql.bsq in %ORACLE_HOME%\rdbms\admin appears to be trying to create a cluster around line 1329. I don't use clusters (per se).

I am rcving an the following error a trace file.
*** SESSION ID:(10.1) 2003-09-08 16:59:56.000
ORA-00604: error occurred at recursive SQL level 1
ORA-01569: data file too small for system dictionary tables
Offending statement at line 1332
create cluster c_cobj# (obj# number)
pctfree 0 pctused 50
/* space for: update cdef$ set condition = 'col IS NOT NULL' at // */
size 300
storage (initial 50K) /* avoid space management during IOR I */
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 1332
ORA-00604: error occurred at recursive SQL level 1
ORA-01569: data file too small for system dictionary tables

Can someone point me to an answer for this?

I have 2 95MB files being created in the system tablespace. and I can provide you either my create database script and/or my init.ora file, if they will assist.

Thnak you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2003
Added on Sep 8 2003
6 comments
649 views