title: Create index on Global temporary table
body: <p>Is it possible to create index on Global temporary table? If Yes, Do we need to create in a single session.</p>
  
  <p>I tried the following way and ended up with the below issue.</p>
  
  <p>Session 1:</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE "SFE_ADM"."DUMMY_GLO" 
     (    "C1" VARCHAR2(6 CHAR)
     ) ON COMMIT PRESERVE ROWS ;
  
  CREATE INDEX DUMMY_GLO_IDX ON DUMMY_GLO (C1) TABLESPACE SFE_I1;
  </code></pre>
  
  <p>Session 1:</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE "SFE_ADM"."DUMMY_GLO" 
         (    "C1" VARCHAR2(6 CHAR)
         ) ON COMMIT PRESERVE ROWS ;
  </code></pre>
  
  <p>Session 2:</p>
  
  <pre><code>CREATE INDEX DUMMY_GLO_IDX ON DUMMY_GLO (C1) TABLESPACE SFE_I1;
  </code></pre>
  
  <p>Session 1:</p>
  
  <pre><code>CREATE GLOBAL TEMPORARY TABLE "SFE_ADM"."DUMMY_GLO" 
         (    "C1" VARCHAR2(6 CHAR)
         ) ON COMMIT PRESERVE ROWS ;
  </code></pre>
  
  <p>Session 2:</p>
  
  <pre><code>TRUNCATE TABLE DUMMY_GLO
  CREATE INDEX DUMMY_GLO_IDX ON DUMMY_GLO (C1) TABLESPACE SFE_I1;
  </code></pre>
  
  <p>For all the above tries i got an error message saying.</p>
  
  <pre><code>getting an error while creating index for temporary table
  Error starting at line : 1 in command -
  CREATE INDEX DUMMY_GLO_IND ON DUMMY_GLO (C1) TABLESPACE SFE_I1
  Error at Command Line : 1 Column : 42
  Error report -
  SQL Error: ORA-14451: unsupported feature with temporary table
  14451. 00000 -  "unsupported feature with temporary table"
  *Cause:    An attempt was made to create an IOT, specify physical attributes,
             specify partition or parallel clause.
  *Action:   do not do that
  </code></pre>