Answer / ram

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

in DMT data dictionary tables stores the information of free and used extents, for used extents information in dmt tablespace uses sys.uet$ view and free extents information in DMT tablespace stored in sys.fet$

in LMT tablespace, tablespace datafiles maintains own bitmaps @ datafile headers these store the used extents and free extents information.

LMT is preferable, because it won't generate any rollbacks,
dictionary contention is reduced, space wastage removed & fragmentation removed

Answer / kittu

tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed

In dictionary managed tablespace oracle will take care of tablespace

In locally managed tablespace we need to take care of tablespace

one datafile is lost in standy side how can you recover that??

2 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

Oracle 11g new features?

2 Answers  

---

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,

---

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

2 Answers   Satyam,

---

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

what is ora 600?

1 Answers  

---

What is dbcc? : sql server DBA

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

What type of index should you use on a fact table?

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---