Answer Posted / 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

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

1317

---

What is fill factor? : sql server DBA

1255

---

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

1077

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2446

---

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

2479

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1031

---

You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1985

---

how can you connect from 10g user to 11g user??

2117

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1012

---

Query processing is slow(eg select query)how will u solve that

7924

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

4431

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2207

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2519

---

how can you process messages in order asynchronously?

981

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2642

---