Oracle | OWM_BULK_LOAD

Oracle OWM_BULK_LOAD_PKG 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 Oracle Workspace Management bulk load utilities

AUTHID CURRENT_USER

Dependencies

DBA_CONSTRAINTS	LTADM LTDEFINER	WM$DBA_TAB_COLS
DBA_CONS_COLUMNS	LTI	WM$MODIFIED_TABLES
DBA_IND_COLUMNS	LTRIC	WM$RIC_TABLE
DBA_TABLES	LTUTIL	WM$VERSIONED_TABLES
DBA_TRIGGERS	LT_CTX_PKG	WM$VERSIONED_TABLES$D
DBMS_LOB	OWM_ASSERT_PKG	WM$VERSION_HIERARCHY_TABLE
DBMS_LOCK	OWM_DDL_PKG	WM$VT_ERRORS_TABLE
DBMS_UTILITY	OWM_DYNSQL_ACCESS	WM$WORKSPACES_TABLE
LT	WM$CONSTRAINTS_TABLE	WM_ERROR

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/owmblkls.plb

Subprograms

BEGINBULKLOADING	EXISTSTABLE	purgeTABLE
CHECKFORBULKLOADING	FIXOWMCOLSWHIST	ROLLBACKBULKLOADING
ENDBULKLOADING	ISBEINGBULKLOADED	SETLTLOCKINFO

BEGINBULKLOADING

Undocumented owm_bulk_load_pkg.beginBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, workspace IN VARCHAR2, savepoint_name IN VARCHAR2, check_for_duplicates IN BOOLEAN, ignore_last_error IN BOOLEAN, single_transaction IN BOOLEAN);

TBD

CHECKFORBULKLOADING

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.checkForBulkLoading(workspace_var IN VARCHAR2);

exec wmsys.owm_bulk_load_pkg.checkForBulkLoading('UW_WS');

           *

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

ENDBULKLOADING

Undocumented owm_bulk_load_pkg.endBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, user_name_var IN VARCHAR2, discards_table_owner IN VARCHAR2, discards_table_name IN VARCHAR2, enforceucflag IN BOOLEAN, enforcericflag IN BOOLEAN, ignore_last_error IN BOOLEAN);

TBD

EXISTSTABLE

Returns TRUE if a table exists, else FALSE

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.existsTable( towner IN VARCHAR2, tabname IN VARCHAR2) RETURN BOOLEAN;

exec wmsys.owm_bulk_load_pkg.existsTable(USER, 
      'TAB$');

           *

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

FIXOWMCOLSWHIST

Undocumented owm_bulk_load_pkg.fixOWMColSWHist( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, user_name_var IN VARCHAR2, workspace_var IN VARCHAR2, version_var IN NUMBER, bulkloadversionvar IN NUMBER, updateonlydls IN BOOLEAN);

TBD

ISBEINGBULKLOADED

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.isBeingBulkLoaded( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_bulk_load_pkg.isBeingBulkLoaded THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

purgeTABLE

Undocumented owm_bulk_load_pkg.purgeTable( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, archive_table_owner IN VARCHAR2, archive_table_name IN VARCHAR2, where_clause IN VARCHAR2, workspace_var IN VARCHAR2, version_var IN NUMBER, instant IN TIMESTAMP WITH TIME ZONE, purgeafter IN BOOLEAN);

TBD

ROLLBACKBULKLOADING

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.rollbackBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, ignore_last_error IN BOOLEAN);

exec wmsys.owm_bulk_load_pkg.rollbackBulkLoading('SYS', 'TAB$', FALSE);

      *

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

SETLTLOCKINFO

Undocumented owm_bulk_load_pkg.setLTLockInfo(wm_ltlock IN VARCHAR2) RETURN VARCHAR2;

TBD