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 #122294]

Sun, 05 June 2005 04:55

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 #122358 is a reply to message #122294]

Mon, 06 June 2005 02:56

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 #123416 is a reply to message #122358]

Mon, 13 June 2005 06:50

venu_jill
Messages: 1
Registered: June 2005
Location: mumbai

Junior Member

I want to configure Oracle HTML DB on Oracle 10g. will any one provide me the setp by step Oracle HTML DB configuration documentation. or provide me the site where i can get the related documentation.

Report message to a moderator

Re: Database creation script [message #123423 is a reply to message #122294]

Mon, 13 June 2005 07:36

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

http://download-west.oracle.com/docs/html/B13806_02/install.htm#CJADJEEI

Report message to a moderator

Previous Topic:	Index-- 4 question
Next Topic:	Search in kdisti

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:19:54 CDT 2024