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

ORA-00473: ARCH process terminated with error

1 Answers  


AMD-00139: level names parameter not valid

1 Answers  


O2F-00316: An unexpected token was seen at the end of a type specification

1 Answers  


ORA-16553: the Data Guard broker process (DMON) failed to shutdown

1 Answers  


LSX-00020: unknown type "~S"

1 Answers  






ORA-06310: IPA: Environment variable(s) not set

1 Answers  


ORA-25107: duplicate TABLESPACE option specification

1 Answers  


TNS-12158: TNS:could not initialize parameter subsystem

1 Answers  


TNS-12685: Native service required remotely but disabled locally

1 Answers  


ORA-31428: no publication contains all the specified columns

1 Answers  


ORA-01663: the contents of tablespace 'string' is constantly changing

1 Answers  


PCC-02335: body of cursor must name statement identifier

1 Answers  


Categories