Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MVIEW reverse engineer...

Re: MVIEW reverse engineer...

From: oracle_man <oracle_man_at_yahoo.com>
Date: 23 Mar 2007 12:44:25 -0700
Message-ID: <1174679065.846568.16040@e65g2000hsc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US