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

RMAN-08532: channel string: restoring block(s) from datafilecopy string

1 Answers  


ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


NNL-00246: General request processing is currently disabled

1 Answers  


ORA-30042: Cannot offline the undo tablespace

1 Answers  


ORA-14020: this physical attribute may not be specified for a table partition

1 Answers  






ORA-02083: database name has illegal character 'string'

1 Answers  


NID-00124: Mismatched dbid for datafile string, expected number, found number

1 Answers  


ORA-30029: no active undo tablespace assigned to instance

1 Answers  


ORA-00208: number of controlfile names exceeds limit of string

1 Answers  


LSX-00173: ~S of ~S type is not a valid restriction of ~S of ~S type

1 Answers  


ORA-06919: CMX: error during write request (unknown event)

1 Answers  


ORA-32162: Read/Write SQL method not registered

1 Answers  


Categories