Re: Is it possible to dump oracle database to DDL/SQL syntax

it is possible and it is not possible

1 of course you can save (and IMO should save) all you create statements to files.
2 if it comes to duplicating or reinstalling a schema simply use exp and imp with appropiate options
3 you can simply exp without data (use the option rows=n) and imp with show=y and log=filename to create a ascii dump of all *create* commands (no, it won't create drop commands)
4 if you use a case tool like designer designer can do it. 5 you can use a tool like TOAD (freeware version at www.toadsoft.com ) to dump your statements

Oracle is not MySql, it is much more than that (AFAIK MySQL doesn't even have record locking).

Hth,

Sybrand Bakker, Oracle DBA
.

<fenton_travers_at_my-deja.com> wrote in message news:8o4vkc$hos$1_at_nnrp1.deja.com...
> I have an oracle database and I want to dump it to a ddl file. Ie a
> file that I could later use like:
>
> $ sqlplus < myData.ddl
>
> so it would have the table drop syntax, table create syntax and the
> insert into syntax.
>
> I can do this simply with MySQL but my Oracle DBA says I can't do this
> in oracle and I don't believe him.
>
> Fenton
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 25 2000 - 00:49:48 CDT