Oracle Database Discussions

Hi all,

We are tried to change the database server from 9.2.0.4 Enterprise to 10g Express Edition.

I export the data file using exp with full=y and then I tried to import the dmp file with imp full=y
The result is that a lot of error is popup

So I tried to use impdp to do the import. And the result shows
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39143: dump file XXXXXXX may be an original export dump file

I need guidelines to import our dmp file. Can anyone give us some direction for that?
Thank you for your help

[EDITED]
I have found that for dmp file that is exported by old "exp" command cannot be imported to 10g database by using "impdp" command. The reason that "imp" fails in our case is that I have not created tablespace and users (I expect oracle will help us to do that)
After I create tablespace and users, it can import the data without errors (but there are some warnings, need to check)

I do not understand why I have to add the users. There may be thousands of users and I have not their password. But if I do not add the users, the imp will show that there does not exist the user

Edited by: user7946502 on 2009/6/23 下午 6:59