Thanks,

Now this :

SQL> CREATE DATABASE "LIONDEV1"
2 CONTROLFILE reuse
3 MAXDATAFILES 200
4 MAXINSTANCES 1
5 CHARACTER SET WE8ISO8859P9
6 NATIONAL CHARACTER SET UTF8
7 LOGFILE
8 GROUP 1 (
'/vg_LION1/app/oracle/LIONDEV1/redo/LIONDEV1_redo_01.dbf' ) size 128M
REUSE ,
9 GROUP 2 (
'/vg_LION1/app/oracle/LIONDEV1/redo/LIONDEV1_redo_02.dbf' ) size 128M
REUSE ,
10 GROUP 3 (
'/vg_LION1/app/oracle/LIONDEV1/redo/LIONDEV1_redo_03.dbf' ) size 128M
REUSE ,
11 GROUP 4 (
'/vg_LION1/app/oracle/LIONDEV1/redo/LIONDEV1_redo_04.dbf' ) size 128M
REUSE
12 MAXLOGFILES 32
13 MAXLOGHISTORY 100
14 DATAFILE
'/vg_LION1/app/oracle/LIONDEV1/data/LIONDEV1_system_01.dbf' size 300M
REUSE AUTOEXTEND OFF EXTENT MANAGEMENT LOCAL
15 sysaux DATAFILE
'/vg_LION1/app/oracle/LIONDEV1/data/LIONDEV1_system_01.dbf size 300M
REUSE AUTOEXTEND OFF
16 DEFAULT TABLESPACE ts_data DATAFILE
'/vg_LION1/app/oracle/LIONDEV1/data/LIONDEV1_ts_data_01.dbf' SIZE 1M
17 AUTOEXTEND ON NEXT 128K MAXSIZE 200M EXTENT MANAGEMENT LOCAL
18 DEFAULT TEMPORARY TABLESPACE temporary
19 TEMPFILE
'/vg_LION1/app/oracle/LIONDEV1/temporary/LIONDEV1_temporary_01.dbf' size
500Me 500M AUTOEXTENT OFF
20 EXTENT MANAGEMENT LOCAL
21 UNDO TABLESPACE undo_01 DATAFILE
'/vg_LION1/app/oracle/LIONDEV1/undo/LIONDEV1_undo_01.dbf' 100M
22 AUTOEXTENT OFF
23 /
DEFAULT TABLESPACE ts_data DATAFILE
'/vg_LION1/app/oracle/LIONDEV1/data/LIONDEV1_ts_data_01.dbf' SIZE 1M
*
ERROR at line 16:
ORA-02165: invalid option for CREATE DATABASE


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