Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: import question ???

RE: import question ???

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 01 Aug 2001 11:46:55 -0700
Message-ID: <F001.0035C71A.20010801114525@fatcity.com>

> -----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.



Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Wed Aug 01 2001 - 13:46:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US