Oracle OWM_IEXP_PKG
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Oracle Workspace Management Import Export Utilities
AUTHID DEFINER
Dependencies
ALL_CONSTRAINTS LTADM WM$DBA_TAB_COLS
ALL_CONS_COLUMNS LTRIC WM$VERSION_HIERARCHY_TABLE
ALL_TABLES LTUTIL WM$WORKSPACES_TABLE
ALL_TAB_COLS LT_CTX_PKG WM$WORKSPACE_SAVEPOINTS_TABLE
ALL_VIEWS OWM_ASSERT_PKG WM_DDL_UTIL
DUAL OWM_DYNSQL_ACCESS WM_ERROR
LT    
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owmiexps.plb
Subprograms
 
EXPORT
  owm_iexp_pkg.export(
table_owner             IN VARCHAR2,
table_name              IN VARCHAR2,
st_owner_v              IN VARCHAR2,
st_name_v               IN VARCHAR2,
state                   IN VARCHAR2,
user_where_clause_v     IN VARCHAR2,
system_where_clause     IN NUMBER,
sp_version              IN NUMBER,
instant                 IN DATE,
versioned_db            IN BOOLEAN,
overwrite_existing_data IN BOOLEAN);
TBD
 
IMPORT
  owm_iexp_pkg.import(
table_owner         IN VARCHAR2,
table_name          IN VARCHAR2,
st_owner            IN VARCHAR2,
st_name             IN VARCHAR2,
TO_workspace        IN VARCHAR2,
from_workspace      IN VARCHAR2,
user_where_clause   IN VARCHAR2,
system_where_clause IN NUMBER,
ancestor_version    IN NUMBER,
apply_locks         IN BOOLEAN,
enforceUCFlag       IN BOOLEAN,
enforceRICFlag      IN BOOLEAN,
mp_root_workspace   IN VARCHAR2);
TBD
 
WMFLAGENCODE
  owm_iexp_pkg.wmFlagEncode(
wm_version   IN NUMBER,
wm_nextver   IN VARCHAR2,
wm_delstatus IN NUMBER,
wm_ltlock    IN VARCHAR2,
state        IN VARCHAR2)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_WM
LTAQ
LTDTRG
OWM_ASSERT
OWM_CPKG_PKG
OWM_DDL
What's New In 12cR2
What's New In 18cR3

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-2019 Daniel A. Morgan All Rights Reserved