| catproc.sql [message #37905] |
Tue, 05 March 2002 19:57  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
|
What is achieved by running the catproc.sql and catalog.sql? Does running these two scripts often improve the performance of my database?
|
|
|
|
| Re: catproc.sql [message #37908 is a reply to message #37905] |
Tue, 05 March 2002 21:12  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
catalog.sql - database dictionary, which is used for all database activities. After create new database manually then you need to run this script under sys user.
catproc.sql - for PL/SQL . If you want to use PL/SQL in your database then you need to run this scrip.
catparr.sql - Parrallel Server.
catrep.sql - Replication server.
cataudit.sql - Auditing in database.
Note: these information can find in manual.
Hope this is helping.Thank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
