Re: Is there any data dictionary to check out the creation statements

From: zhu chao <chao_ping_at_vip.163.com>
Date: Fri, 25 Jul 2003 15:21:46 +0800
Message-Id: <26007.339519@fatcity.com>

SQL> select query from user_mviews where mview_name='MV_END_ART';

QUERY

---

---

SELECT * FROM ARTICLESCATALOG
WHERE END_DATE_DTM > SYSDATE
AND END_DATE_DTM <SYS

Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org
----- Original Message -----
From: <chuan.zhang_at_customs.gov.au>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, July 25, 2003 2:24 PM
Subject: Is there any data dictionary to check out the creation statements

> Hi, All,
>
> Is there any data dictionary in Oracle to check out creation statements
of
> materialized view? Something like the user_source view about object
> creation. I have checked user_mviews, user_mview_joins, etc, but I haven't
> got one.
>
> TIA
>
> Chuan
> Important: This transmission is intended only for the use of the addressee
> and may contain confidential or legally privileged information. If you
are
> not the intended recipient, you are notified that any use or dissemination
> of this communication is strictly prohibited. If you receive this
> transmission in error please notify the author immediately by telephone
and
> delete all copies of this transmission together with any attachments.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: chuan.zhang_at_customs.gov.au
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 25 2003 - 02:21:46 CDT