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)
CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #339912] Sat, 09 August 2008 12:39 Go to next message
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


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 Go to previous messageGo to next message
BlackSwan
Messages: 25039
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.
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 Go to previous messageGo to next message
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 ;
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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. ./fa/1622/0/

Regards
Michel

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 Go to previous messageGo to next message
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.
Not subject related; however ... [message #339924 is a reply to message #339912] Sat, 09 August 2008 14:44 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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).
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 Go to previous messageGo to next message
magic
Messages: 5
Registered: July 2007
Location: Slovakia
Junior Member
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '...
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question

What is the relation between your answer and the question?

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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.

Laughing
That's the most sensible advice that can be given.

Regards
Michel
Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340358 is a reply to message #340345] Tue, 12 August 2008 08:17 Go to previous messageGo to next message
magic
Messages: 5
Registered: July 2007
Location: Slovakia
Junior Member
Michel Cadot wrote on Tue, 12 August 2008 14:21
Question

What is the relation between your answer and the question?

Regards
Michel



there is wrong syntax in question:
DEFAULT TEMPORARY TABLESPACE temp 'j:\data\test\temp.dbf' size 10m AUTOEXTEND ON

so this can be ok Smile
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '...


[Updated on: Tue, 12 August 2008 08:18]

Report message to a moderator

Re: CREATE DATABASE test DATAFILE 'j:\data\test\systemp.dbf' size 10m EXTENT MANAGEMENT LOCAL ; [message #340373 is a reply to message #340358] Tue, 12 August 2008 08:42 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Who talk about TEMPORARY tablespace?
It is not in first post, OP adds it in his second post but this is not the root of the error.

Regards
Michel
Previous Topic: Problem with initjvm.sql and rmjvm.sql
Next Topic: Install/componet/init.ora pre-recs for Fine Grained Access (Row Level Security)
Goto Forum:
  


Current Time: Mon Dec 05 21:35:31 CST 2016

Total time taken to generate the page: 0.09260 seconds