Re: DDL export

"christopher keller" <ckeller_at_acm.org> wrote in message news:4p6qft41n02acthl4q7id14bjqp12gs5mb_at_4ax.com...
> Hello,
> In UDB I can with one command generate a readable text file of DDL
> (along with triggers, etc.) for a database, which I can then easily
> manipulate and store it in a non-Oracle repository (with DB2 mainframe
> we'd just read the catalog with SQL if we didn't have a tool).
>
> My DBA for Oracle claims that this is not possible, he's come up with
> nothing better than an export file. Working this over is just too
> costly. Surely, this problem is easily solved with Oracle means.
> Could someone point me in the right direction? Or is the right
> direction away from Oracle to another RDBMS?
>
> TIA, Christopher Keller

If you think the latter suggestion will help you, please do so. Nobody forces you to use Oracle.
There are two solutions (actually three, but the last one requires some discipline and/or a Case tool)

1 - run exp with rows=n and run imp with either show=y log=<filename> full=y and you will get all DDL statements in <filename>, or run imp with indexfile=<filename> and the will give the same result with tables REMed out
2 Use a tool like TOAD to dump the DDL to an ascii file 3 Don't develop on the fly but either save all your create statements to individual files before you run them or use a CASE tool like Designer to create your system.

Regards,

Sybrand Bakker, Oracle DBA Received on Sat May 12 2001 - 20:08:26 CEST