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.

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

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

3 Answers   TCS,

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

---

Explain the concept of the DUAL table.

3 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

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

0 Answers   HP,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

How can we see the database version in os level

6 Answers   Oracle,

---

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

0 Answers  

---