topic Re: Need help with create database in Operating System - HP-UX

Need help with create database

Sushil Singh_1 — Thu, 06 Nov 2003 13:13:54 GMT

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

Re: Need help with create database

Sushil Singh_1 — Thu, 06 Nov 2003 13:35:49 GMT

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

Thanks
Sushil Singh

Re: Need help with create database

Michael Schulte zur Sur — Fri, 07 Nov 2003 08:32:58 GMT

Hi Sushil,

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

Michael

Re: Need help with create database

Thierry Poels_1 — Fri, 07 Nov 2003 08:47:24 GMT

hi,

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

regards,
Thierry.

Re: Need help with create database

Sushil Singh_1 — Sat, 08 Nov 2003 14:48:44 GMT

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

Re: Need help with create database

Michael Schulte zur Sur — Wed, 19 Nov 2003 12:16:44 GMT

Hi Sushil,

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

greetings,

Michael