OraFAQ Forum: Server Administration » Database creation script

Home » RDBMS Server » Server Administration » Database creation script

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

Database creation script [message #122295]

Sun, 05 June 2005 04:56

papu
Messages: 27
Registered: March 2005
Location: Dhaka

Junior Member

hi all,
i'have two questions.

can i change the db sid after database creation.

i want to create a database manually. can anyone supply me a Database creation script.

regards

papu

Report message to a moderator

Re: Database creation script [message #122301 is a reply to message #122295]

Sun, 05 June 2005 08:56

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

Senior Member

can i change the db sid after database creation.
Yes

i want to create a database manually. can anyone supply me a Database creation script.

Simplest way is to issue command "create database"

For more details on Database creation pls visit:
http://www-rohan.sdsu.edu/doc/oracle/server803/A54641_01/ch2.htm

Report message to a moderator

Re: Database creation script [message #122359 is a reply to message #122295]

Mon, 06 June 2005 02:57

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/vobs/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/vobs/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/vobs/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/vobs/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
DATAFILE '/vobs/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/vobs/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;

Report message to a moderator

Re: Database creation script [message #123260 is a reply to message #122359]

Fri, 10 June 2005 17:43

mbartov
Messages: 4
Registered: June 2005
Location: Dallas, TX

Junior Member

I just posted a new set of graphical tools to manage, monitor and tune the oracle database.
One of the many functions is to help generate a script to create a database. Another function generates a script to clone a datbase, a way to change an SID after creating a database.
It is free and can be downloaded from www.odbtools.com (www.odbtools.com/download.htm). I will greatly appreciate any suggestions.

Report message to a moderator

Re: Database creation script [message #123297 is a reply to message #123260]

Sat, 11 June 2005 09:46

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Your site doesn't seem to work with Mozilla.

MHE

Report message to a moderator

Re: Database creation script [message #123315 is a reply to message #123297]

Sat, 11 June 2005 13:27

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

Senior Member

I downloaded the tool for 9i on XP. It didn't worked for me. Gave me error about unrecognized database format for .mdb database.

Report message to a moderator

Re: Database creation script [message #123598 is a reply to message #122295]

Tue, 14 June 2005 02:08

lixinyu
Messages: 3
Registered: June 2005

Junior Member

papu wrote on Sun, 05 June 2005 05:26

hi all,
i'have two questions.

can i change the db sid after database creation.

i want to create a database manually. can anyone supply me a Database creation script.

regards

papu

1,
to change the db sid after database creation:
if you want to hold current datafiles, I think you need to recreate the controlfile using
"CREATE CONTROLFILE set DATABASE "databasename" "
you can get the script to recreate controlfile by
"alter database backup controlfile to trace", read the tracefile carefully.

and if you needn't hold current datafiles, just recrete database Cool

2, to create a database manually
here is a script to create a simplest database, do read carefully and chage it for you customization!

Attachment: CRE_DB.zip
(Size: 2.19KB, Downloaded 1137 times)

Report message to a moderator

Previous Topic:	What will happen if i change the IP address of my server on which database reside?
Next Topic:	Unable to see Trace file ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:35:32 CST 2025