we have created the temporary tablespace PSAPTEMP1 for the index creation.
CREATE TEMPORARY TABLESPACE "PSAPTEMP" TEMPFILE '/archive/temp' SIZE 51200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240K;
ALTER USER PSAPPRD TEMPORARY TABLESPACE PSAPTEMP1
but when we use the 2nd query to use for the index creation, but for the index creation it is using the old tablespace PSAPTEMP.
could any one suggest how do we make use of the newly created tablespace for the index creation.
This we are doing live PRD system with the down time.
My number: is 0 98861 45002 else you give me your number I will call you.
please do the needful.