Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: batch generating of DDL for a set of tables
marko mikulicic wrote:
>
> Hello,
>
> I use Oracle 9i for linux. With oemapp dbastudio I can
> generate DDL for a table and then save the sql in a file,
> but only one table at time. I cannot select multiple tables.
>
> Is it possible to generate sql file/s with DDL of a set of tables
> at once.
>
> I'd prefer to use a script for that.
>
Take the magic "oracletool" as a starting point for generating DDL scripts. Oracletool is available from www.oracletool.com.
U.
-- Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe F&E / Database & Software Technologies - Tel. (+49) 721 94329 8320Received on Mon Aug 20 2001 - 09:48:59 CDT