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 |
User-defined data types (ADTs) | Yes | Yes, for 10.2 No, for 10.1 |
Single partition reorg | Yes | No |
Single sub-partition reorg | Yes | No |
Change partitioning (ie.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 | Yes | No |
Parallel multi-table reorg | Yes | No |