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

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

0 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

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

1 Answers   Tech Mahindra,

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---