Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-30741: WITH HIERARCHY OPTION can be specified only for
SELECT privilege



ORA-30741: WITH HIERARCHY OPTION can be specified only for SELECT privilege..

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-01114: LSNRCTL could not perform local OS authentication with the listener

1 Answers  


ORA-23428: job associated instance number string is not valid

1 Answers  


LSX-00113: facet "~1S" has invalid value "~2S"

1 Answers  


ORA-06608: LU6.2 Driver: Reset occurred in receive state

1 Answers  


ORA-02245: invalid ROLLBACK SEGMENT name

1 Answers  






RMAN-06736: Do you really want to unregister the database (enter YES or NO)?

1 Answers  


ORA-23489: duplicate entry "string"

1 Answers  


NNL-00850: Rename requests received: number

1 Answers  


IMP-00006: failed to allocate memory of size number

1 Answers  


ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


ORA-24410: scrollable cursor max size exceeded

1 Answers  


RMAN-08516: controlfile copy filename=string recid=string stamp=string

1 Answers  






Categories