Answer / jaleel

TO CHECK TAKINGUP SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_segments where tablespace_name='TEST';

TO CHECK FREE SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_free_space where tablespace_name='TEST';

Explain the concept of the DUAL table.

3 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

Where would you look for errors from the database engine?

0 Answers   IBM,

---

one datafile is lost in standy side how can you recover that??

2 Answers  

---

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

1 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

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

0 Answers  

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

Hot backup procedure?

2 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---