Re: How can I ignore a file in a multifile import

From: G M <zlmei_at_hotmail.com>
Date: 30 Apr 2002 12:03:57 -0700
Message-ID: <50a5e6b6.0204301103.104c5430_at_posting.google.com>


I don't know if there is a way to skip a particular dump file. But there are a couple of alternatives to think about:

  1. Export data with compression (using unix pipe). This way you might be able to create only on edump file with size < 2GB. Therefore it would not have any problem in Import.
  2. Since you only needs a small set of data in the table, you can write an sql to spool only the needed data to a text file, then use sql loader to populate the table inetead of Imp.

HTH. Guang

lsantos_at_pobox.com (Luis Santos) wrote in message news:<c0ef83a3.0204291206.92f5156_at_posting.google.com>...
> Hi,
>
> I have to do a import of a large export file. This exports contains
> only one table, and was done using the filesize parameter. Each file
> has 2Gb. There are 8 (eight) files.
>
> I discovered that the second file is corrupted.
>
> I have tried to specify, in the files parameter, all the files
> except the second. This didn“t work, and the import failed,
> complaining that the file found was the third, not the second in the
> sequence.
>
> I know that all the data in the second file is not important, as
> the user is only interested in rows of a specific day of the month.
> And this day is 21.
>
> So, probably, the data the user wants is located in the #5 or #6
> files.
>
> Is there a way to make the import utility ignore one file of a
> sequence of import files, done by an export with the filesize
> parameter?
>
> Best regards,
> Luis Santos
Received on Tue Apr 30 2002 - 21:03:57 CEST

Original text of this message