Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User Cloning
In article <01bcedf5$d5abae60$1e40f1cf_at_ww.wwa.com>, Peaches
<fsgchi_at_wwa.com> writes
>Andy Hardy <Andy_Hardy_at_camk.demon.co.uk> wrote in article
>> I also believe that the COMMIT parameter merely commits any rows loaded
>> during an aborted import rather than the rolling them back as usual.
>
>Yes, but if you have a Very large (read millions of rows) table, then you
>may not have a rollback segment that is appropriately large to accommodate
>the entire table. If you assume that your export was correct, then your
>import will probably not abort.
You are right, of course. The usual rollback behaviour is to rollback any object (e.g. a table) which produced an error - the COMMIT option performs a commit on each array insert.
Andy
-- Andy Hardy Senior IT Systems Engineer Cegelec AEG ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions are mine and do not necessarily reflect those of Cegelec AEGReceived on Wed Nov 12 1997 - 00:00:00 CST
![]() |
![]() |