| General |
| Source |
$ORACLE_HOME/rdbms/admin/dbmsatsk.sql |
| First Available |
11.1 |
| Dependencies |
| DBA_AUTOTASK_CLIENT |
DBA_SCHEDULER_WINGROUP_MEMBERS |
| DBA_AUTOTASK_OPERATION |
DBMS_AUTO_TASK_ADMIN |
| DBA_AUTOTASK_WINDOW_CLIENTS |
DBMS_AUTO_TASK_EXPORT |
| DBA_RSRC_PLAN_DIRECTIVES |
DBMS_RESOURCE_MANAGER |
| DBA_SCHEDULER_JOBS |
DBMS_SCHEDULER |
| DBA_SCHEDULER_WINDOWS |
KET$_CLIENT_CONFIG |
| DBA_SCHEDULER_WINDOW_GROUPS |
KUPM$MCP |
|
| Security Model |
GRANT EXECUTE ON dbms_auto_task_export TO
EXECUTE_CATALOG_ROLE;
GRANT EXECUTE ON dbms_auto_task_export TO EXP_FULL_DATABASE;
GRANT EXECUTE ON dbms_auto_task_export TO IMP_FULL_DATABASE; |
| |
| DOWNGRADE_FROM_11G |
| downgrade from 11g |
dbms_auto_task.downgrade_from_11g; |
| exec dbms_auto_task_export.downgrade_from_11g; |
| |
| POST_UPGRADE_FROM_10G |
| Import callout for 10.x to 11.x upgrade |
dbms_auto_task_export.post_upgrade_from_10g; |
| exec dbms_auto_task_export.post_upgrade_from_10g; |
| |
| 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 |
