OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import Failed (Oracle 9.0.2.0.6 Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import Failed [message #306400]

Fri, 14 March 2008 01:47

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Oracle Version: 9.2.0.1.0
Operating System: windows xp
Question (including full error messages and setup scripts where applicable):

Dear Tim,

i received an dump file (.dmp) from one of my clients and asked to import it into the database
but the client didn't tell me whether its a full export ,or user level export
So first i had created the a new db and then try to import it into the db as system user with the following command
and show=y to just get info instead of actual import

imp system/manager file=C:\imported\feb_15.DMP log=C:\imported\feb_15_log.log show=y

Warning: the objects were exported by ADNAN, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00047: unexpected file sequence number; expected 1 but found 129
IMP-00132: first file in the multi-file export is d:\feb_15.DMP
IMP-00000: Import terminated unsuccessfully

it gave me an indication that user adnan might have done the user level export and then i do the following
1- SQL>create user adnan identified by adnan
2- SQL>grant dba to adnan;

3-imp adnan/adnan file=C:\imported\feb_15.DMP log=C:\imported\feb_15_log.log show=y

and i also try this one

imp adnan/adnan file=C:\imported\feb_15.DMP log=C:\imported\feb_15_log.log full=y

but the import terminated with the same error

Export file created by EXPORT:V09.00.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
IMP-00047: unexpected file sequence number; expected 1 but found 129
IMP-00132: first file in the multi-file export is d:\feb_15.DMP
IMP-00000: Import terminated unsuccessfully

i think the user has done the multifile export and there might 2 or 3 or more files created but the client gave me the only one file so i can't be able to do the import
what u'll suggest Sir.

Report message to a moderator