Problem importing Oracle .dmp file

Posted by BitFiddler on Stack Overflow See other posts from Stack Overflow or by BitFiddler
Published on 2010-04-19T16:38:46Z Indexed on 2011/11/13 17:51 UTC
Read the original article Hit count: 237

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about import