Home » RDBMS Server » Server Utilities » Import Failed (Oracle 9.0.2.0.6 Windows XP)
Import Failed [message #306400] Fri, 14 March 2008 01:47 Go to next message
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.
Re: Import Failed [message #306403 is a reply to message #306400] Fri, 14 March 2008 01:55 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first warning is not important as long as you have the imp_full_database or dba role.

Quote:
what u'll suggest Sir

To get the other files.

Regards
Michel
Previous Topic: moving partitioned tables between databases
Next Topic: Vim: Error reading input, exiting...ut" 629L, 31156C
Goto Forum:
  


Current Time: Sun Dec 04 16:44:21 CST 2016

Total time taken to generate the page: 0.10094 seconds