-
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
-
have you started in nomount first? also can't have spaces between lines
-
Make sure you have stopped/destroyed/killed any previous incarnations of your database first. You can't do create database twice.
Start with this, then modify it for your system.
set echo on
set termout on
spool createdb00_01.log
connect internal/oracle
startup nomount pfile=(path to the init.ora file)
create database db00
logfile
group 1 ('D:\ORACLE\admin\db00\redo_01a.log',
'D:\ORACLE\admin\db00\redo_01b.log'
) size 100K,
group 2 ('D:\ORACLE\admin\db00\redo_02a.log',
'D:\ORACLE\admin\db00\redo_02b.log'
) size 100K
maxlogfiles 32
maxlogmembers 2
maxloghistory 1
datafile 'D:\ORACLE\admin\db00\system01.dbf'
size 75M
maxdatafiles 254
maxinstances 1;
spool off
[Edited by stecal on 10-15-2002 at 06:04 PM]
-
CREATE DATABASE [database]
{ USER SYS IDENTIFIED BY password
| USER SYSTEM IDENTIFIED BY password
| CONTROLFILE REUSE
| LOGFILE [GROUP integer] redo_log_file_spec
[, [GROUP integer] redo_log_file_spec]...
| MAXLOGFILES integer
| MAXLOGMEMBERS integer
| MAXLOGHISTORY integer
| MAXDATAFILES integer
| MAXINSTANCES integer
| { ARCHIVELOG | NOARCHIVELOG }
| FORCE LOGGING
| CHARACTER SET charset
| NATIONAL CHARACTER SET charset
| DATAFILE datafile_tempfile_spec [, datafile_tempfile_spec]...
| EXTENT MANAGEMENT LOCAL
| default_temp_tablespace
| undo_tablespace_clause
| set_time_zone_clause
}...
;
http://tahiti.oracle.com/pls/db92/db...?section=98451
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
|