How to Rebuild Index in Oracle Database Tutorial Example
Run Query Editor then copy & paste the below rebuild index on a tablespace in Oracle Database Server Tutorial Example
-- CONNECT AS Any User or HR -- Syntax : ALTER INDEX index_name REBUILD TABLESPACE tablespace_name LOGGING/NOLOGGING ALTER INDEX IDX_EMPLOYEE REBUILD TABLESPACE USERS NOLOGGING;
-- is comment in Oracle
-- in fact it is comment in MSSQL and MySQL as well

No comments:
Post a Comment
leave your comments here..