Re: backwards inferring scripts?

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 03 Dec 2004 14:38:11 -0600
Message-ID: <v3j1r01qfefsgsm3iqdeqgrdhb6kelkjru@4ax.com>

On 3 Dec 2004 12:03:25 -0800, laredotornado_at_zipmail.com (D. Alvarado) wrote:

>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

Not directly with a query, if that is what you are looking for. However, DBA Studio can assemble it for you. Just open DBA Studio, connect to the db, expand the 'schema' folder, select the 'tables' folder, select the table in question, right-click, choose 'Show Object DDL...' Received on Fri Dec 03 2004 - 14:38:11 CST