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-08055: media recovery complete

1 Answers  


ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  


ORA-27149: assignment out of range

1 Answers  


SQL-02153: Invalid character variable for use in a GET/SET statement

1 Answers  


ORA-10589: Test recovery had to corrupt string data blocks in order to proceed

1 Answers  






ORA-01769: duplicate CLUSTER option specifications

1 Answers  


ORA-08191: Flashback Table operation is not supported on remote tables

1 Answers  


RMAN-06187: controlfile copy string not found or out of sync with catalog

1 Answers  


ORA-13456: GeoRaster cell data error

1 Answers  


ORA-19557: device error, device type: string, device name: string

1 Answers  


ORA-06303: IPA: Message send error

1 Answers  


ORA-28175: incorrect certificate type

1 Answers  


Categories