Re: MVIEW reverse engineer...

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 22 Mar 2007 00:07:08 +0100
Message-ID: <4601BA9C.40300@gmail.com>

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 Received on Wed Mar 21 2007 - 18:07:08 CDT