Re: COMMIT IN EXPORT!!!!!!(URGENT!!)

Hi Arora,

    by default commit parameter during import is no and it means commit will
take place after loading each table. If you specify the commit to YES then it will
submit the commit statement each set of array of data . The meaning of set of array of
data is that ,, the amount of data that fits in the buffer array.. . This buffer array, has to be
specified and is usually system dependent. for e.g

    imp sytem/manager file=expdat.dmp full=Y buffer=65536

so in this case if your buffer fills the it will issue the commit statement..

good luck..

pradhan

naveen_arora_at_my-dejanews.com wrote:

> hi,
> i use EXP / IMP for export / import , i hvae few queries :
> 1. While IMPORTING WHEN DOES COMMIT OCCUR ?
> AT THE END OR IN BETWEEN THE IMPORT ?
> 2. IF A ROW IS UPDATED (not deleted or inserted)
> and there is a unique column, will it be restored back ?
> i am using oracle 7.3.2
> thanks
> naveen
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 21 1999 - 07:39:01 CST