Hi,
DB: 12.2
I am no able to create an index on a GTT, could you please provide some advise ?
1 - I am creating the GTT with CTAS:
CREATE GLOBAL TEMPORARY TABLE PL_TMP_RESULT_SET_01_X
ON COMMIT PRESERVE ROWS TABLESPACE TBS_TMP_16KB
AS SELECT .....
2 - I have tried both statements below but they are ginving an error (ORA-14450: attempt to access a transactional temp table already in use)
alter table PL_TMP_RESULT_SET_01_X add constraint pk_RESULT_SET_01_HIGHEVEN primary key(HIGHEVEN);
CREATE INDEX IDX$$_RESULT_SET_01_HIGHEVEN ON PL_TMP_RESULT_SET_01_X("HIGHEVEN") ONLINE;
How do you create an index on GTT created from CTAS ?