Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MVIEW reverse engineer...
On Mar 21, 4:07 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> oracle_man schrieb:
>
> > Does anyone have a tool to reverse engineer materialized views at the
> > command line?
>
> > Thanks,
>
> > Rich
>
> Sounds a little bit like a hacker ;-)
>
> SQL> set long 10000000
> SQL> select
> dbms_metadata.get_ddl('MATERIALIZED_VIEW','CAL_MONTH_SALES_MV') from dual;
>
> DBMS_METADATA.GET_DDL('MATERIALIZED_VIEW','CAL_MONTH_SALES_MV')
> --------------------------------------------------------------------------------
>
> CREATE MATERIALIZED VIEW "SH"."CAL_MONTH_SALES_MV"
> ON PREBUILT TABLE WITHOUT REDUCED PRECISION
> USING INDEX
> REFRESH FORCE ON DEMAND
> USING DEFAULT LOCAL ROLLBACK SEGMENT
> ENABLE QUERY REWRITE
> AS SELECT t.calendar_month_desc
> , sum(s.amount_sold) AS dollars
> FROM sales s
> , times t
> WHERE s.time_id = t.time_id
> GROUP BY t.calendar_month_desc
>
> Best regards
>
> Maxim
Thanks Maxim. You rock. Received on Fri Mar 23 2007 - 14:44:25 CDT