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