CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_AUTO_TASK_EXPORT
Version 11.1
 
General
Source $ORACLE_HOME/rdbms/admin/dbmsatsk.sql
First Available 11.1
Dependencies
DBA_AUTOTASK_CLIENT DBA_SCHEDULER_WINGROUP_MEMBERS
DBA_AUTOTASK_OPERATION DBMS_AUTO_TASK_ADMIN
DBA_AUTOTASK_WINDOW_CLIENTS DBMS_AUTO_TASK_EXPORT
DBA_RSRC_PLAN_DIRECTIVES DBMS_RESOURCE_MANAGER
DBA_SCHEDULER_JOBS DBMS_SCHEDULER
DBA_SCHEDULER_WINDOWS KET$_CLIENT_CONFIG
DBA_SCHEDULER_WINDOW_GROUPS KUPM$MCP
Security Model GRANT EXECUTE ON dbms_auto_task_export TO EXECUTE_CATALOG_ROLE;
GRANT EXECUTE ON dbms_auto_task_export TO EXP_FULL_DATABASE;
GRANT EXECUTE ON dbms_auto_task_export TO IMP_FULL_DATABASE;
 
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
 

Related Topics

DBMS_AUTO_TASK

DBMS_AUTO_TASK_ADMIN

DBMS_AUTO_TASK_IMMEDIATE

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [165 users online]    © 2010 psoug.org