"Fibre Optic" <fibre_optic_at_go2.pl> wrote in message
news:bim4sf$qjm$1_at_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
>
Are you sure you want us ascii 7 for your character set?
Jim
Received on Fri Aug 29 2003 - 06:03:49 CDT
