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 will be available on generic Linux platforms in January and soon on AIX and Windows

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