Import oracle dmp file [message #50193] |
Tue, 05 March 2002 11:23 |
Divya
Messages: 12 Registered: March 2002
|
Junior Member |
|
|
Hi ,
I am using Oracle 8.1.7.
when i try to import a dmp file ,I am getting the following msg, originally it was exported by sys user.
Export file created EXPORT:V08.00.05 via conventinal path.
Warning: the objects were exported by SYS, not by you.
import done in WE8IS08859P1 charecter set and WE8IS08859P NCHAR character set.
export client uses US7ASCII character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)
import terminated successfully without warnings.
Could please help me for this ASAP.
Thanks
divya.
|
|
|
Re: Import oracle dmp file [message #50195 is a reply to message #50193] |
Tue, 05 March 2002 11:35 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
Do you have the system password? If so
imp fromuser=? touser=? file=x.dmp
you will then get prompted for the username to import as, this is where you use system<systempwd>
|
|
|