Oracle Database 18c Express Edition Installation on Windows 10 | Oracle Database 18c XE
After long time, Oracle has released finally Oracle Database 18c Express Edition for Windows x64,
Oracle Database Express Edition (XE) Release 18.4.0.0.0
In this video we are going to demonstrate how to install Oracle Database 18c Express Edition on Windows 10
Oracle Database 18c Express Edition installation in Windows is very easy. This video guides step by step installation.
We are going to learn
1. Database Installation 2. Enterprise Manager Overview
3. SQL Plus tool 4. Oracle Instance Manager to start and shutdown database instance.
Hardware Requirements : Minimum 2 GB RAM, 2 CPU Cores and Enough Hard disk Space.
Software Requirements : OracleXE184_Win64 Zip file for Windows already downloaded from Oracle website.
Important Note: Adobe Flash player must be installed in order to browse Enterpise Manager Console on Internet Explorer.
Installation method : Offline, Oracle Database 18c Zip file for Windows downloaded and installed.
download link: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html
Oracle Database 18c XE Features
###############################
Oracle Multitenant
SQLJ
Microsoft Distributed Transaction Coordinator support
Native .NET Data Provider—ODP.NET
.NET Stored Procedures
Online index rebuild
Online table organization
Online table redefinition
Trial recovery
Fast-start fault recovery
Flashback Table
Flashback Database
Cross-platform Backup and Recovery
Sharded Queues
Network Compression
Client Side Query Cache
Query Results Cache
PL/SQL Function Result Cache
Adaptive Execution Plans
In-Memory Column Store
In-Memory Aggregation
Attribute Clustering
Column-Level Encryption
Tablespace Encryption
Oracle Advanced Security
Oracle Database Vault
Oracle Label Security
Centrally Managed Users
Fine-grained auditing
Privilege Analysis
Real Application Security
Redaction
Transparent Sensitive Data Protection
Virtual Private Database
Oracle Spatial and Graph
Property Graph and RDF Graph Technologies (RDF/OWL)
Partitioned spatial indexes
Oracle Partitioning
Oracle Advanced Analytics
Oracle Advanced Compression
Advanced Index Compression
Prefix Compression (also called Key Compression)
Basic Table Compression
Deferred Segment Creation
Bitmapped index, bitmapped join index, and bitmap plan conversions
Transportable tablespaces, including cross-platform and full transportable export and import
Summary management—Materialized View Query Rewrite.