Problem witch create database

From: Fibre Optic <fibre_optic_at_go2.pl>
Date: Fri, 29 Aug 2003 01:56:03 +0200
Message-ID: <bim4sf$qjm$1@atlantis.news.tpi.pl>

Hello,

I am trying to create database witch such a SQL command:

REATE DATABASE testdb
  USER SYS IDENTIFIED BY abc123
  USER SYSTEM IDENTIFIED BY abc123

  LOGFILE GROUP 1 ('/ora01/oracle/oradata/testdb/redo01.log') SIZE 25M,
          GROUP 2 ('/ora01/oracle/oradata/testdb/redo02.log') SIZE 25M,
          GROUP 3 ('/ora01/oracle/oradata/testdb/redo03.log') SIZE 25M

  MAXLOGFILES 5
  MAXLOGMEMBERS 5
  MAXLOGHISTORY 1
  MAXDATAFILES 100
  MAXINSTANCE 1
  CHARACTER SET US7ASCI
  NATIONAL CHARACTER SET AL16UTF16
  DATAFILE '/ora01/oracle/oradata/testdb/system01.dbf' SIZE 50M REUSE   EXTENT MANAGEMENT LOCAL
  DEFAULT TEMPORARY TABLESPACE tempts1

        DATAFILE'/ora01/oracle/oradata/testdb/temp01.dbf'
        size 10M REUSE
  UNDO TABLESPACE undotbs
        DATAFILE'/ora01/oracle/oradata/testdb/undotbs0101.dbf'
        SIZE 20M REUSE AUTOEXTEND ON NEXT 2048K MAXSIZE UNLIMITED;

And I can see such a message in Sqlplus:

SQL> @/ora01/testdb.sql

    DATAFILE '/ora01/oracle/oradata/tesdb/temp01.dbf' SIZE 10M REUSE     *
ERROR at line 17:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE SQL> Where is bug ???

For any help big thanks !!!

Thanks,
Fibre Optic Received on Thu Aug 28 2003 - 18:56:03 CDT