Export Question

[skdas]

I have one database full export dump file.

Question
=======

1. Can I know what are the schemas inside that export file...?

2. Can I know if one particular object is present inside the file..?

3. Can I know if the unix file itself is corrupted or not without starting the import..?

[John Spencer]

You can use basic unix commands.

1. strings exp.dmp |grep -i 'CREATE USER'
2. strings exp.dmp |grep -i ''
3. Probably not, since the dump file is in an Oracle proprietary format.

TTFN
John

[Mr.Hanky]

Log=/you/should/use/a/parfile/and/spool/an/export/log

[hacketta1]

IMHO you can answer all three questions (platform independantly) with show=y full=y and log=whatever

[anandkl]

Hi,
You also import into only the create statements into a file using the indexfile parameter of import. From this file u will know all the users going to be created and all the database objects. This might also help to know if the export dump is fine or not, but i am not sure of this.


regards
anandkl

[John Spencer]

The original poster did say "without starting the import" in question 3, I took that to apply to all three questions.

Of course, Mr. Hanky's response is certainly the best for questions 1 and 2, although I;m surprised he didn't phrase it as RTFL (Read the Fine Log) :-)

John

[hacketta1]

Fair point. I interpreted "without starting the import" as meaning without the import doing anything to my db, not without using the imp binary.