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';

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

Explain an ORA-01555

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

what is the use of home directory???

1 Answers   HP,

---

what is asm?

0 Answers   Oracle,

---

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 cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What is the importance of a recovery model? : sql server DBA

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---