Can TIMESTAMP Data Type Be Used as an Interval Partitioning Key in Oracle 11g ? [ID 1433273.1]

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.
Oracle 11.2 database

Goal

Can TIMESTAMP be used as a Interval partitioning key in Oracle 11.2 ?

Solution

Yes,  TIMESTAMP can be used as a Interval partitioning key in Oracle 11.2,  as can DATE and NUMBER.

11.1 and 11.2 documentation at the INTERVAL Clause of the CREATE TABLE statement in the SQL Language Reference does not state like so, hence a documentation bug was filed that now supports use of TIMESTAMP.   

The use of  TIMESTAMP WITH TIME ZONE or  TIMESTAMP WITH LOCAL TIME ZONE data types are not supported.