Re: 9i SAVEPOINT question

In article <1132852168.796193.294870_at_g49g2000cwa.googlegroups.com>, dbaxchange.dba_at_gmail.com says...
> If Space issues are your concern then you can use the resumable space
> management feature available with oracle9i instead of savepoints. It is
> generally not a good idea to commit frequently and also doing loads in
> batches causes other headaches like program restartability.You can use
> the resumable space management feature without any issues except if
> your code has queries or operations against remote objects.
> To utilize this feature the user needs the "resumable" system
> privilege. With this privilege available, prior to starting the
> process, you can set this for the session:
>
> -- Set up timeout for 20 hours!
> SQL> alter session enable resumable timeout 72000 name 'Project_name';
>
> You can setup an "after suspend" trigger which can send you a page or
> an email notification in the event of space issues.
>
> Hope this helps!
>
> http://www.dbaxchange.com
> (One stop site for practical solutions to oracle issues, oracle
> findings, Book recommendations, International job search site
> recommendations and much more....)
>
>

Thanks - restartability is not an issue - the logic for that is programmed in. Will take a look at DBMS_RESUMABLE

thanks

-- 

jeremy