OraFAQ Forum: Server Administration » Create Database Working

Home » RDBMS Server » Server Administration » Create Database Working

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

Create Database Working [message #251627]

Sun, 15 July 2007 12:55

shrivijayan
Messages: 4
Registered: July 2007

Junior Member

Hi everybody,
This is my first mail to the community. Can anyone explain me how the "Create database" command works (in architecture level) since for validating the command no data dictionary will be there.

Is there any online reference to clarify this.

Regards,
Mani

Report message to a moderator

Re: Create Database Working [message #251630 is a reply to message #251627]

Sun, 15 July 2007 13:49

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

Senior Member
Account Moderator

CREATE DATABASE creates the dictionary and all the objects you give in CREATE DATABASE statement.
To create the dictionary, Oracle uses the sql.bsq file.

Regards
Michel

Report message to a moderator

Re: Create Database Working [message #254862 is a reply to message #251630]

Sun, 29 July 2007 13:03

shrivijayan
Messages: 4
Registered: July 2007

Junior Member

Thanks Michel,

Before it executes the sql.bsq file, the "Create database" command should be validated with correct syntax and how this happens without the data dictionary???

Regards,
Mani

Report message to a moderator

Re: Create Database Working [message #254863 is a reply to message #254862]

Sun, 29 July 2007 13:16

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

Senior Member
Account Moderator

You don't need any dictionary to know if the syntax of a statement is valid or not.

Regards
Michel

Report message to a moderator

Previous Topic:	A very confusing ORA-22930 for UTL_FILE_DIR
Next Topic:	Bitmaps and Freelists

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 03:29:28 CST 2025