OraFAQ Forum: Server Administration » Sample of a create database statement defining control file

Home » RDBMS Server » Server Administration » Sample of a create database statement defining control file

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

Sample of a create database statement defining control file [message #144041]

Mon, 24 October 2005 15:34

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Can someone post a sample 'Create database' statement that specifies where the control files will go and what they are named. I do not want to use the dbca.

Report message to a moderator

Re: Sample of a create database statement defining control file [message #144042 is a reply to message #144041]

Mon, 24 October 2005 15:38

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Sorry, Version 10.2.0.1 for Solaris 64 bit.

Report message to a moderator

Re: Sample of a create database statement defining control file [message #144050 is a reply to message #144041]

Mon, 24 October 2005 16:34

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

I have:
create database os2t102
user sys identified by <apw>
user system identified by <apw>
logfile group 1 ('/u01/oradata/os2t102/log/log01a.log') size 100M,
group 2 ('/u02/oradata/os2t102/log/log02a.log') size 100M,
group 3 ('/u03/oradata/os2t102/log/log03a.log') size 100M
maxlogfiles 20
maxlogmembers 3
maxloghistory 10
maxdatafiles 200
maxinstances 1
character set WE8ISO8859P1
national character set al16utf16
datafile '/u04/oradata/os2t102/system/system01.dbf' size 512M reuse
autoextend on next 10240K maxsize unlimited
extent management local
sysaux datafile '/u01/oradata/os2t102/ts/sysaux01.dbf' size 512M reuse
autoextend on next 10240K maxsize unlimited
default temporary tablespace temp
tempfile '/u04/oradata/os2t102/temp/temp01.dbf' size 100M reuse
autoextend on next 100M maxsize unlimited
extent management local
undo tablespace undotbs
datafile '/u04/oradata/os2t102/ts/undotbs01.dbf'
size 1024M reuse autoextend on maxsize unlimited
;

Report message to a moderator

Re: Sample of a create database statement defining control file [message #144052 is a reply to message #144041]

Mon, 24 October 2005 17:19

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

Well, I just could not get my create db statement to work so I used the dbca and netca...

Report message to a moderator

Re: Sample of a create database statement defining control file [message #144110 is a reply to message #144052]

Tue, 25 October 2005 02:08

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

controlfile names & locations are specified in the init.ora file & not in create database statement.

Report message to a moderator

Previous Topic:	Information of database creating using database Scripts?
Next Topic:	removing enterprise options

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:33:42 CST 2025