Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Make legible DDL from exported *.dmp file?

Re: Make legible DDL from exported *.dmp file?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Sep 1998 22:43:32 +0200
Message-ID: <360AAEF4.F9402CFF@sybrandb.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US