Oracle DBMS_OFFLINE_UTL
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 12.1.0.1 to 12.1.0.2. 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.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Undocumented
AUTHID DEFINER
Dependencies
CDC_CHANGE_TABLES$ DBMS_OUTPUT DBMS_SQL
DBA_REPGENERATED DBMS_REPCAT_ADD_MASTER DBMS_STREAMS_ADM_UTL
DBA_TRIGGERS DBMS_REPCAT_DECL DBMS_SYS_SQL
DBMS_ASSERT DBMS_REPCAT_INTERNAL DBMS_UTILITY
DBMS_INTERNAL_TRIGGER DBMS_REPCAT_UTL MLOG$
DBMS_OFFLINE_OG    
Documented No
Exceptions
Error Code Reason
ORA-26500 Error on caching <object_name>
First Available Not known
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvthofl.plb
Subprograms
 
DISABLE_TRIGGERS
Undocumented dbms_offline_utl.disable_triggers(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
conn sys@pdbdev as sysdba

CREATE TABLE uwclass.t (
testcol NUMBER);

CREATE OR REPLACE TRIGGER uwclass.bi_t
BEFORE INSERT
ON uwclass.t
BEGIN
  NULL;
END bi_t;
/

SELECT trigger_name, status
FROM dba_triggers
WHERE owner = 'UWCLASS';

exec dbms_offline_utl.disable_triggers('UWCLASS', 'T3');
*
ERROR at line 1:
ORA-26500: error on caching "UWCLASS"."T3"
ORA-06512: at "SYS.DBMS_OFFLINE_UTL", line 92
ORA-06512: at line 1
 
ENABLE_TRIGGERS
Undocumented dbms_offline_utl.enable_triggers(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
TBD
 
LOAD_STRING_FROM_TAB
Concatenates the rows of a PL/SQL table into a single string

For related behaviour see DBMS_UTILITY's TABLE_TO_COMMA procedure
dbms_offline_utl.load_string_from_tab(
ddl_txt IN  dbms_sql.varchar2s,
ddl_len IN  NUMBER,
out_txt OUT VARCHAR2);
conn sys@pdbdev as sysdba

DECLARE
  str_array dbms_sql.varchar2s;
  outVal    VARCHAR2(100);
BEGIN
  str_array(1) := 'Dan ';
  str_array(2) := 'Morgan ';
  str_array(3) := 'is the primary author';
  str_array(4) := ' of ';
  str_array(5) := 'Morgan''s Library';

  dbms_offline_utl.load_string_from_tab(str_array, str_array.COUNT, outVal);
  dbms_output.put_line(outVal);
END;
/
 
PRINT_MASTERS
Undocumented dbms_offline_utl.print_masters(
master_list IN dbms_utility.dblink_array);
conn sys@pdbdev as sysdba

DECLARE
 str_array dbms_utility.dblink_array;
BEGIN
  str_array(1) := 'Testing ';
  str_array(2) := 'Yet Again';
  str_array(3) := 'With Limited Success';

  dbms_offline_utl.print_masters(str_array);
END;
/
 
PRINT_STRINGS
Looks like a clone of DBMS_OUTPUT.PUT_LINE. dbms_offline_utl.print_strings(string IN VARCHAR2);
conn sys@pdbdev as sysdba

exec dbms_offline_utl.print_strings('Testing 1 .. 2 .. 3');

Related Topics
DBMS_MVIEW
DBMS_OFFLINE_SNAPSHOT
DBMS_REFRESH
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved