Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I imported two dump files (no idea what they contained, my goal is precisely to find out what they contain) into Oracle, but now I am struggling to identify what is the data I imported, and what data was originally there. On a fresh install of Oracle 11g.

The number of schemas does not seem to have changed, 37. I have browsed around and most of what I see seems to be Oracle's own data (note: I am an Oracle beginner).

To import, I use the first command for the first file, then the second because I was told by imp that DBA was needed for that file:

imp nico/nico file=C:\data\FILE1.DMP
imp system/thepassword file=C:\data\FILE2.DMP full=yes

Does the command line output of imp show the identifiers of all imported data? Is there a sort of history logs where I can see which tables/rows have been imported recently?

I have spotted one imported table in SYSTEM, but would like to have an exhaustive list.

share|improve this question
add comment

3 Answers

up vote 4 down vote accepted

Using import with show=y won't actually do the import, but will show which tables the import will run against. There's no practical way, however, to show what rows import will write; it's assumed that you, running the import, would know that.

You may wish to look at some of Oracle's extensive documentation about these utilities to determine what options are available and what they do.

share|improve this answer
add comment

have you tried impd.

http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm

http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

share|improve this answer
2  
Data Pump will only read files that were created with Data Pump. If the files he has were created with the old Exp utility, then he needs to use Imp to import them. –  BryceAtNetwork23 Mar 6 '12 at 11:43
add comment

Your best bet to know what data you imprted would be a log miner session, which depending on the database use, it can be a daunting task

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.