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.

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

How would you force a log switch?

4 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---