Remove the blank line above the datafile line.
-----Original Message-----
From: Hooper Paul
[mailto:oracledba-ezmlmshield-x84235457.[Email address protected]
Sent: Wednesday, November 02, 2005 8:36 AM
To: LazyDBA Discussion
Subject: Create Database
Hello,
Please can you help me as to why this is not working :
Running as oracle - sqlplus "/as sysdba"
-- Mount the database using the parameter file
startup nomount pfile=$ORACLE_BASE/LIONDEV1/pfile/initLIONDEV1.ora
CREATE DATABASE "LIONDEV1"
CONTROLFILE reuse
MAXDATAFILES 200
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P9
NATIONAL CHARACTER SET UTF8
LOGFILE
GROUP 1 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_01.dbf' ) size 128M REUSE ,
GROUP 2 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_02.dbf' ) size 128M REUSE ,
GROUP 3 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_03.dbf' ) size 128M REUSE ,
GROUP 4 (
'$ORACLE_BASE/LIONDEV1/redo/LIONDEV1_redo_04.dbf' ) size 128M REUSE
MAXLOGFILES 32
MAXLOGMEMBERS 7
MAXLOGHISTORY 100
DATAFILE '$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf' size
300M REUSE AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL
sysaux DATAFILE '$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf
size 300M REUSE AUTOEXTEND OFF
DEFAULT TABLESPACE data_01 DATAFILE
'$ORACLE_BASE/LIONDEV1/data/LIONDEV1_data_01.dbf' SIZE 500M
AUTOEXTEND ON NEXT 128M MAXSIZE 1000M EXTENT MAnAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temporary
TEMPFILE
'$ORACLE_BASE/LIONDEV1/temporary/LIONDEV1_temporary_01.dbf' size 500Me
500M AUTOEXTENT OFF
EXTENT MANAGEMENT LOCAL
UNDO TABLESPACE undo_01 DATAFILE
'$ORACLE_BASE/LIONDEV1/undo/LIONDEV1_undo_01.dbf' 100M
AUTOEXTENT OFF
Errors :
SQL> DATAFILE '$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf'
size 300M REUSE AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL
SP2-0734: unknown command beginning "DATAFILE '..." - rest of line
ignored.
SQL>
SQL> sysaux DATAFILE
'$ORACLE_BASE/LIONDEV1/data/LIONDEV1_system_01.dbf size 300M REUSE
AUTOEXTEND OFF
SP2-0734: unknown command beginning "sysaux DAT..." - rest of line
ignored.
SQL>
SQL> DEFAULT TABLESPACE data_01 DATAFILE
'$ORACLE_BASE/LIONDEV1/data/LIONDEV1_data_01.dbf' SIZE 500M
SP2-0734: unknown command beginning "DEFAULT TA..." - rest of line
ignored.
SQL> AUTOEXTEND ON NEXT 128M MAXSIZE 1000M EXTENT MAnAGEMENT LOCAL
SP2-0734: unknown command beginning "AUTOEXTEND..." - rest of line
ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL>
SQL> DEFAULT TEMPORARY TABLESPACE temporary
SP2-0734: unknown command beginning "DEFAULT TE..." - rest
Thanks
Paul Hooper
_Confidentiality notice: Whilst this company has procedures in place and
makes every effort to safeguard both Inbound and Outbound Emails, we cannot
guarantee that attachments are Virus - Free or compatible with your systems
and therefore we do not accept any liability in respect of viruses or
computer problems experienced. This e-mail and any files transmitted with it
are confidential and/or privileged. They are for the intended recipient
only. If you are not the intended recipient, you must not use, review,
distribute, disclose, alter, print, copy, transmit or rely on this e-mail
and any file transmitted with it. If you have received this e-mail and any
file transmitted with it in error please notify the sender or Mitsui
Sumitomo Insurance (London Management) Ltd Registered 4th Floor, 71
Fenchurch St, London, EC3M 4BS Company Number 1063340 email: [Email address
protected]
Syndicate 3210 (acting through its Managing Agent at Lloyd's), Mitsui
Sumitomo Insurance (London) Limited and Mitsui Sumitomo Insurance Company
Limited are all regulated by the Financial Services Authority.
_____________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page