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.

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

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

0 Answers   HP,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

what is asm?

0 Answers   Oracle,

---

---

how can you initialize log miner?

0 Answers   Oracle,

---

Give two examples of referential integrity constraints.

2 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---