| General Information |
| Purpose |
Submits an undo advisor task for execution |
| Source |
{ORACLE_HOME}/rdbms/admin/prvt |
| First Available |
10.1 |
| Dependencies |
| DBMS_UNDOADV_LIB |
WRI$_ADV_UNDO_ADV |
|
| Security Model |
Owned by SYS with no privileges granted |
| |
| EXECUTE |
| Submits an advsor task for to be executed.
This not something easily demonstrated so the demo at the right is for education purposes only. |
prvt_udv.execute(task_id IN BINARY_INTEGER); |
SQL> exec prvt_uadv.execute(562);
BEGIN prvt_uadv.execute(562); END;
*
ERROR at line 1:
ORA-13605: The specified task or object 562 does not exist for the current user.
ORA-06512: at "SYS.PRVT_UADV", line 10
ORA-06512: at line 1 |
