By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Error message comming during import the file in oracle.

P: 34
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
Feb 12 '09 #1
Share this Question
Share on Google+
3 Replies


amitpatel66
Expert 100+
P: 2,367
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
Feb 12 '09 #2

P: 34
Dear Amit,
Thanks a lot!!!!!!

Best Regards
Sumanta Panda
Feb 12 '09 #3

amitpatel66
Expert 100+
P: 2,367
You are welcome Sumanta :)
Do post back in case of any further issues

Moderator
Feb 13 '09 #4

Post your reply

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