Re: Disable rollbacks
Date: 25 Aug 1994 00:14:46 -0000
Message-ID: <33gnpm$5ij_at_isbank.isbank.is>
In <12a.4292.905_at_compudata.com> barry.roomberg_at_compudata.com (Barry Roomberg) writes:
>Somebody claimed a while ago to have a method of disabling
>rollbacks during inserts (and I don't mean using discrete transactions).
>During an imp, I'd like to do this. I accept the fact that a failure
>will totally trash the database causing the need for re-initialization.
>Is this a dream, or is it possible?
imp has an optional parameter called COMMIT. If you set it to Y, imp will commit array inserts. Means that you won't have rollback errors if importing large datasets. It's in the manual. If you run imp interactivly you wont be asked for this parameter. You have to enter it on the command line or in a command file. e.g. imp userid=scott/tiger file=mydata.exp commit=Y imp help=Yes will give all command line switches.
failure wont crash the database, you will just have to drop the tables and start again. (If you are adding data, instaed of replacing, then you might be in trouble.... maybe you could then replace the datafiles of that tablespace from a backup and then do a database recovery to a the timepoint when you started the imp?) Received on Thu Aug 25 1994 - 02:14:46 CEST