I was able to create it, I was putting the table space on my statement
like this :
CREATE INDEX EPALMS_OWNER.IDX_CONCEPT_TEMP_01
ON EPALMS_OWNER.CONCEPT_TEMP(ATTRIBUTEVALUE_ID)
TABLESPACE INDX

If I don't specify the table space the index gets created
Thanks
-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x87782540.[Email address protected]
Sent: Tuesday, August 07, 2007 2:53 PM
To: LazyDBA Discussion
Subject: RE: GLABAL TABLES WITH INDEXES

Can you post the command(s) that you're using? Perhaps there's a syntax
issue. On a 9.2.0.8 dev database I just did the following successfully:

create global temporary table chad_test
(
col1 number(9),
col2 varchar(30),
col3 date);

Table created.

create index chad_test_col1_idx on chad_test(col1);

Index created.



-----Original Message-----
From: Polo Victor
[mailto:oracledba-ezmlmshield-x88689867.[Email address protected]
Sent: Tuesday, August 07, 2007 11:32 AM
To: LazyDBA Discussion
Subject: GLABAL TABLES WITH INDEXES



Hello Gurus,



I m trying to create an Index on a temporary table but I cant, I'm
getting the following error:

ORA-14451 unsupported feature with temporary table

But I read on the oracle documentation that indexes can be made on temp
tables

Any body has any idea why is this happening?



I'm working with 9.2.5 version on windows

Thanks for you help

<http://www.design2launch.com/>

Victor Polo

Databases Administrator

One Dock Street, Suite 500

Stamford, CT 06902

Phone: 203-348-1173 ext. 117

Fax: 203-348-0213

Design2Launch, Inc. <http://www.design2launch.com/>









---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





Oracle LazyDBA home page