Re: Importing without using Rollback segment ?

From: Dave Wotton <Dave.Wotton_at_no-spam.it.camcnty.gov.uk>
Date: 30 Oct 1998 20:40:24 GMT
Message-ID: <71d87o$19i$1@dns.camcnty.gov.uk>

Nicolas Begat <Nicolas.Begat_at_NetValley.fr> wrote:
>
> I would like to import some tables from a dump file WITHOUT using
>rollback segment (A problem of space as you would guess) and have no
>idea how to (In fact I don't think that it is possible).

You can't import without using the rollback segments, but you can use the imp option COMMIT=Y. This causes the import to commit after every buffer of data has been loaded and not just at the end of each table, which is the default method. As you're commiting much more frequently, you're rollback segments won't need to grow. look also at the BUFFER parameter. You can safely set it to something like 300000.

Dave.
--
Remove the no-spam bit from my email address to reply. Received on Fri Oct 30 1998 - 14:40:24 CST