Commit Interval in Oracle Enterprise Stage

bbobpop1 · Post by **bbobpop1** » Thu Mar 05, 2009 2:04 pm

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

girija · Post by **girija** » Thu Mar 05, 2009 2:12 pm

APT_ORAUPSERT_COMMIT_ROW_INTERVAL

bbobpop1 · Post by **bbobpop1** » Thu Mar 05, 2009 3:12 pm

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