| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Perform manual purge of the Notification table |
| AUTHID |
CURRENT_USER |
| Dependencies |
| ALL_NOTIFICATION_DIRECTIVES |
DBMS_SYS_ERROR |
| DBA_NOTIFICATION_DIRECTIVES |
INT$DBA_NOTIFICATION_DIRECTIVES |
| DBMS_DIRECTIVES_LIB |
NOTIFICATION$ |
|
| Documented |
No |
| First Available |
26ai |
| Pragma |
SUPPLEMENTAL_LOG_DATA(DEFAULT, AUTO) |
| Security Model |
Owned by SYS with EXECUTE granted to PUBLIC |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsdirtv.sql
{ORACLE_HOME}/rdbms/admin/prvtdirtv.plb |
| |
PURGE_NOTIFICATION_TABLE (new 26ai)  |
| Undocumented |
dbms_directives.purge_notification_table(
notification_directive_name IN VARCHAR2,
purge_scn IN NUMBER); |
| TBD |