Re: Problem witch create database

> 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 !!!

Fib Opt,
That must read

      TEMPFILE '/ora01/oracle/oradata/tesdb/temp01.dbf' SIZE 10M REUSE instead of

      DATAFILE ... I have the feeling I have seen the same bug in the 9.2 manual, so I guess you have copied from there.

See also http://www.adp-gmbh.ch/ora/admin/creatingdbmanually.html

hth,
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch