create database script failed......
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: create database script failed......

Hybrid View

  1. #1
    Join Date
    Apr 2002
    Posts
    36
    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you started in nomount first? also can't have spaces between lines

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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]

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width