Oracle | DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_EXPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

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