Re: DDL Commands

As the responses should have indicated to you, many tools exist to do that - some within Oracle ( exp like Sybrand indicated) or T.O.A.D and several other from various 3-rd party companies)

Good luck on breaking into that market...

"Kail" <mcdeer_at_box43.pl> wrote:

>Hello everyone,
>I am currently writing such a tool.
>i was really dissapointed that in oracle 8.1.7 doesn't exists a tool which
>allows to generate
>DDL for whole database.
>
>Adam
>
>Uzytkownik "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> napisal w
>wiadomosci news:8t9nou0mh49p0g4anq0c06la18irfvams2_at_4ax.com...
>| On Tue, 17 Sep 2002 08:55:21 +0200, "Stéphane DOUSSIERE"
>| <sdoussiere_at_eurocortex.fr> wrote:
>|
>| >Hello,
>| >
>| >First I'm french so my english isn't very good.
>| >
>| >Is it possible, with one Oracle 8i tool, to generate automatically a file
>of
>| >DDL commands of an existing database (CREATE TABLE, CREATE INDEX, CREATE
>| >VIEW.....................) ?
>| >
>| >Thank you for all response.
>|
>|
>| exp <username/password> file=<any file>.dmp rows=n compress=n
>| direct-=y
>|
>| Hth
>|
>|
>| Sybrand Bakker, Senior Oracle DBA
>|
>| To reply remove -verwijderdit from my e-mail address
>
Received on Fri Nov 15 2002 - 17:25:10 CET