QSM-02049: subquery using the ANY clause in mv

Question Posted / guest

1 Answers
2971 Views
I also Faced
E-Mail Answers

QSM-02049: subquery using the ANY clause in mv..

Answer / guest

Cause: The capability in question is not supported when the
materialized view uses the ANY clause with a subquery.

Action: Re-phrase the query to avoid the use of the ANY clause.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38955: Source platform string not cross platform compliant

1 Answers

ORA-13125: partition key is already set

1 Answers

ORA-06720: TLI Driver: SID lookup failure

1 Answers

I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 Answers

ORA-26027: unique index string.string partition string initially in unusable state

0 Answers MeritTrack,

ORA-16412: ONDEMAND archival requires active SQL apply operation

1 Answers

PLS-00487: Invalid reference to variable 'string'

1 Answers

PCC-02447: Cannot specify destination offset in a LOB WRITE APPEND

1 Answers

ORA-13337: failure in concatenating LRS polygons

1 Answers

ORA-01719: outer join operator (+) not allowed in operand of OR or IN