ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege
Cause: The user tried to specify WITH HIERARCHY OPTION for a privilege other than SELECT privilege.
Action: Ensure that the HIERARCHY OPTION is specified only with the SELECT privilege
Custom Search

More Oracle errors
ORA-29384number of consumer groups and sub-plans for plan string exceeds string
RMAN-07210new failures after most recent LIST FAILURE command
ORA-13613The requested operation is not supported for this advisor object.
ORA-31147string is not an ACL resource
ORA-29370pending area is already active
ORA-27166tried to join current thread
ORA-25156old style outer join (+) cannot be used with ANSI joins
IMP-00091Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.
PGU-39400IT read %4li bytes from string
ORA-15013diskgroup "string" is already mounted
ORA-12850Could not allocate slaves on all specified instances: string needed, string allocated
NZE-28837no wallet descriptor
RMAN-05049datafile string is an Oracle Managed File, DB_CREATE_FILE_DEST not set at target
ORA-27435chain job terminated abnormally
DRG-11823Not Found
NID-00406Reversion of database name failed.
DRG-12433load of string JDBC driver class failed
ORA-23614Script string does not exist
ORA-07493scgrcl: lock manager error.
ORA-33060(XSAGDNGL29) In AGGMAP workspace object, the value for the ERRORLOG MAX option must be greater than 0.

TOP 20 Oracle errors
ORA-12504TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
RMAN-20079full resync from primary database is not done
ORA-14411The DDL cannot be run concurrently with other DDLs
ORA-14760ADD PARTITION is not permitted on Interval partitioned objects
ORA-10877error signaled in parallel recovery slave string
ORA-32701Hang detected
ORA-00838Specified value of MEMORY_TARGET is too small, needs to be at least stringM
ORA-16957SQL Analyze time limit interrupt
ORA-16664unable to receive the result from a database
ORA-16766Redo Apply is stopped
RMAN-08132WARNING: cannot update recovery area reclaimable file list
ORA-00000normal, successful completion
ORA-00837Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
RMAN-08137WARNING: archived log not deleted as it is still needed
ORA-16665timeout waiting for the result from a database
DIA-48122error with opening the ADR block file [string] [string]
ORA-47988password should contain at least one numeric and one alphabetic character
IMP-00057Warning: Dump file may not contain data of all partitions of this table
ORA-55508Invalid input to Flashback Transaction Backout
ORA-00001unique constraint (string.string) violated

Your own TOP 20 Oracle errors
ORA-30741WITH HIERARCHY OPTION can be specified only for SELECT privilege