Re: view create table statements

From: Sean M <smckeownNO_at_BACKSIESearthlink.net>
Date: Fri, 15 Mar 2002 18:39:47 GMT
Message-ID: <3C92401C.49444A37@BACKSIESearthlink.net>

Sean M wrote:
>
> damorgan wrote:
> >
> > No.
>
> Yes, in 9i at least. See DBMS_METADATA. It's described in the Oracle9i
> Database README Release Notes, as well as the Oracle9i Supplied PL/SQL
> Packages Reference (Chapter 26, "DBMS_METADATA").

Oh, and if you're not running 9i but do have a Metalink account, you can try the script in Note:1022272.6 "SCRIPT TO GENERATE DDL FOR ALL THE TABLES IN THE DATABASE". Regards,
Sean Received on Fri Mar 15 2002 - 12:39:47 CST