Re: Read Only Tablespaces: DROP TABLE Works??

From: Wolfgang Breitling <breitliw_at_netcom.ca>
Date: 1997/03/19
Message-ID: <5goks6$an8@dfw-ixnews8.ix.netcom.com>#1/1

>Dan Townsend wrote:

>> 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?
>

Tablespace recovery would not recover droppe tables even for read write tablespaces. To recover an accidentally dropped table, you would need to recover the ENTIRE database to a point before the drop. Read only vs read write doesn't make a diference there. Received on Wed Mar 19 1997 - 00:00:00 CST