Import Failed [message #306400] |
Fri, 14 March 2008 01:47 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|