Re: Split a dmp file before import

From: Sashi <>
Date: Tue, 10 Nov 2009 12:56:48 -0800 (PST)
Message-ID: <>

On Nov 10, 1:15 pm, joel garry <> wrote:
> On Nov 10, 4:22 am, Sashi <> 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
> --
> is bogus.
> Yay Stu!  (Stu and I were buddies years ago):

Thanks for your replies, and that pretty much sums it up well for me. My problem is that my archiver keeps getting filled up, and I'm running short of disk space. It's unable to generate enough undo tablespace to represent my transaction.
I googled around and took the approach of commiting regularly and using a buffer size of 50 MB.
The DMP file is actually a single table, and is about 950 MB. So on my import command I set commit=Y and buffer=50000000. This is on solaris 10.

Sashi Received on Tue Nov 10 2009 - 14:56:48 CST

Original text of this message