oracle-schema-design git:20261019.6daae50A

Immutable. This exact content never changes and is served at /api/v1/blob/b2ffdf22910a8904.

---
name: oracle-schema-design
description: Oracle tablespace, partitioning, indexing, and PL/SQL package schema design patterns.
---

# Oracle Schema Design

1. Separate transactional and archival tablespaces and prefer range-interval partitioning for time-series tables.
2. Encapsulate data-manipulation logic inside versioned PL/SQL package specifications (`.pks`) and bodies (`.pkb`).
3. Define explicit foreign-key indexes to prevent table-level locks during parent modifications.