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

IMG-00717: destination image format does not support process options

1 Answers  


ORA-23321: Pipename may not be null

1 Answers  


RMAN-04025: unable to generate a temporary file

1 Answers  


ORA-00155: cannot perform work outside of global transaction

1 Answers  


RMAN-00600: internal error, arguments [string] [string] [string] [string] [string]

1 Answers  






SQL*Loader-00473: nesting of collections is not allowed.

1 Answers  


ORA-25221: enqueue failed, signature specified queue not supporting non-repudiation

1 Answers  


RMAN-06431: recovery catalog created

1 Answers  


ORA-02258: duplicate or conflicting NULL and/or NOT NULL specifications

1 Answers  


PCB-00312: Keyword WORK required here by ANSI

1 Answers  


PLS-00565: %s must be completed as a potential REF target (object type)

1 Answers  


AMD-00131: dimension #string: RDBMS parent column data type not specified

1 Answers  


Categories