467,169 Members | 956 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

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
  • viewed: 10664
Share:
4 Replies
Saii
Expert 100+
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
Expert 4TB
If Import terminated successfully without warnings.

what is the problem then ???

Please specify the problem u r facing if any.
Apr 28 '07 #3
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

Post your reply

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

Similar topics

reply views Thread by John Roth | last post: by
5 posts views Thread by Steve Holden | last post: by
2 posts views Thread by Panard | last post: by
1 post views Thread by Nick Craig-Wood | last post: by
reply views Thread by Victor Lin | last post: by
5 posts views Thread by Stef Mientki | last post: by
10 posts views Thread by nisp | last post: by
13 posts views Thread by Rafe | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.