Oracle 19cR2 DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_EXPORT Version 19.2.0.1

General Information

Library Note

Morgan's Library Page Header

For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.

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