Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i generate SQL script?

Re: How can i generate SQL script?

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Mon, 30 Apr 2001 03:20:05 GMT
Message-ID: <3AECDB10.4A4D859C@telusplanet.net>

Or just code it using SQL*Plus. I think Enterprise Manager also has some of that capability. If all you want is the DDL, export without data and then edit the export file.

Ian Ledzion wrote:

> Extract DDL functions in SQL Navigator www.quest.com
> I think TOAD (also Quest) also does it.
>
> "Ron" <ronyin_at_tpts5.seed.net.tw> wrote in message
> news:9c8bin$q31$1_at_news.seed.net.tw...
> > I got just over 500 tables on oracle8.0.5.
> > how can i generate SQL script for these tables.
> >
> > Ron
> >
> >
> >
  Received on Sun Apr 29 2001 - 22:20:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US