Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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