Home » RDBMS Server » Server Utilities » Reg the dump file fails to import (Oracle 10g)
Reg the dump file fails to import [message #352478] Wed, 08 October 2008 00:12 Go to next message
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
Re: Reg the dump file fails to import [message #352497 is a reply to message #352478] Wed, 08 October 2008 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must include the first 3 files from export before this fourth one.

Regards
Michel
Re: Reg the dump file fails to import [message #352501 is a reply to message #352497] Wed, 08 October 2008 01:33 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
can u provide me the import command used for this type of export

thanks,
Re: Reg the dump file fails to import [message #352505 is a reply to message #352501] Wed, 08 October 2008 01:44 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just give in "file" parameter the list of the files generated by export.

Regards
Michel
Previous Topic: Data Pump REMAP_SCHEMA priveleges issue
Next Topic: EXPort (without Mat view logs)
Goto Forum:
  


Current Time: Thu Dec 08 00:28:11 CST 2016

Total time taken to generate the page: 0.09879 seconds