Pb creating database
Date: 30 Jul 2002 08:26:03 -0700
Message-ID: <3fb1217b.0207300726.5d36c17e_at_posting.google.com>
I have this error while creating a database:
sqlplus /nolog
where crebas.sql contains:
SVRMGR> connect / as sysdba
SVRMGR> startup nomount
ORACLE instance started.
Total System Global Area 139685872 bytes
Fixed Size 69616 bytes
Variable Size 88752128 bytes
Database Buffers 50331648 bytes
Redo Buffers 532480 bytes
SVRMGR> _at_crebas.sql
CREATE DATABASE test
*
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 4068
ORA-01527: error while reading file
ORA-07243: sftget: supplied buffer not big enough to hold entire line.
Additional information: 8190
CREATE DATABASE test
MAXINSTANCES 1
MAXLOGFILES 5
CHARACTER SET US7ASCII
DATAFILE '/opt/oracle/OraHome1/oradata/test/system01.dbf' SIZE 80M
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/opt/oracle/OraHome1/oradata/test/temp.dbf' SIZE 5M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 64K
LOGFILE '/opt/oracle/OraHome1/oradata/test/redo01.log' SIZE 512k,
'/opt/oracle/OraHome1/oradata/test/redo02.log' SIZE 512k,
'/opt/oracle/OraHome1/oradata/test/redo03.log' SIZE 512k;
--------------------------
Received on Tue Jul 30 2002 - 17:26:03 CEST