Skip to main content
Tweeted twitter.com/#!/StackDBAs/status/176998138077384704
added 85 characters in body
Source Link
Nicolas Raoul
  • 319
  • 1
  • 5
  • 16

Imported dump data, can't How to find it inout which data I just imported into Oracle?

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.

Imported dump data, can't find it in Oracle

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 find the data Enterprise Manager 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

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 as system, I can notice that the 'SYSTEM01.DBF` file grows a bit.

How to find out which data I just imported into Oracle?

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.

added 85 characters in body
Source Link
Nicolas Raoul
  • 319
  • 1
  • 5
  • 16

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 find the data Enterprise Manager 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

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 as system, I can notice that the 'SYSTEM01.DBF` file grows a bit.

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 find the data Enterprise Manager 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

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.

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 find the data Enterprise Manager 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

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 as system, I can notice that the 'SYSTEM01.DBF` file grows a bit.

Source Link
Nicolas Raoul
  • 319
  • 1
  • 5
  • 16

Imported dump data, can't find it in Oracle

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 find the data Enterprise Manager 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

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.