Oracle | DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_EXPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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