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: Jeffrey Pell <Jeffrey_Pell_at_acm.org>
Date: Thu, 24 Sep 1998 17:28:31 -0400
Message-ID: <360AB97E.1CE77511@acm.org>


There are two ways I know of:

  1. Use the INDEXFILE parameter of import. This will create a file of CREATE TABLE and CREATE INDEX statements. The CREATE TABLE statements will be commented out in the file, but that is easy enough to fix.
  2. If you want more than CREATE TABLE and CREATE INDEX statements, use the SHOW parameter of import. However, the usability of this is quesitonable without a great deal of editing.

Hope that helps.

Jeff

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 - 16:28:31 CDT

Original text of this message

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