Re: Split a dmp file before import
From: joel garry <joel-garry_at_home.com>
Date: Tue, 10 Nov 2009 10:15:34 -0800 (PST)
Message-ID: <2f68712d-8e46-437d-b6ee-0a0b279c4378_at_u25g2000prh.googlegroups.com>
On Nov 10, 4:22 am, 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 10:15:34 -0800 (PST)
Message-ID: <2f68712d-8e46-437d-b6ee-0a0b279c4378_at_u25g2000prh.googlegroups.com>
On Nov 10, 4:22 am, 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
Mark's answer pretty much says it all, but there may be more info available if you tell us what problem you are trying to solve. Disk space? Speed of imp? Redo generation? Trying to parallelize?
jg
-- _at_home.com is bogus. Yay Stu! (Stu and I were buddies years ago): http://www.campinglife.com/output.cfm?ID=2209609Received on Tue Nov 10 2009 - 12:15:34 CST