Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how can you protect read-only indexes?

how can you protect read-only indexes?

From: Carmen Rusu <carmen.rusu_at_rrc.state.tx.us>
Date: Thu, 03 Mar 2005 10:03:01 -0600
Message-Id: <s226e0d8.073@gwgate.rrc.state.tx.us>


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 Received on Thu Mar 03 2005 - 11:15:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US