Index Re-building..


ALTER INDEX <IDX_NAME> REBUILD ONLINE;

If your issue is its huge table and it might take more time to execute then you can use Parallel execution method.

1. Take your session in Parallel DML mode.

ALTER SESSION ENABLE PARALLEL DML;

2. Take your table in Parallel Mode

ALTER TABLE <TABLE_NAME> PARALLEL;

3. Run Rebuild Index command.


ALTER INDEX <IDX_NAME> REBUILD ONLINE;

4.  Take your session back to normal mode.

ALTER SESSION DISABLE PARALLEL DML;

That is it !!!

Comments

Post a Comment

Popular posts from this blog

Space_Count **   select user_bytes/1024/1024 from dba_data_files         where tablespace_name='<tbs_name>'; ** select sum(user_bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';            This will give us the space used in a particular datafile..... Tablespace_Size ** select bytes/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>'; ** select sum(bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';             This command will give the tablespace size what size is the tablespace created of..
Read more
Renaming Database Well Rename your database in a very easy way..without affecting the DBID or to the SID... Step 1 :  Backup Controlfile to text Step 2:  Create  a pfile of your database Step 3:  Edit your controlfile with database name...keeping only resetlogs Step 4:  Edit pfile with dbname and controlfile parameter.. Step 5:  Startup with nomount option with the updated pfile.. Step 6:  Create a new controlfile Step 7:  Update the new controlfile in pfile and Startup with that pfile Step 8:  Create a new Spfile from the updated Pfile....               Thats it Database is renamed.......... Sql > alter database backup controlfile to trace as '/home/oracle/control.txt [ oracle@localhost :~ ]  vi control.txt CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Read more