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

The oracle utility import does only INSERT. It never does UPDATE or DELETE.

If you do a big import, you can have big rollback segment. You can have a big SORT_AREA_SIZE
in the INITsid.ORA file (if you create indexes). Before import the data, you run a SQL script to take the small rollback segment OFFLINE.

naveen_arora_at_my-dejanews.com a écrit:

> 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 28 1999 - 14:53:54 CST