Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: import question ???
> -----Original Message-----
> From: Leslie Lu [mailto:leslie_y_lu_at_yahoo.com]
>
> Are there any size limitation for import file? I got
> a dmp file Amin.dmp with 9706720291 bytes, when I
> imported it, I got:
>
> IMP-00002: failed to open Amin.dmp for read
> IMP-00021: operating system error - error code (dec
> 79, hex 0x4F)
>
> Is the file corrupted or the file is too big? Thanks.
What version of imp/exp? The size limit for some versions of 8.0 and 7.3.4 is 2GB, so your dmp file isn't too big. Did you FTP the dmp file from one server to another in ASCII mode? A dmp file whould be FTPed in binary mode.
![]() |
![]() |