dear all

I done rebuild an index using the command
ALTER INDEX tabs.STOCK_HIST_IDX2 REBUILD TABLESPACE idx_temp;

so what is the next step

to get back the index to the old tablespace

the index moved to another tablespace and i want to bring it back so i can drop the tablespace i created to do the rebuild

thanking you..

السلام عليكم ،

You can create a new index , and drop the other one that you have created unless u need the same index name then u drop first the index and then create the new one, you can use:

CREATE INDEX index name ON table name
(Field name)
LOGGING
TABLESPACE name
PCTFREE 10
INITRANS 11
MAXTRANS 255
STORAGE (
INITIAL 1M
NEXT 3M
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 4
FREELIST GROUPS 4
BUFFER_POOL DEFAULT
)
NOPARALLEL;


I hope this syntax will help out.

Thanks