Correct, you cannot specify a tablespace for an index on a global
temporary table. Just like you cannot specify a tablespace for the
global temporary table itself, the "temp" tablespace is used for these
objects, if they need space on disk. Usually, they just occupy space in
RAM.

-----Original Message-----
From: Polo Victor
[mailto:oracledba-ezmlmshield-x53944413.[Email address protected]
Sent: Tuesday, August 07, 2007 3:04 PM
To: LazyDBA Discussion
Subject: Spam: RE: GLABAL TABLES WITH INDEXES

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






---------------------------------------------------------------------
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



THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page