materialized view - subquery not allowed

[sunarta]

Hi all,

I've been digging this problem almost 3 days now.

I created some 'normal' views and then join them all together to create a materialized view but I got this error message:

"Subquery expressions not allowed here"

I use subqueries *only* in 'normal' views.

how to solve this?
any comments, advice really appreciated.

many thanks
anthony

 

[sem]

Don't you really use subqueries in select clause of your statement? Something like select a, (select c from d) b...? If so, you may fill a new bug, though I suppose it's an old 2413838 one

Try this trick:

create view <view_name> as <your query>

create snapshot <another name> as select * from <view_name>

Regards, Dima

 

[ThomVF]

What refresh method are you trying to use? Please provide some sample code....


Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[sem]

Thomas, in fact refresh method doesn't matter, as this error is generated during parse time before scheduling/verifying refresh procedure.

Regards, Dima