QUOTE (SteveC @ Jul 20 2008, 07:56 PM)
Oracle Error :: IMP-00085
multiple input files specified for unbounded export file
You specified multiple file names for the FILE parameter when doing an import, but the header in the export file indicates that that the export operation could create only one file. Specifying multiple file names is valid for an import operation only if the export files were created by an export operation in which the user specified a non-zero value for the FILESIZE parameter.
If you believe the export contains multiple files, verify that you have specified the correct files. If you believe the export should be in only one file then try the import operation again, but specify only one value for the FILE parameter.
Hi StevC, thanks for your response.
Here is my import command.
IMP RAJA/MAHENDRA FILE=C:\BACKUPS\SCOTT.DMP FROM USER SCOTT TO USER RAJA IGNORE=Y
I mentioned only one name for FILE and I could see only one export file on my disc at above location (C:\BACKUPS\SCOTT.DMP) . For export command I have not mention any size, and I could see it accupied 22k on disk.(Its is a small database for practice on my Laptop).
I appreciate your response.