GTT in SQL Developer Data Modeler
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Wed, 27 Feb 2013 21:36:52 +0000
Message-ID: <CAOuMUT5mPLBXJO4_NJUkw99Hf17ARfg3QXHB5ysDe0ZX+V_YYw_at_mail.gmail.com>
Hi,
SQL Developer Data Modeler doesn't seem to support global temporary tables (or Index organised tables).
Date: Wed, 27 Feb 2013 21:36:52 +0000
Message-ID: <CAOuMUT5mPLBXJO4_NJUkw99Hf17ARfg3QXHB5ysDe0ZX+V_YYw_at_mail.gmail.com>
Hi,
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 3.2.20.09 which is the latest.
Regards,
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 27 2013 - 22:36:52 CET