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;

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   STC,

---

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

2 Answers   Satyam,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

---

what is asm?

0 Answers   Oracle,

---

Describe what redo logs are.

1 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

How do you add a data file to a tablespace?

3 Answers  

---

Datapump backup steps?

1 Answers  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---