Can any one tell me the best way to create index on very huge existing table, for example 100 GB and we have only temp tablespace 8-10 GB.
I tried with NOLOGGING option also. We can not increase the Temp tablespace size.
Any suggestion is welcome considering the corrent situation on DB.
Thanks in advance.