Oracle | LTDDL

Oracle LTDDL Version 21c

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 Workspace Management DDL Utilities

AUTHID DEFINER

Dependencies

LT	OWM_CPKG_PKG	WM$RIC_TABLE
LTADM	OWM_DDL_PKG	WM$VERSIONED_TABLES
LTRIC	OWM_DYNSQL_ACCESS	WM_DDL_UTIL
LTUTIL	PLITBLM	WM_ERROR
LT_CTX_PKG	UD_TRIGS	WM_PERIOD
OWM_ASSERT_PKG

Documented No

First Available Not Known

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmddls.plb

Subprograms

DISABLEVERSIONING	GETVARIABLE_B	UNDOENABLEVER
ENABLEVERSIONING	GETVARIABLE_I

DISABLEVERSIONING

Undocumented ltddl.disableversioning( table_owners IN wmsys.ltutil.wm$ident_tab, table_names IN wmsys.ltutil.wm$ident_tab, force_v IN BOOLEAN, ignore_last_error IN BOOLEAN, keepwmvalid IN BOOLEAN undo_space IN VARCHAR2);

TBD

ENABLEVERSIONING

Undocumented ltddl.enableversioning( table_owners IN wmsys.ltutil.wm$ident_tab, table_names IN wmsys.ltutil.wm$ident_tab, hist IN VARCHAR2, validtime IN BOOLEAN, vtrange IN wmsys.wm_period, undo_space IN VARCHAR2);

TBD

GETVARIABLE_B

Undocumented

This function, possibly the entire package, is protected by an ACCESSIBLE BY clause ltddl.getvariable_b(varname IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF wmsys.ltddl.getvariable_b THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

       IF wmsys.ltddl.getvariable_b THEN

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object LTDDL

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

GETVARIABLE_I

Undocumented ltddl.getvariable_i(varname IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab;

TBD

UNDOENABLEVER

Undocumented ltddl.undoenablever( schema IN VARCHAR2, tab_name IN VARCHAR2, sql_stmt IN VARCHAR2, sql_err IN VARCHAR2, execundo IN BOOLEAN);

TBD