| insufficient privilege to access object SYS.DBA_SEGMENTS [message #39590] |
Wed, 24 July 2002 21:11  |
Gautam
Messages: 24
Registered: February 2002
|
Junior Member |
|
|
Hi,
Ther are two invalid procedures which are not able to compile. Then I tried to compile them by giving the sql statement"
" alter PROCEDURE OM.REMOVEPARTITION compile ;"
It have prompted with a warning message:
"Warning: Procedure altered with compilation errors."
After this, I have given a statemetn "show errors" to know the problem......!
It has given this information..can anyone help me in solving this insufficient privileges problem...VERY URGENT..!
SQL> show errors
Errors for PROCEDURE OM.REMOVEPARTITION:
29/3 PL/SQL: SQL Statement ignored
30/8 PLS-00904: insufficient privilege to access object SYS.DBA_SEGMENTS
40/5 PL/SQL: Statement ignored
40/19 PLS-00364: loop index variable 'REC_SEG' use is invalid
45/5 PL/SQL: Statement ignored
45/8 PLS-00364: loop index variable 'REC_SEG' use is invalid
114/5 PL/SQL: SQL Statement ignored
115/10 PLS-00904: insufficient privilege to access object
SYS.DBA_CONSTRAINTS
130/5 PL/SQL: Statement ignored
130/31 PLS-00364: loop index variable 'REC_REF_FK' use is invalid
167/3 PL/SQL: SQL Statement ignored
168/8 PLS-00904: insufficient privilege to access object
SYS.DBA_INDEXES
174/3 PL/SQL: SQL Statement ignored
175/8 PLS-00904: insufficient privilege to access object
SYS.DBA_IND_COLUMNS
191/5 PL/SQL: Statement ignored
191/9 PLS-00364: loop index variable 'REC_IND' use is invalid
195/5 PL/SQL: Statement ignored
195/31 PLS-00364: loop index variable 'REC_IND' use is invalid
198/5 PL/SQL: Statement ignored
198/30 PLS-00364: loop index variable 'REC_IND' use is invalid
Thanks
Gautam
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
