OraFAQ Forum: Server Administration » CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ;

Home » RDBMS Server » Server Administration » CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; (ORA-02165: invalid option for CREATE DATABASE)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339912]

Sat, 09 August 2008 12:39

IT Guru
Messages: 59
Registered: January 2007

Member

ORACLE 9.0 Windwos XP 32 bit

Quote:

SQL> CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ;
CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL
*
ERROR at line 1:
ORA-02165: invalid option for CREATE DATABASE

But same command is working on Oracle 9.2 on Red hate Linux 4.5 ES

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339915 is a reply to message #339912]

Sat, 09 August 2008 13:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But same command is working on Oracle 9.2 on Red hate Linux 4.5 ES
Post proof, please.

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339917 is a reply to message #339915]

Sat, 09 August 2008 13:38

IT Guru
Messages: 59
Registered: January 2007

Member

Proof!!!!!!!!!!!!!!!!

I am just trying to create database with locally manage system tablespace.

Actually there is complete script. But this single line command also works with implicite OMF feature.

INITtest.ora

Quote:

db_name=test
compatible =9.0.0.0
log_archive_start=true
log_archive_format=arch%s.arc
log_archive_dest_1='LOCATION=j:\data\test\arc'
undo_management=auto
undo_tablespace=undo
control_files='j:\data\test\control.ctl'
background_dump_dest='j:\data\test\log'
user_dump_dest='j:\data\test\log'
core_dump_dest='j:\data\test\log'

Database creation script.

Quote:

CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL AUTOEXTEND ON
LOGFILE GROUP 1 'j:\data\test\Redo_1.dbf' size 10m,
GROUP 2 'j:\data\test\Redo_2.dbf' size 10m
UNDO TABLESPACE undo DATAFILE 'j:\data\test\undo.dbf' size 10m AUTOEXTEND ON
DEFAULT TEMPORARY TABLESPACE temp 'j:\data\test\temp.dbf' size 10m AUTOEXTEND ON
ARCHIVELOG ;

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339919 is a reply to message #339912]

Sat, 09 August 2008 13:48

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But same command is working on Oracle 9.2 on Red hate Linux 4.5 ES

Did you check SQL Reference?
Don't you think something that works in 9.2 may not work 9.0?

This topic deserves no answer. /forum/fa/1622/0/

Regards
Michel

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339923 is a reply to message #339919]

Sat, 09 August 2008 14:23

IT Guru
Messages: 59
Registered: January 2007

Member

agree.

But I have just started working as dba. need to catch so many things & cant alloccate time for reading document for every error.

thats y i have join this forum to get quick response & tips so I can establish as dba as early as my compnay want me too.

Report message to a moderator

Sat, 09 August 2008 14:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

IT Guru

Red hate Linux

I really wouldn't know whether reds hate Linux or not, but - as IT Guru - I think that you should pay more attention to naming operating systems you use. Because, it is the second thread I've seen you misspelled its name (so, just in case - it is Red Hat Linux).

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340327 is a reply to message #339917]

Tue, 12 August 2008 06:00

magic
Messages: 5
Registered: July 2007
Location: Slovakia

Junior Member

DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '...

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340345 is a reply to message #340327]

Tue, 12 August 2008 07:21

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is the relation between your answer and the question?

Regards
Michel

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340349 is a reply to message #339923]

Tue, 12 August 2008 07:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

>>cant alloccate time for reading document for every error.
Then you can't be become a good DBA.

>>thats y i have join this forum to get quick response & tips so >>I can establish as dba as early as my compnay want me too.
I would give you better choice instead of joining this for for quick response.

just hire a Good DBA which can able to read documentation and understand the thing about Database.

Don't take it personally. but you have to read documentation.

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340355 is a reply to message #340349]

Tue, 12 August 2008 07:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I would give you better choice instead of joining this for quick response.

just hire a Good DBA which can able to read documentation and understand the thing about Database.