Question: So I have looked at all the suggested ways of importing .dmp files and non of them seem to answer this question: where does the data go once you import it?

Context: I created a user like so:

```
SQL> create user IMPORTER identified by "12345";
SQL> grant connect, unlimited tablespace, resource to IMPORTER;

```

I then ran the 'imp' command as follows:

```
C:\>imp system/password FROMUSER=OVIEDOE TOUSER=IMPORTER file=c:\database1.dmp

```

Now there were 9 .dmp files, after each one it asked me for the next one and then I received the message "Import terminated successfully with warnings."

The warning was:

```
Warning: the objects were exported by OVIEDOE, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00046: using FILESIZE value from export file of 2147483648

```

Now it says it was terminated successfully so my assumption (I am new to oracle so this may be wrong) is that the data was loaded. However, when I use SQL developer to connect to the database and look under the 'tables' node under the IMPORTER user, there is nothing there. What is going on? Did the data load? If so, where can I find it?

Answer: 
Are you sure that the file actually contains object owned by OVIEDOE ? Normally I'd expect a list of the objects being imported as it processes them. 

This result is what I'd expect if I'd done an export for USER1 and then tried to import with FROMUSER=USER\_1 (and yes, I've done plenty of typos in my time).

Try IMP SHOW=Y to show the contents of the dump file.
In SQL Developer, are you logged in as IMPORTER? The user you're logged in as must have privileges on the IMPORTER schema to see its objects.

Also, make sure that the SYSTEM user has IMP\_FULL\_DATABASE privileges.