This discussion is archived
2 Replies Latest reply: Oct 23, 2012 12:05 AM by AmitkumarSingh RSS

ORA-00901: invalid CREATE command

AmitkumarSingh Newbie
Currently Being Moderated
Hi,
I am trying to create the manuall database in 10G and execute the following command

1 CREATE DATABASE AKS
2 LOGFILE
3 GROUP 1('C:\oracle\product\10.2.0\oradata\aks\Redo01.log') SIZE 100m,
4 GROUP 2('C:\oracle\product\10.2.0\oradata\aks\Redo02.log') SIZE 100m,
5 GROUP 3('C:\oracle\product\10.2.0\oradata\aks\Redo03.log') SIZE 100m,
6 MAXLOGFILES 5
7 MAXLOGMEMBERS 5
8 MAXLOGHISTORY 1
9 MAXDATAFILES 100
10 MAXINSTANCES 1
11 DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\SYSTEM01.dbf' SIZE 325M
12 REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
13 UNDO TABLESPACE UNDOTBS1
14 DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\UNDOTBS1.dbf' SIZE 320M
15 REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
16 DEFAULT TEMPORARY TABLESPACE TEMP
17 TEMPFILE 'C:\oracle\product\10.2.0\oradata\aks\TEMP01.dbf' SIZE 200M
18* CHARACTER SET US7ASCII
19 /
CREATE DATABASE AKS
*
ERROR at line 1:
ORA-13504: No SYSAUX datafile clause specified


any body has any idea on this......

Thanks
  • 1. Re: ORA-00901: invalid CREATE command
    Veeresh.S Pro
    Currently Being Moderated
    add the below line in b/w 12th and 13th line in your create database statement
    SYSAUX DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\SYSAUX1.dbf' SIZE 320M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED


    your database creation statement should look something like below one

    DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\SYSTEM01.dbf' SIZE 325M
    REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
    SYSAUX DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\SYSAUX1.dbf' SIZE 320M
    REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED
    UNDO TABLESPACE UNDOTBS1
    DATAFILE 'C:\oracle\product\10.2.0\oradata\aks\UNDOTBS1.dbf' SIZE 320M
    REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    DEFAULT TEMPORARY TABLESPACE TEMP
  • 2. Re: ORA-00901: invalid CREATE command
    AmitkumarSingh Newbie
    Currently Being Moderated
    Thanks Veeresh

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points