Answer / guest

We can see the size of a datafile by querying given 2 views
dba_data_files and v$datafile



Regards
Abhinav Phadnis

Answer / ramesh

v$datafile and v$tablespace Views

select v.FILE#,t.NAME,v.TS#,v.BLOCKS,v.BLOCK_SIZE from
v$datafile d,v$tablespace t where v.v.TS# =t.TS#

Cheers,
Ramesh

Answer / suman

we can see the size of datafile that is we have two views
1. dba_data_files
2. v$datafile

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

internal architecture

0 Answers   CSC,

---

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

0 Answers  

---

Hot backup procedure?

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  

---

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---