-
I have created script to create database this way:
===========================================================
create database SPTC0542
maxdatafiles 80
maxlogfiles 32
maxlogmembers 2
maxloghistory 100
logfile
GROUP 1 ('c:\Oracle\ORADATA\SPTC0542\redolog0101.log') size 150k,
GROUP 2 ('c:\Oracle\ORADATA\SPTC0542\redolog0201.log') size 150k
datafile
'c:\Oracle\ORADATA\SPTC0542\system01.dbf' size 50M autoextend on
character set WE8ISO8859P1;
@c:\oracle\ora81\rdbms\admin\catalog.sql;
@c:\oracle\ora81\rdbms\admin\cataproc.sql;
===========================================================
However, when I tried to run it gave this error message:
===========================================================
SQLPLUS_2000>@c:\create.sql
SP2-0042: unknown command beginning "maxdatafil..." - rest of line ignored.
SP2-0042: unknown command beginning "maxlogfile..." - rest of line ignored.
SP2-0042: unknown command beginning "maxlogmemb..." - rest of line ignored.
SP2-0042: unknown command beginning "maxloghist..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0042: unknown command "logfile" - rest of line ignored.
SP2-0042: unknown command beginning "GROUP 1 ('..." - rest of line ignored.
SP2-0042: unknown command beginning "GROUP 2 ('..." - rest of line ignored.
SP2-0042: unknown command "datafile" - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
===========================================================
I have oracle 81 --8.1.5.0.0 version on Windows2000.
===========================================================
Please help me about this issue..........
===========================================================
I have tried different code
sqlplus>create database sptc0542;
===========================================================
that worked for me...... I wonder why it allowed me to create database without any parameters such as logfile,datafile
xuduro_2000
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|