Some Script Files

catalog.sql : sql.dsq creates the base tables. Base tables are not in the understandable format(tab

$,col$,priv$ etc).

Since base tables are not in the understandable format, we create views & synonyms on top of it.

catalog.sql creates views & synonyms.

 

catproc.sql : catproc.sql is going to create the predefined packages, procedures, functions etc.

e.g: dbms_output, dbms_job, dbms_schedular etc.

 

pupbld.sql : This script is going to create the predefined profile.