| catproc.sql has no such statement to recreate/creat package DBMS_STANDARD [message #69141] |
Tue, 06 November 2001 22:42  |
slimzhao
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
I check the directory $ORACLE_HOME/rdbms/admin and grep -i dbms_standard catproc.sql, there's no match about that. So, I think catproc.sql will not grantee the dbms_standard will be created/recreated properly.
My Question is : where the file dbms_standard.sql gone?
the file utlrp.sql contain one line refer that dbms_standard can be recreated by script dbms_standard.sql, but I can't find it in all my Oracle system from 8.16 to 8.17, search the key word 'dbms_standard.sql' in google, nothing returned.
Anyone has any idea about that?
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
| Re: catproc.sql has no such statement to recreate/creat package DBMS_STANDARD [message #202930 is a reply to message #69141] |
Mon, 13 November 2006 06:11  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
hi
CATPROC.SQL
Runs all scripts required for or used with PL/SQL: CATPRC.SQL, CATRSNAP.SQL, CATRPC.SQL, STANDARD.SQL, DBMSSTDX.SQL, PIPDL.SQL, PIDIAN.SQL, DIUTIL.SQL, PISTUB.SQL, DBMSSNAP.SQL, DBMSLOCK.SQL, DBMSPIPE.SQL, DBMSALRT.SQL, SBMSOTPT.SQL, DBMSDESC.SQL
STANDARD.SQL >> PATH >> ORACLE-HOME/RDBMS/ADMIN/
STANDARD.SQL
http://www.google.ae/search?hl=en&q=Oracle+8+%2B+STANDARD.SQL&meta=
what more you want plz. provide more details.
HOPE THIS HELPS
MOHAMMAD TAJ.
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
