Reg the dump file fails to import [message #352478] |
Wed, 08 October 2008 00:12 |
ram anand
Messages: 244 Registered: February 2008 Location: india
|
Senior Member |
|
|
Hi,
There is a dump from production DB ,when i tried to import the export file it shows the below error
[oracle@stock ~]$ imp system/simple@stock file=pros4.dmp fromuser=ngrm touser=batest buffer=100000000 commit=y
Import: Release 10.2.0.3.0 - Production on Wed Oct 8 10:41:04 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via direct path
Warning: the objects were exported by NCLDBA, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export client uses WE8ISO8859P1 character set (possible charset conversion)
IMP-00046: using FILESIZE value from export file of 2097152000
IMP-00047: unexpected file sequence number; expected 1 but found 4
IMP-00132: first file in the multi-file export is pros1.dmp0.02.01
IMP-00000: Import terminated unsuccessfully
Can anyone pls guide over this
Thanks in advance
|
|
|
|
|
|