Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
Utility supporting Oracle Workspace Manager version enabled tables.
AUTHID
DEFINER
Dependencies
ALL_LOG_GROUPS
DBA_TAB_PRIVS
OWM_BULK_LOAD_PKG
ALL_LOG_GROUP_COLUMNS
DBA_TRIGGERS
OWM_DYNSQL_ACCESS
ALL_NESTED_TABLES
DBA_TYPE_ATTRS
OWM_MIG_PKG
ALL_USERS
DBA_UNUSED_COL_TABS
OWM_MP_PKG
CCOL$
DBA_VIEWS
OWM_VSCRIPT_PKG
CDEF$
DBMS_LOCK
PLITBLM
COL$
DUAL
UD_TRIGS
CON$
KU$_DDL
WM$COLUMN_PROPS
DBA_COL_PRIVS
KU$_DDLS
WM$CONSTRAINTS_TABLE
DBA_CONSTRAINTS
LT
WM$CONS_COLUMNS
DBA_CONS_COLUMNS
LTADM
WM$DBA_TAB_COLS
DBA_INDEXES
LTDDL
WM$NESTED_COLUMNS_TABLE
DBA_IND_COLUMNS
LTDTRG
WM$RIC_TABLE
DBA_IND_EXPRESSIONS
LTRIC
WM$UDTRIG_DISPATCH_PROCS
DBA_JOIN_IND_COLUMNS
LTUTIL
WM$UDTRIG_INFO
DBA_NESTED_TABLES
LT_CTX_PKG
WM$VERSIONED_TABLES
DBA_TABLES
LT_EXPORT_PKG
WM$VERSIONED_TABLES$H
DBA_TABLESPACES
OBJ$
WM_DDL_UTIL
DBA_TAB_COLS
OWM_ASSERT_PKG
WM_ERROR
Documented
No
Exceptions
Error Code
Reason
ORA-20132
table '<schema_name>.<table_name>' is not version enabled
ORA-20337
This table can only be dropped by dbms_wm.rollbackDDL/commitDDL
owm_ddl_pkg.beginDDL(
table_owner_var IN VARCHAR2,
table_name_var IN VARCHAR2);
BEGIN
wmsys.owm_ddl_pkg.beginDDL('SCOTT', 'EMP');
END;
/
DECLARE
*
ERROR at line 1:
ORA-20132: table 'SCOTT.EMP' is not version enabled
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 3918
ORA-06512: at "WMSYS.WM_ERROR", line 449
ORA-06512: at "WMSYS.WM_ERROR", line 463
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 3812
ORA-06512: at line 4
SQL> BEGIN
2 dbms_wm.EnableVersioning('SCOTT.EMP');
3 END;
4 /
PL/SQL procedure successfully completed.
SQL> BEGIN
2 wmsys.owm_ddl_pkg.beginDDL('SCOTT', 'EMP');
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-04088: error during execution of trigger 'WMSYS.NO_VM_DDL'
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2351
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2295
ORA-00604: error occurred at recursive SQL level 2
ORA-20337: This table can only be dropped by dbms_wm.rollbackDDL/commitDDL
ORA-06512: at "WMSYS.LTADM", line 9803
ORA-06512: at "WMSYS.WM_ERROR", line 449
ORA-06512: at "WMSYS.WM_ERROR", line 456
ORA-06512: at "WMSYS.LTADM", line 9692
ORA-06512: at line 17
ORA-06512: at "WMSYS.OWM_DDL_PKG", line 2292
ORA-06512: at line 2
owm_ddl_pkg.commitDDL(
table_owner_var IN VARCHAR2,
table_naem_var IN VARCHAR2,
ignore_last_erorr IN BOOLEAN,
enforce_unique_constraints IN BOOLEAN,
enforce_rics IN BOOLEAN);
owm_ddl_pkg.compareIndexProperties(
cons_owner_var IN VARCHAR2,
cons_name_var IN VARCHAR2,
cons_type_var IN VARCHAR2,
table_name_var IN VARCHAR2,
ve_index_owner IN VARCHAR2,
ve_index_name IN VARCHAR2)
RETURN VARCHAR2;
owm_ddl_pkg.getUCDetails(
index_owner_var IN VARCHAR2,
index_name_var IN VARCHAR2,
table_owner_var IN VARCHAR2,
table_name_var IN VARCHAR2)
RETURN VARCHAR2;