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.