how can you protect read-only indexes?

From: "Carmen Rusu" <carmen.rusu@xxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 03 Mar 2005 10:03:01 -0600

Oracle EE 9.2.0.4 64 bit
SunOS 5.8 64bit
data warehouse db ~100gb right now, growing every month
no partitioning yet

Just verified that you can drop an index when its underlying tablespace
is in read-only mode.

It happened when an ETL job ran second time, by mistake. The
corresponding tables, also on read-only tablespaces, survived ok the
truncate op.

So, what can I do to foolproof my ETL, so that the indexes  are not
dropped by mistake next time? 

Thanks,
-Carmen Rusu
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: how can you protect read-only indexes?
From: Juan Carlos Reyes Pacheco

how can you protect read-only indexes?

Other related posts: