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;

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

How would you determine who has added a row to a table?

4 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

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

1 Answers   Oracle,

---

What does coalescing a tablespace do?

1 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---