Re: Read Only Tablespaces: DROP TABLE Works??

Dan Townsend wrote:
>
> We have just been testing Oracle 7.3 and Read Only tablespaces. We were
> surprised to find that after making a tablespace Read Only we could
> successfully drop tables in it. Apparently Oracle drops the tables out
> of the data dictionary without touching the tablespace...?

  You can add or drop a table (defined in the data dictionary => in SYSTEM tablespace) in a read only tablespace. But you cannot rename or resize a datafile for this tablespace.

> Does anyone know what this would mean in a recovery situation? We had
> planned to put large static tables in a Read Only tablespace, back them
> up once, then ignore them. If a drop of those tables removes them from
> the data dictionary, how can a restore be done on the tablespace?

   You can backup the read-only tablespace only once. As a result, you are right. As the table definition is in data dictionary, there is no any problem in recovery. However, read-only tablespace is quite complicated which involves special treatment and the time of failure.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.