Oracle 12cR2 DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_EXPORT Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"

~ Sen. Tammy Duckworth

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.0.6

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

POST_UPGRADE_FROM_10G

SYSTEM_INFO_EXP

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