Error message comming during import the file in oracle.

[sumanta123]

Hi All,
I am using this command exp dev/dev@uatdb file='C:\database\dbbackup.dmp' for export the data from my database.It is successfully export into the dbbackup.dmp file.


While import the same file i am using this command imp dev/dev@uatdb file='C:\database\dbbackup.dmp' but the error message displaying "
Import: Release 9.2.0.1.0 - Production on Thu Feb 12 12:24:40 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00085: multiple input files specified for unbounded export file
IMP-00000: Import terminated unsuccessfully"

Kindly advise me for the needful.

Thanks in advance.

Regards
Sumanta Panda

[amitpatel66]

Check here

Go to command line
cd to directory where dump exists
type

imp system/{password} file={file name} full=y show=y

This will attempt to log on to the database as system with the {password} you provide, will attempt to read the file specified by {file name}, will scan the entire file, and will only display the information instead of trying to load it.

If that appears OK, then drop the show=Y

[sumanta123]

Dear Amit,
Thanks a lot!!!!!!

Best Regards
Sumanta Panda

[amitpatel66]

You are welcome Sumanta :)
Do post back in case of any further issues

Moderator