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
______________________________________________________________________

Oracle LazyDBA home page