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

From: Mark <cdo_at_lambic.co.uk>
Date: Thu, 31 Aug 2000 17:31:59 GMT
Message-ID: <39AE967F.CA84BBEB@lambic.co.uk>

fenton_travers_at_my-deja.com wrote:
>
> 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

You can try the INDEXFILE option of imp (export with no data first), but I think this only handles tables and indexes.

Alternatively, there are scripts around that do this kind of thing by constructing DDL from data dictionary views. I wrote one myself once, but forget to take it with me when I finished the contract! Received on Thu Aug 31 2000 - 12:31:59 CDT