Re: Question regarding Oracle backup

From: Mark Bateman <batemam_at_bibip1.wgw.bt.co.uk>
Date: 1997/03/05
Message-ID: <331D4560.1E36@bibip1.wgw.bt.co.uk>#1/1

Zoran wrote:

:[ snip - argument for using export/import ]

:
: Another piece of advice for the import.... use commit=y. That way
: Oracle will commit after every insert instead on only once at the end
: of the entire import - you may run out of rollback segment space if
: you don't.

Using commit=y does slow down the import process though.

-- 
Mark Bateman

Received on Wed Mar 05 1997 - 00:00:00 CST