Answer / rrr2009cse@gmail.com

while moving tables to the other tablespace the indexes has been unused due to movement of segments(tables). to reuse previous index on a table has to be rebuild
alter index indxname tablespace

Answer / mohapatra.gouranga@gmail.com

> Index rebuild nothing of Drop and re-create of Index.
> Is usefull to move index from one tablespace to other.
> Do not do if not necessary.
> In case of migration, do only validate structure for the
indexex.

Why does Oracle not permit the use of PCTUSED with indexes?

1 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

what is asm?

1 Answers   Oracle,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

1 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

what is the use of ocr?

1 Answers   Oracle,

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

1 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

1 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---