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

From: <mgogala_at_yahoo.com>
Date: Fri, 29 Jan 1999 18:24:23 GMT
Message-ID: <78suca$ues$1@nnrp1.dejanews.com>

In article <36B0CE62.A35AB505_at_club-internet.fr>, Jean-Claude Matarazzo <jcmata_at_club-internet.fr> wrote:
> 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
>
>

Combination of buffer and commit parameters will produce the result you need. If your command is:
imp system/manager file=myfile buffer=10485760 commit=yes full=yes,

it will commit every 10 megs.

Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 29 1999 - 12:24:23 CST