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;

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

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

0 Answers   HP,

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

Describe what redo logs are.

1 Answers  

---

Can you redefine a table online?

0 Answers   Oracle,

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.

4 Answers   DELL, TCS,

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

---