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
Pragmas
PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
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
Downgrade from 11g
dbms_auto_task.downgrade_from_11g;
Do not execute in database 23c
POST_UPGRADE_FROM_10G
Import callout for 10.x to 11.x upgrade
dbms_auto_task_export.post_upgrade_from_10g;
Do not execute in database 23c
SYSTEM_INFO_EXP
Generate PL/SQL for procedural actions
dbms_auto_task_export(
TBD
