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

Hot backup procedure?

2 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

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  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

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

0 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---