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 the different components in replication and what is their use? : sql server DBA

0 Answers  

---

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

0 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

what is the role of dip user in our database?

0 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

How to start SQL Server in minimal configuration mode?

1 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

what are the differences of where and if in SAS?

0 Answers  

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---