OraFAQ Forum: Server Administration » creating one more database.

Home » RDBMS Server » Server Administration » creating one more database.

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

creating one more database. [message #176197]

Wed, 07 June 2006 05:33

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Dear Friends,my m/c has oracle 9i release 2 installed on windows xp.I want to create one more database with out any wizard,can you please assist in that

Report message to a moderator

Re: creating one more database. [message #176205 is a reply to message #176197]

Wed, 07 June 2006 05:55

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

Senior Member
Account Moderator

Well, whoever gives you script(s) which will create a database, actually IS a wizard. As I'm not the one, I can only suggest you to read how to do it.

Report message to a moderator

Re: creating one more database. [message #176342 is a reply to message #176205]

Thu, 08 June 2006 00:52

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Thanks for your advice,but i couldn't get much information from your link!that too for oracle 10g Sad

i am using oracle 9i release 2 in windows XP,anybody please suggest?

Report message to a moderator

Re: creating one more database. [message #176349 is a reply to message #176342]

Thu, 08 June 2006 01:25

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

Senior Member
Account Moderator

Link I provided takes you to the chapter "Creating an Oracle database". One of its sections is called "Manually Creating an Oracle Database". I believe that "without any wizard" means "manually". Does it not?

True, the link leads you to the 10g documentation. As you were given a hint what and where to search, why didn't you use Oracle documentation search capabilities and find the same chapter in Oracle 9i rel. 2 documentation? It exists. Therefore, click here for another spoonfeeding session.

Report message to a moderator

Re: creating one more database. [message #176606 is a reply to message #176197]

Thu, 08 June 2006 21:31

hmatijaca
Messages: 2
Registered: April 2005

Junior Member

Here we go a script for oracle 10G creating databases using a script, just of course modify it and make sure that ORACLE_SID is set
startup nomount pfile=/u01/app/oracle/product/10GR2/dbs/initHELT.ora
create database HELT
user sys identified by manager
user system identified by manager
controlfile reuse
maxdatafiles 500
maxinstances 2
maxlogfiles 30
datafile '/backup/oracle/HELT/system01.dbf' size 400M
sysaux datafile '/backup/oracle/HELT/sysaux.dbf' size 100M
default tablespace USERS datafile '/backup/oracle/HELT/data.dbf' size 20M
default temporary tablespace TEMP tempfile '/backup/oracle/HELT/temp.dbf' size
M
undo tablespace UNDOTBS1 datafile '/backup/oracle/HELT/undo.dbf' size 30M
character set UTF8
logfile
group 1 ('/backup/oracle/HELT/log_g1_m1.dbf') size 400M,
group 2 ('/backup/oracle/HELT/log_g1_m2.dbf') size 400M,
group 3 ('/backup/oracle/HELT/log_g1_m3.dbf') size 400M

Report message to a moderator

Previous Topic:	DBMS_SPACE or dba_segments
Next Topic:	Char(10) vs Varchar2(10)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 15:30:45 CST 2025