Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extracting DLL
Hi Doug,
the tool Hora 3 offers a menu item "Tools / Reverse Database Engineer ..". You can create an option set (for example: all ddl for table creation, some trigger ddl, one special sequence number ...). Hora generates the ddl File. See http:\\www.keeptool.com for a free trial version of Hora 3.
regards Jan Dieckmann
Doug Cowles wrote:
> Can anyone point me to a script that will extract the ddl from
> an Oracle database? This would include table definitions,
> constraints, and well as storage parameters. I can easily
> get the table definitions from an indexfile, and I can get
> the constraints from a separate script, but it would be nice to
> get the whole deal in one output.
>
> - Dc.
Received on Tue Mar 16 1999 - 10:23:17 CST