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

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

what are the differences of where and if in SAS?

0 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

what is ora 600?

1 Answers  

---

what is rebuild index??

2 Answers   IBM, Sapient,

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---