View Oracle exp file

[Diego B.]

Hi,

Do you know if there is any possibility to view an Oracle database
schema exported in a file with the "exp" command without importing it
back to a database?

Thank you in advance for every possible suggestion!
Diego.

[Ben Graham]

Open the dump file in a text editor. You'll see the DDL in plain text.

Best not to use notepad if the dmp file is big.

[Guest]

Actually,

SHOW=Y is a better bet.

Roger Gorden
Sr. DBA Unicast Corporation

[Mark D Powell]

Roger and Diego, I think you may find the indexfile parameter a better
bet as it formats the DDL into an almost usable format. You just need
to remove the comments.

IMHO -- Mark D Powell --

[Guest]

Thanks. That's even better then my answer.

Roger Gorden
Sr. DBA Unicast Corporation