ORA-02030: can only select from fixed tables/views



ORA-02030: can only select from fixed tables/views..

Answer / guest

Cause: An attempt is being made to perform an operation
other than a retrieval from a fixed table/view.

Action: You may only select rows from fixed tables/views.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-09909: Malloc of scratch buffer failed.

1 Answers  


ORA-13912: Critical threshold value is less than warning threshold value.

1 Answers  


ORA-01417: a table may be outer joined to at most one other table

1 Answers  


ORA-13048: recursive SQL fetch error

1 Answers  


ORA-12679: Native services disabled by other process but required

1 Answers  






PLS-00414: no column 'string' in table

1 Answers  


ORA-27369: job of type EXECUTABLE failed with exit code: string

1 Answers  


ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  


QSM-02033: no filter conditions are present in the WHERE clause

1 Answers  


ORA-14079: illegal option for a partition marked Index Unusable

1 Answers  


TNS-04202: Trace Assistant Usage ERROR: Not enough arguments

1 Answers  


ORA-00202: controlfile: 'string'

1 Answers  


Categories