Re: Split a dmp file before import
From: gazzag <gareth_at_jamms.org>
Date: Tue, 10 Nov 2009 07:02:33 -0800 (PST)
Message-ID: <44bf4fcc-4753-42d9-8b8c-dba8a057b7ae_at_s31g2000yqs.googlegroups.com>
On 10 Nov, 12:22, Sashi <small..._at_gmail.com> wrote:
> Hi all, I have a dmp file that contains about 9 million rows.
> Is there a utility/technique that will split the file into two (or
> more) so that I can run the import in two (or more)
> stages?
>
> Thanks,
> Sashi
Date: Tue, 10 Nov 2009 07:02:33 -0800 (PST)
Message-ID: <44bf4fcc-4753-42d9-8b8c-dba8a057b7ae_at_s31g2000yqs.googlegroups.com>
On 10 Nov, 12:22, Sashi <small..._at_gmail.com> wrote:
> Hi all, I have a dmp file that contains about 9 million rows.
> Is there a utility/technique that will split the file into two (or
> more) so that I can run the import in two (or more)
> stages?
>
> Thanks,
> Sashi
- What Oracle version?
- What operating system?
Importing from a compressed pipe springs to mind but that's subject to your reply to my second question.
HTH -g Received on Tue Nov 10 2009 - 09:02:33 CST