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

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem importing file over 2Gb...

Re: Problem importing file over 2Gb...

From: herve.MAYNE <herve.MAYNE_at_wanadoo.fr>
Date: Thu, 30 Sep 1999 09:37:27 +0200
Message-ID: <7sv4m7$487$1@wanadoo.fr>


> hello
> you should verify the limits of your account ( with the command <ulimit>).
> you 'll have two solutions.
> 1) change the limit (see with your super-user (root) ) in the file
> /etc/security/limits (change in the paragraph default the variable fsize
> (number of blocks of 512 bytes ) or insert ofter the paragraph of your
> account the fsize max you want ).don't forget deconnect and reconnect your
> account .
> verify ( ulimit ).
> 2) connect with root.
> enter your variables oracle (ORACLE_SID, ......). and try the import.
> root bypasses the ulimit.
>
> good luck !!

Ps: another method : reduce your export file by a compess and read it with a named pipe

Maria Nordfeldt <mnt98002_at_student.mdh.se> a écrit dans le message : 7sicp8$7v0$2_at_yggdrasil.utfors.se...
> Hi,
> I have problem importing an export-file that is 20 Gb large.
> I'm running IBM AIX 4.3 with Oracle 7.3.4.4. The file is stored
> on a "Large Enabled Filesystem".
> I got ORA-00021 message. "Cannot read file....".
>
> I can read the file with the cat-command or more-command.
>
> I've exported the file on a Digital Unix machine, with the same
> Oracle release.
>
> Has anyone run in to this problem before....
>
> /Maria
>
>
Received on Thu Sep 30 1999 - 02:37:27 CDT

Original text of this message

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