Oracle import utility does not import anything

[neoonwheels]

Hi,

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

[magicwand]

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.

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

[debasisdas]

May i know why you imported to system schema and to other normal user schema ?