Oracle 12c DBMS_AUTO_TASK

Oracle DBMS_AUTO_TASK_EXPORT Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Purpose

Export utility for Auto Tasks

AUTHID

CURRENT_USER

Dependencies

DBA_AUTOTASK_CLIENT	DBA_SCHEDULER_WINDOWS	DBMS_RESOURCE_MANAGER
DBA_AUTOTASK_OPERATION	DBA_SCHEDULER_WINDOW_GROUPS	DBMS_SCHEDULER
DBA_AUTOTASK_STATUS	DBA_SCHEDULER_WINGROUP_MEMBERS	KET$_CLIENT_CONFIG
DBA_RSRC_PLAN_DIRECTIVES	DBMS_AUTO_TASK_ADMIN	KUPM$MCP
DBA_SCHEDULER_JOBS

Documented

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