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

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

RE: how can you protect read-only indexes?

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 3 Mar 2005 11:59:35 -0500
Message-ID: <001d01c52012$60c52480$2004a8c0@development.perceptron.com>


Juan,

Please learn to read original e-mails carefully.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco
Sent: Thursday, March 03, 2005 11:49 AM
To: carmen.rusu_at_rrc.state.tx.us
Cc: oracle-l_at_freelists.org
Subject: Re: how can you protect read-only indexes?

Hi carmen, move to a tablespace, and make it read only.

On Thu, 03 Mar 2005 10:03:01 -0600, Carmen Rusu <carmen.rusu_at_rrc.state.tx.us> wrote:
> 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
>

-- 
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 12:09:11 CST

Original text of this message

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