My Oracle Support Banner

Redo generation for Indexes on Global Temporary Tables (GTT) (Doc ID 848852.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

***Checked for relevance on 13-Sep-2016***



Symptoms

SQL> create global temporary table test1
2 (
3 OWNER VARCHAR2(30),
 GRANTEE VARCHAR2(30)
  )
  on commit preserve rows;

Table created.

SQL> create index test_IND01 on test1 (GRANTEE);

Index created.

SQL> select logging from dba_indexes where index_name like 'TEST_IND01';

LOG
---
YES <<----------------

SQL> select logging from dba_tables where table_name like 'TEST1';

LOG
---
NO <<--------------------
ORA-14451: unsupported feature with temporary table

Cause

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
Symptoms
Cause
Solution
References


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