Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Make legible DDL from exported *.dmp file?
Two alternatives
imp file=<filename> full=y show=y logfile=<log filename> user=...
etc
This will show the export and dump the output to the log file
Other option:
imp file= full=y indexfile=<filename> user etc
This will only dump the create index statements and the create table
statements (REMed out).
Hth,
Sybrand Bakker, Oracle DBA
Steven Hauser wrote:
> How do you get readable DDL from an exported *.dmp file?
>
> Is oracle just lots of fun, or what?
> --
>
> ---------------------------------------------------------
> Steven Hauser, hause011_at_tc.umn.edu
> Phone: (612)626-7135
> Fax: (612)625-6853
> ---------------------------------------------------------
Received on Thu Sep 24 1998 - 15:43:32 CDT