Oracle | LTDDL

Oracle LTDDL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Workspace Management DDL Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_LOCK	LT_CTX_PKG	UD_TRIGS
LT	OWM_ASSERT_PKG	WM$RIC_TABLE_USER
LTADM	OWM_CPKG_PKG	WM$VERSIONED_TABLES_USER
LTDEFINER	OWM_DDL_PKG	WM_DDL_UTIL
LTRIC	OWM_DYNSQL_ACCESS	WM_ERROR
LTUTIL	PLITBLM	WM_PERIOD

Documented No

First Available Not Known

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by 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;

      /

      *

      PLS-00904: insufficient privilege to access object LTDDL

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