| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Export utility for Auto Tasks |
| AUTHID |
CURRENT_USER |
| Dependencies |
| DBA_AUTOTASK_CLIENT |
DBA_SCHEDULER_WINDOWS |
DBMS_SCHEDULER |
| DBA_AUTOTASK_OPERATION |
DBA_SCHEDULER_WINDOW_GROUPS |
DBMS_STANDARD |
| DBA_AUTOTASK_STATUS |
DBA_SCHEDULER_WINGROUP_MEMBERS |
KET$_CLIENT_CONFIG |
| DBA_RSRC_PLAN_DIRECTIVES |
DBMS_AUTO_TASK_ADMIN |
KUPM$MCP |
| DBA_SCHEDULER_JOBS |
DBMS_RESOURCE_MANAGER |
|
|
| Documented |
No |
| First Available |
11.1 |
| Pragmas |
PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED); |
| Security Model |
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE, EXP_FULL_DATABASE, and IMP_FULL_DATABASE roles |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsatsk.sql |
| Subprograms |
|
| |
| DOWNGRADE_FROM_11G |
| Downgrade from 11g |
dbms_auto_task.downgrade_from_11g; |
Deprecated
Do not execute in database 23ai |
| |
| POST_UPGRADE_FROM_10G |
| Import callout for 10.x to 11.x upgrade |
dbms_auto_task_export.post_upgrade_from_10g; |
Deprecated
Do not execute in database 23ai |
| |
| SYSTEM_INFO_EXP |
| Generate PL/SQL for procedural actions |
dbms_auto_task_export(
prepost IN PLS_INTEGER,
connectstring OUT VARCHAR2,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2; |
| TBD |