Answer / guest

If we find that fragmentation of space in a tablespace is
high (contiguous space on our disk appears as
non-contiguous),we can coalesce any free space using the

ALTER TABLESPACE TABLESPACE_NAME COALESCE ; command

We must have the ALTER TABLESPACE system privilege to
coalesce tablespaces.

Regards
Abhinav Phadnis

How to make a replica of existing oracle server to another server?

3 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

What are the different sql server versions you have worked on? : sql server DBA

0 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---