Toad World® Forums

Extract ddl on global temporary table is not correct


#1
  1. Create a global temporary table.

  2. use sql nav to extract the ddl from the global temp table that was created. The ddl extracted is not correct.

CREATE GLOBAL TEMPORARY TABLE t54db16.temp_henry_test_temp
(
num1 NUMBER,
num2 NUMBER,
num3 NUMBER)

ON COMMIT PRESERVE ROWS
SEGMENT CREATION IMMEDIATE
NOPARALLEL
/

**** SCRIPT STARTED Session: T54DB16@SSDEV.WORLD(1) 11-May-2015 10:24:21 ****
CREATE GLOBAL TEMPORARY TABLE t54db16.temp_henry_test_temp
(
num1 NUMBER,
num2 NUMBER,
num3 NUMBER)
ON COMMIT PRESERVE ROWS
SEGMENT CREATION IMMEDIATE
NOPARALLEL
==>
line 1: ORA-14451: unsupported feature with temporary table

**** SCRIPT ENDED 11-May-2015 10:24:21 ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I am pretty sure a temp table should not have on commit preserve rows or segment creation immediate.


#2

Hi,

Thanks for your report.

I think that temp table should have on commit preserve rows, but not segment creation immediate.

we have create defect SQLNAV-1883 for segment creation issue. we will try to fix it soon.

Thanks,

Michael