Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitioned view problem (typing mistake)
Wilhelm Thieme wrote in message <66mr6r$s5u$1_at_news.worldonline.nl>...
>Hi everyone
>
>I'm struggeling with a partitioned view which will NOT give
>me the performance as expected.
>
>The view is created as follows:
>create or replace view temp as
>select * from table_19971118 where date_col=to_date('19971118','yyyymmdd')
>union all
>select * from table_19971119 where date_col=to_date('19971118','yyyymmdd')
>union all
>select * from table_19971120 where date_col=to_date('19971118','yyyymmdd')
>union all
>select * from table_19971121 where date_col=to_date('19971118','yyyymmdd')
>/
Typing error: text should be
create or replace view temp as
select * from table_19971118 where date_col=to_date('19971118','yyyymmdd')
union all
select * from table_19971119 where date_col=to_date('19971119','yyyymmdd')
union all
select * from table_19971120 where date_col=to_date('19971120','yyyymmdd')
union all
select * from table_19971121 where date_col=to_date('19971121','yyyymmdd')
/
>
>Any ideas welcome!
>
>Thanks
>
>Wilhelm Thieme
>
>
Received on Wed Dec 10 1997 - 00:00:00 CST