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 can't findam struggling to identify what is the data Enterprise Manager 11g.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
IsDoes 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?
Or maybe sorting tables by size, since the data I imported seems rather voluminous judging by the dump size.
When I import ashave spotted one imported table in systemSYSTEM
, I can notice that the 'SYSTEM01.DBF` file grows a bitbut would like to have an exhaustive list.