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

Home -> Community -> Usenet -> c.d.o.misc -> Re: exp file format?

Re: exp file format?

From: Dan Norris <dann_at_sky.net>
Date: 15 May 1998 16:51:53 -0500
Message-ID: <6jiddp$abk$1@sky.net>


I believe that the import utility will do this for you. Try using imp <connect string> SHOW=y and redirect that to a file. I believe that it will print all the SQL in the export to STDOUT for you.

Dan

Bjorn Borud <borud_at_guardian.no> writes:

>I am looking for some documentation on the file format used by the
>Oracle export utility (Oracle 7.3.2) since I figured it would be more
>convenient to read this file in order to reverse-engineer a database.

>is the format published anywhere?

>PS: has someone written some code that dumps all schema objects to an
> SQL file so you can use it to regenerate the database somewhere
> else?
Received on Fri May 15 1998 - 16:51:53 CDT

Original text of this message

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