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 AEG