471,337 Members | 1,193 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

Oracle import utility does not import anything


I have a Oracle 9 dump file with me with user "plus10". I would like to import everything present in this file into my database. I do not have any idea about the tablespace this was exported from. I used following command:

imp system/<pass> file=plus10.dmp fromuser=plus10 touser=system ignore=y

The output says:
Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by PLUS10, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion). importing PLUS10's objects into SYSTEM
Import terminated successfully without warnings.

I have "plus10" user created in my database. When I search for the tables in my system account, it does not show the tables imported. Also when I use the following command:

imp system/<pass> file=plus10.dmp full=y ignore=y

It says, imp failed due to duplicate object "table-name" in the database.

What is the problem with Oracle then? I am new to Oracle so I am not able to solve this. I just love MS SQL. Oracle sucks big time.
May 20 '10 #1
2 3186
Expand|Select|Wrap|Line Numbers
  1. Export file created by EXPORT:V09.02.00 via conventional path
  3. Warning: the objects were exported by PLUS10, not by you
  5. import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses US7ASCII character set (possible charset conversion). importing PLUS10's objects into SYSTEM
  6. Import terminated successfully without warnings.
If that's the entire output you got, your .dmp file is not holding any objects. What were the export statement and log ?

Btw: welcome to the world of real databases ...
May 20 '10 #2
8,127 Expert 4TB
May i know why you imported to system schema and to other normal user schema ?
May 24 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by davvid | last post: by
4 posts views Thread by db2group88 | last post: by
7 posts views Thread by Ivan | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.