› Fóruns › Banco de dados Oracle › RESUMABLE › RESUMABLE
vierivc tem que dar grant de resumable e disparar o alter session no código do programa, não tem mistério.
de uma lida abaixo , se tiver dúvida posta aqui.
ALTER SESSION ENABLE RESUMABLE [TIMEOUT integer] [NAME string]
Allows an operation to be suspended in the event of an out-of-space error condition and to resume automatically from the point of interruption when the error condition is fixed.
TIMEOUT: specify (in seconds) the time during which an operation can remain suspended while waiting for the error condition to be fixed. If the error condition is not fixed within the TIMEOUT period, then the suspended operation is aborted.
NAME: specify a user-defined text string to help identify the statements issued during the session while the session is in resumable mode. The text string is inserted into USER_RESUMABLE and DBA_RESUMABLE data dictionary views. If no NAME is specified, then the default string ‘User username(userid), Session sessionid, Instance instanceid is inserted.
ALTER SESSION DISABLE RESUMABLE