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
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