OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-02165 (Oracle 11g)

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

ORA-02165 [message #662423]

Mon, 01 May 2017 13:04

Gr8dba
Messages: 3
Registered: May 2017

Junior Member

Hi everyone,
I am creating an Oracle DB from scratch (command line) after running my sql script I get this error message:

SQL>@c:\oracle\scripts\createmydb.sql
undo tablespace undotbs datafile 'c:\app\brk\oradata\mydb\undotbs01.dbf' size 100m reuse
autoexend on next 5120k maxsize unlimited

ERROR at line 11:
ORA-02165: invalid option for CREATE DATABASE

please see what my input code on the "createmydb.sql" file looks like:

create database mydb
maxdatafiles 30
maxlogfiles 10
maxlogmembers 5
maxinstances 1
maxloghistory 1
datafile 'c:\app\brk\oradata\mydb\system01.dbf' size 300m reuse autoextend on next 10240k maxsize unlimited
extent management local
sysaux datafile 'c:\app\brk\oradata\mydb\sysaux01.dbf' size 120m reuse
default temporary tablespace temp tempfile 'c:\app\brk\oradata\mydb\temp01.dbf size 10m reuse autoextend on next 640k maxsize unlimited
undo tablespace undotbs datafile 'c:\app\brk\oradata\mydb\undotbs01.dbf' size 100m reuse autoextend on next 5120k maxsize unlimited
character set we8mswin1252
logfile group 1 ('c:\app\brk\oradata\mydb\redo01.log') size 10m,
group 2 ('c:\app\brk\oradata\mydb\redo02.log') size 10m,
group 3 ('c:\app\brk\oradata\mydb\redo03.log') size 10m;

I do not seem to know where the error is and how to fix it! Please help!

Report message to a moderator

Re: ORA-02165 [message #662424 is a reply to message #662423]

Mon, 01 May 2017 13:16

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

Senior Member
Account Moderator

You need to copy and paste your SQL*Plus session.
Either execute your statement at command line or "set echo on" in your script.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals, as solution depends on it.

[Updated on: Mon, 01 May 2017 13:17]

Report message to a moderator