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 do you understand by fine-grained auditing?

0 Answers   Oracle,

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

what is the difference between catalog & nocatalog?

3 Answers   CSC,

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

Which autogrowth database setting is good? : 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,

---

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

0 Answers  

---

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

1 Answers   Cap Gemini, iGate,

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---