Oracle XE Features

Oracle Database Tips by Burleson Consulting
January 17, 2015

Question: What features are available on Oracle Express XE edition? Can I use replication with Oracle XE?

Answer: In general, Oracle SE and XE do not contain advanced DBA features. ee here for EE SE and XE features:

These features are not included with Oracle Database XE:

Advanced Security Option
interMedia
Messaging Gateway
Oracle Change Management Pack
Oracle Clusterware
Oracle Configuration Management Pack
Oracle Connection Manager
Oracle Data Guard
Oracle Data Mining
Oracle Diagnostic Pack
Oracle Enterprise Manager
Oracle Fail Safe
Oracle Label Security
Oracle Names
Oracle OLAP
Oracle Partitioning
Oracle Real Application Clusters
Oracle Spatial
Oracle Streams (Apply process only)
Oracle Tuning Pack
Oracle Workflow
Oracle Workspace Manager
Ultra Search

This Oracle corporation document notes the available data movement and integration features in Oracle Database XE.

XE Data Movement/Integration Features

Feature

Availability

Direct Path Load API Yes

External tables Yes

External procedures Yes

Synchronous Change Data Capture No

Asynchronous Change Data Capture No

Transportable tablespaces, including cross-platform No

Advanced Queuing Yes

Basic Replication Yes (read-only and updated materialized view - site-only)

Advanced Replication No

Distributed queries Yes

Distributed transactions Yes

Transparent Gateways No

Generic connectivity Yes