CREATE GLOBAL TEMPORARY TABLE TEMP( 
  ID  NUMBER) ON COMMIT DELETE ROWS; 

DECLARE

    i_tblsp   VARCHAR2(30); 

    l_sqlstmt VARCHAR2(32767);

    l_inxname varchar2(30);

    l_cnt     NUMBER; 

BEGIN

    --

    SELECT tablespace_name

    INTO i_tblsp

    FROM user_indexes WHERE index_name like 'PK1';

----

    begin

        select index_name into l_inxname from user_indexes 

        where index_name like 'IX_TEMP';

    exception 
	when no_data_found then

        l_sqlstmt := 'CREATE INDEX IX_TEMP ON TEMP(ID) ';

        l_sqlstmt := l_sqlstmt ||' TABLESPACE '||i_tblsp ;

        dbms_output.put_line(l_sqlstmt); 

        EXECUTE IMMEDIATE l_sqlstmt;

    end;

----

EXCEPTION

    WHEN OTHERS THEN

        DBMS_OUTPUT.PUT_LINE(SQLERRM);

END;

/

SQL> drop table faq;

Table dropped.

SQL> create global temporary table faq
  2  (id number) on commit delete rows;

Table created.

SQL> create index faq_i on faq(id);

Index created.

SQL> select tablespace_name from user_indexes where index_name = 'FAQ_I';

TABLESPACE_NAME
------------------------------


SQL> drop index faq_i;

Index dropped.

SQL> create index faq_i on faq(id) tablespace users;
create index faq_i on faq(id) tablespace users
                      *
ERROR at line 1:
ORA-14451: unsupported feature with temporary table


SQL> create index faq_i on faq(id) tablespace temp;
create index faq_i on faq(id) tablespace temp
                      *
ERROR at line 1:
ORA-14451: unsupported feature with temporary table


SQL> create index faq_i on faq(id) tablespace undo;
create index faq_i on faq(id) tablespace undo
                      *
ERROR at line 1:
ORA-14451: unsupported feature with temporary table


SQL> create index faq_i on faq(id) tablespace system;
create index faq_i on faq(id) tablespace system
                      *
ERROR at line 1:
ORA-14451: unsupported feature with temporary table