Re: backwards inferring scripts?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 04 Dec 2004 01:51:02 GMT
Message-ID: <Xns95B4B59685C6FSunnySD@68.6.19.6>

laredotornado_at_zipmail.com (D. Alvarado) wrote in news:9fe1f2ad.0412031203.5b6a12db_at_posting.google.com:

> Hello,
> We are running Oracle 8.1.7 for Solaris and have an old set of
> tables in our db. Unfortunately, we don't have the original SQL
> scripts that created these tables. Is there some way in Oracle that
> you can export a script with all the "CREATE TABLE" statements already
> built? The tables we wish to do this for are
>
> COMPONENTS
> PROGRAMS
>
> Much thanks, - Dave

Alternatively, export with ROWS=N & then import into a 9i DB and use DBMS_METADATA to obtain the raw SQL. Received on Fri Dec 03 2004 - 19:51:02 CST