GTT in SQL Developer Data Modeler

From: Fergal Taheny <>
Date: Wed, 27 Feb 2013 21:36:52 +0000
Message-ID: <>

SQL Developer Data Modeler doesn't seem to support global temporary tables (or Index organised tables).

On Table Properties -> General there is a Classification Type which you can set to Temporary but that just seems to be informational as the DDL still creates a normal table.

The only workaround I can find is to define an after create script which does something like this:

create global temporary table X_T as select * from X; drop table X;
alter table X_T rename to X;

Am I missing something?

Version is which is the latest.


Received on Wed Feb 27 2013 - 22:36:52 CET

Original text of this message