which script does Oracle run

[eastking]

Hi, I was asked a question in the free selftest software.

Which script creates the base data dictionary tables(eg. col$)?

the correct answer is as following.

sql.bsq.

But I think it should be catalog.sql.


Who can tell me why the correct is the one showed here.

[tycho]

Hello eastking,

The catalog.sql script calls a few scripts one off them calls the sql.bsq script.

The sql.bsq script specificly creates the base data dictionairy tables.

You can read the catalog.sql script with a simple editor this will tell you which scripts will be called.
Read these scripts too so you now the purpose of each.

Hope this helps

Tycho

[tycho]

Sorry.

It's the create database statement that calls the sql.bsq script as the first script to create the system tablespace and the base tables.

The catalog.sql is called later to create the views.

tycho

[eastking]

thank you