Re: Problem witch create database

Hi,

Bug is in your DEFAULT TEMPORARY TABLESPACE tempts1 DATAFILE'/ora01/oracle/oradata/testdb/temp01.dbf' clause.

This is the correct cluase...
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE'/ora01/oracle/oradata/testdb/temp01.dbf'

You cannot have DATAFILE cluase when you create temporary tablespace using TEMPORARY clause.

Thanks

Fibre Optic wrote:
> 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 Fri Aug 29 2003 - 02:35:15 CDT