DBControl Online vs. Oracle Enterprise
Manager (OEM)
for Online Reorg
For Oracle users, DBControl Online
clearly provides the competitive advantage when performing database
reorganizations, structural changes or partition management.
Note: Only
OEM for Oracle 9i and later supports online redefinition.
Point / Feature
DBControl
Online
OEM
Oracle 8.1.7, 8.1.6, and 8.0
Yes
No
Protect against
“ORA-01555: Snapshot too old”
Yes
No
SAP
Yes
No
LONG and LONG RAW
Yes
No
User-defined data types (ADTs)
Yes
Yes, for 10.2
No, for 10.1
Single partition reorg
Yes
Yes, for 10.2
No, for 10.1
Single sub-partition reorg
Yes
No
Change partitioning (i.e. range to hash)
Yes
No
Table without primary key
Yes
Yes, for 9.2
No, for 9.0
Full Structure Change
Yes
No
Advanced Queueing (AQ) Table
Yes
Yes, for 10.2
No, for 10.1
Robust recompiling of related objects in Oracle Applications
/ E-Business Suite
Yes
No
Archiving / Filtering
Yes
No
Track real-time progress
Yes
No
Schedule Switchover
Yes
No
Tables propagated by
Change Data Capture (CDC)
Yes
No
Can preserve object ID
Yes
No
Manage (Abort, Recover, etc.) individual tables in
multi-table reorg