Home » RDBMS Server » Server Administration » Create Database Working
Create Database Working [message #251627] Sun, 15 July 2007 12:55 Go to next message
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
Re: Create Database Working [message #251630 is a reply to message #251627] Sun, 15 July 2007 13:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Create Database Working [message #254862 is a reply to message #251630] Sun, 29 July 2007 13:03 Go to previous messageGo to next message
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
Re: Create Database Working [message #254863 is a reply to message #254862] Sun, 29 July 2007 13:16 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't need any dictionary to know if the syntax of a statement is valid or not.

Regards
Michel
Previous Topic: A very confusing ORA-22930 for UTL_FILE_DIR
Next Topic: Bitmaps and Freelists
Goto Forum:
  


Current Time: Sat Dec 03 01:31:39 CST 2016

Total time taken to generate the page: 0.19773 seconds