Answer / guest

It is dba_free_space which gives u the info about free
space in any tablespace

Regards
Abhinav

Answer / shruthi

It is sm$ts_free.......

Answer / rajesh naidu

SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

AND THE VIEW IS DESC DBA_FREE_SPACE;

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

---

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

3 Answers   TCS,

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

i had backup last manday.now i need back monday to now ..how do get backup?

3 Answers   Infozech, Wipro,

---

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

1 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

how can you enable flashback feature?

0 Answers   Oracle,

---

How can you rebuild an index?

6 Answers  

---