There's a missing ' on line 15!!
Ian
Work: 0151 235 2657
Mobile: 07725 667438
-----Original Message-----
From: Hooper Paul
[mailto:oracledba-ezmlmshield-x27195467.[Email address protected]
Sent: 02 November 2005 13:53
To: LazyDBA Discussion
Subject: RE: Create Database
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
______________________________________________________________________
--------
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
*****************************************************************************
This email and its attachments are confidential and are intended for the above named recipient only. If this has come to you in error, please notify the sender immediately and delete this email from your system. You must take no action based on this, nor must you copy or disclose it or any part of its contents to any person or organisation. Statements and opinions contained in this email may not necessarily represent those of Littlewoods Shop Direct Group Limited or its subsidiaries. Please note that email communications may be monitored. The registered office of Littlewoods Shop Direct Group Limited is 100 Old Hall Street Liverpool L70 1AB registered number 5059352
*****************************************************************************
This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com
Oracle LazyDBA home page