| Analyze Database [message #174388] |
Mon, 29 May 2006 01:22  |
rafi_aamiri
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi,
I tried to analyze the database using the dbms_utility through SYS and SYSTEM login.
Before doing the analyze on the database I issued the grant permission as
SQL> grant analyze any to system;
In both the login I use to get the same error as,
ERROR at line 1:
ORA-20000: You have insufficient privileges for an object in this database.
ORA-06512: at "SYS.DBMS_UTILITY", line 500
ORA-06512: at line 1
Could you please help me in this regard .......
Thanks and Regards,
A.Mohammed Rafi.
|
|
|
|
| Re: Analyze Database [message #174411 is a reply to message #174388] |
Mon, 29 May 2006 03:54  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
In order to user dbms_utility.analyze_database you must be sysdba.
In your case, for gathering stats, instead of using system, use sys as the user.
--Girish
|
|
|
|
| Re: Analyze Database [message #174434 is a reply to message #174411] |
Mon, 29 May 2006 04:20 |
rafi_aamiri
Messages: 34
Registered: September 2005
|
Member |
|
|
In the problem it is clearly stated that I logged with SYS as sysdba user. But still the problem arises...
Pls let me know whether I need to grant any privileges to avoid this error....
|
|
|
|
| Re: Analyze Database [message #174452 is a reply to message #174434] |
Mon, 29 May 2006 04:45 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Enable 10046 level 12 trace in your session
& then issue your dbms_utility.analyze_database statement.
Check the trace so generated fr the object/objects which are causing this error.
-Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
