Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with create database

Need help with create database

Hi All
I am trying to create database and am getting the following error. Its on 11.11 and Oracle 9.2.0.4.

create database $ORACLE_SID
maxinstances 8
maxlogfiles 32
character set "US7ASCII"
national character set "AL16UTF16"
datafile '$ASMS_DB_ROOT_DIR3/ORACLE_SID/system01.dbf' size 250M reuse extent management local
undo tablespace undotbs datafile '$ASMS_DB_ROOT_DIR3/ORACLE_SID/undotbs01.dbf' size 200 reuse autoextend on next 5120k maxsize unlimited
TEMPORARY TABLESPACE TEMPTS1 DATAFILE
'$ASMS_DB_ROOT_DIR3/$ORACLE_SID/tempsys.dbf' size 200 reuse extent management local

logfile
Group 1 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0101.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0102.dbf') size 50M reuse,
Group 2 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0201.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0202.dbf') size 50M reuse,
Group 3 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0301.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0302.dbf') size 50M reuse,
Group 4 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0401.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0402.dbf') size 50M reuse,
Group 5 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0501.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0502.dbf') size 50M reuse,
Group 6 ('$ASMS_DB_ROOT_DIR3/${ORACLE_SID}redo/redolog0601.dbf',
'$ASMS_DB_ROOT_DIR2/${ORACLE_SID}redo/redolog0602.dbf') size 50M reuse;
exit
!
!


I get the following error.

DATAFILE '/u03/oradata/asmsdb/tempsys.dbf' size 200 reuse
*
ERROR at line 12:
ORA-25139: invalid option for CREATE TEMPORARY TABLESPACE

Never needed TEMP space in the create database

Thanks
Sushil Singh
5 REPLIES

Re: Need help with create database

Please ignore the previous message. It seems Oracle Administrator Guide has incorrect information.

Thanks
Sushil Singh
Michael Schulte zur Sur
Honored Contributor

Re: Need help with create database

Hi Sushil,

you still could create a default temporary tablespace as part of the create database.

Michael
Thierry Poels_1
Honored Contributor

Re: Need help with create database

hi,

how about
...
TEMPORARY TABLESPACE TEMPTS1 tempFILE
...

regards,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.

Re: Need help with create database

Hi Michale,
Thanks for the reply, for LMT it required that I created at temp space within the create database statement. Thanks

Hi Thierry,
You are right, I was missing the TEMPFILE. Thanks again.

Sushil
Michael Schulte zur Sur
Honored Contributor

Re: Need help with create database

Hi Sushil,

if your problem is solved, could you please award some points to those, who could help you?

greetings,

Michael