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

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

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

3 Answers   TCS,

---

what are the differences of where and if in SAS?

0 Answers  

---

internal architecture

0 Answers   CSC,

---

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

1 Answers  

---

Describe what redo logs are.

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Which autogrowth database setting is good? : sql server DBA

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

How can you rebuild an index?

6 Answers  

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

---