My Oracle Support Banner

12.1 New Feature: Valid Time Temporal (Doc ID 1524779.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Purpose

 The document describes and provides some simple examples the Temporal Validity feature that was introduced in 12.1 for tables.

Scope

 Valid-time dimension is a synonym of Valid-time column in this article.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Brief description of the feature
 How to introduce temporal validity on a table
 How to use Temporal Validity
 Ordinary query and DML
 Flashback queries
 AS OF PERIOD FOR <valid_time_column> <timestamp>
 VERSIONS PERIOD FOR <valid_time_column> BETWEEN <timestamp> | MINVALUE AND <timestamp> | MAXVALUE
 DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME procedure
 Limitations and Restrictions for table support of Temporal Validity

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.