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.

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

2 Answers   Zenith,

---

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

0 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

how can you schedule a job in database?

0 Answers   Oracle,

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 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,

---

how can you record information about current session?

0 Answers   Oracle,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---