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 |