RE: Package becomes INVALID when a partiiton is dropped

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 28 Jun 2005 19:30:49 +0200
Message-Id: <20050628172112.4CBD93E23@node42.naturaljoin.lan>

Hi Jared, you are right -- that is, not in 10gR1. as far as I know, job chains (and some other scheduler stuff) is on the schedule for 10gR2.

kind regards,

Lex.

---

Steve Adams Seminar <http://www.naturaljoin.nl/events/seminars.html> http://www.naturaljoin.nl/events/seminars.html

---

 

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Tuesday, June 28, 2005 19:23
To: sharmakdeep_oracle_at_yahoo.com
Cc: Eric List; oracle-l_at_freelists.org
Subject: Re: Package becomes INVALID when a partiiton is dropped

It appears that what you really need is a job scheduler, one with dependencies built in.

I'm sure someone will suggest 10g DBMS_SCHEDULER, but from my limited perusal of the docs, it does not appear to be up to that kind of task.

Jared

On 6/28/05, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:

We are on 9.2.0.6 .

As you said, the package is actively being used when the DDL happens.

Right now I am manually co-ordinating with the application group so that I drop the partition(s) when the application is not running. After dropping I inform the group to run their application. This is a pain, as the table has about 180 daily partitions, and I need to do this every day.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jun 28 2005 - 13:37:19 CDT