Page 1 of 1

Commit Interval in Oracle Enterprise Stage

Posted: Thu Mar 05, 2009 2:04 pm
by bbobpop1
Hi

Can I specify commit interval (Rows per Transaction) in Oracle Enterprise Stage in Parallel Job?

If yes, can you please let me know how to set the number of rows before commit

Thanks
Bob

Posted: Thu Mar 05, 2009 2:12 pm
by girija
APT_ORAUPSERT_COMMIT_ROW_INTERVAL

Posted: Thu Mar 05, 2009 3:12 pm
by bbobpop1
Thanks Girija. However we can set this Environmental Variable at project Level.

Is there any way to set the commit vaiable at each table / for Specific Oracle Enterprise Stage?

Thanks
bob