ORA-02345: cannot create a view with column based on CURSOR
operator



ORA-02345: cannot create a view with column based on CURSOR operator..

Answer / guest

Cause: A CURSOR operator was used as one of the SELECT
elements in the subquery of a CREATE VIEW or CREATE TABLE
... AS SELECT statement.

Action: Remove the CURSOR operator and replace it with the
CAST operator.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-04055: Aborted: "string" formed a non-REF mutually-dependent cycle with "string".

1 Answers  


PLS-00139: duplicate external NAME specification in subprogram expression

1 Answers  


QSM-01093: anti-join marker not found in materialized join view

1 Answers  


ORA-29838: insufficient privileges to execute the operator(s)

1 Answers  


ORA-02452: invalid HASHKEYS option value

1 Answers  






RMAN-20029: cannot make a snapshot controlfile

1 Answers  


ORA-29808: specified primary operator binding does not exist

1 Answers  


QSM-00800: the specified workload name string is invalid

1 Answers  


ORA-33267: (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it

1 Answers  


DRG-10833: feedback failed

1 Answers  


ORA-03230: segment only contains string blocks of unused space above high water mark

1 Answers  


NNL-00961: Cache checkpoints: number

1 Answers  


Categories