Import Problem.

cpiyush

Hi..

We are using Oracle 9i.
We have been given a dump file (mighty.dmp). We have created a new DB on our system & trying to import the given DB's data to the local Db.

We are giving the following command: -
C:\oracle\ora92\bin>imp mighty1/mighty1 file=mighty.dmp FROMUSER=MIGHTY_TEST TOUSER=mighty1

Import: Release 9.2.0.1.0 - Production on Fri Apr 20 16:08:11 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

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

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

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.

Help us, what to do???

Apr 20 '07 #1

Saii

It shows import done successfully.
If you are concerned about the character set thing, check if your exported data was using a different national language support (NLS) other than you local db. If so, then before importing you will have to set NLS_LANG to that particular character set.

Hope that helps!!

Apr 20 '07 #2

debasisdas

If Import terminated successfully without warnings.

what is the problem then ???

Please specify the problem u r facing if any.

Apr 28 '07 #3

sudiptomukherjee

hi piyush

you r facing the problem with import try out to import the dmp file with this command.

imp userid=mighty1/mighty1 file= mighty.dmp owner=MIGHTY_TEST full=y

try this out..the problem will be resolved hope this will work fine...

Hi..

We are using Oracle 9i.
We have been given a dump file (mighty.dmp). We have created a new DB on our system & trying to import the given DB's data to the local Db.

We are giving the following command: -
C:\oracle\ora92\bin>imp mighty1/mighty1 file=mighty.dmp FROMUSER=MIGHTY_TEST TOUSER=mighty1

Import: Release 9.2.0.1.0 - Production on Fri Apr 20 16:08:11 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to: Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

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

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

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Import terminated successfully without warnings.

Help us, what to do???

Apr 30 '07 #4

cpiyush

Well... I got the solution. I had 2 users in that source DB MIGHTY_USER, MIGHTY!. But there were no tables in MIGHTY_USER. I created only one user in my traget DB i.e. MIGHTY_USER & not the MIGHTY!, so it was not showing me import of any table as it was not importing MIGHTY1's data.

But I did not understand one thing, that If we are importing a FULLy exported DB then why we have to create all the users again manually in the target DB, I know we should not, it is done automatically by Oracle, But I had to done this.

Thanks for your respoenses & suggestions..

May 3 '07 #5