Thanks This seems a good reason for not doing it, if the packages interact
directly in a low level with oracle processes, then this is not a good idea.
That is why I ask :)
----- Original Message -----
From: "Freeman Robert - IL" <FREEMANR_at_tusc.com>
To: <oracle-l_at_freelists.org>
Sent: Friday, February 27, 2004 5:04 PM
Subject: RE: updating singly sys packages
> Sounds reasonable based on WHAT?? This is a wrapped package, so you have
no
> idea the interactions that this package may have with other Oracle
> processes, and what processes might well intereact with this package.
Things
> might work for a week, or a month and then crater when one specific
process
> runs. This is INSANE, repeat INSANE, in my opinion. You are essentially
> making yourself an Oracle developer without the available assistance of
> oracle support should your database go belly up. Ideas are wonderful
things,
> but we must be ready to dismiss them when they are clearly wrong, as this
> one is in my humble opinion.
>
> Robert
>
> -----Original Message-----
> From: Juan Cachito Reyes Pacheco
> To: oracle-l_at_freelists.org
> Sent: 2/27/2004 2:48 PM
> Subject: Re: updating singly sys packages
>
> Thanks, migrate all the sys package is insane, but one, like utl_file,
> sounds reasonable,
> always you test it right, finally this is a package. And if this not
> works,
> you will see soonly, and you can go back easily, I'm not thinking
> seriously
> in doing this, but I'm analyzing the positiblity to try on of this days.
>
>
> ----- Original Message -----
> From: "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us>
> To: <oracle-l_at_freelists.org>
> Sent: Friday, February 27, 2004 4:42 PM
> Subject: RE: updating singly sys packages
>
>
> > Juan
> >
> > Installing 9.2.0.4 packages in a 9.2.0.1 database one package at a
> time
> > doesn't sound reasonable at all. Migrating to a new level is not just
> about
> > the internal packages. As other's have said, it is also about
> updating or
> > inserting records into the sys tables. If you install a 9.2.0.4
> package
> > without updating the supporting database tables, things could go bad
> fast.
> >
> > No. There is no reasonable reason to do this in a production
> database.
> >
> > You could certainly try anything in a test database. But even if it
> worked,
> > I would not move it forward to production.
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> > -----Original Message-----
> > From: Juan Cachito Reyes Pacheco [mailto:jreyes_at_dazasoftware.com]
> > Sent: Friday, February 27, 2004 3:32 PM
> > To: oracle-l_at_freelists.org
> > Subject: Re: updating singly sys packages
> >
> >
> > we have several customer with the same system, about 8, and about 100
> forms,
> > and a critical
> > software, for example if they don't give a daily about 8 report to the
> > government until 10:00 they can have a penalty about 50U$ for each,
> other
> > monthly, etcs.
> >
> > We can't be up to date in patches in deevloper 6i, because the amount
> of
> > customer, and you know developer 6i runtime, not web.
> >
> > We can update't easily a database, something like today we update all
> > database, we have to update late in the night usually. update all
> database
> > can take about 2 months, because some of them can reject the update.
> >
> > So, a change like updating a patch, can create serious problems, for
> example
> > to need to recompile a form connecting to that database, to get it
> work.
> > Because there are several bugs in developer 6i, once happened and we
> don't
> > want to have problems again.
> >
> > We are not going to patch 9i, because we don't have bugs create
> problems,
> > about security, there is no problem beacuse they are not connected to
> the
> > internet and has few clients, between 3 to 20.
> >
> > Then I though, if a package wrapped is a package, why not to try?
> > Obviously Tom was not going to say "do it!", but it seems to sound
> > reasonable.
> >
> > ----- Original Message -----
> > From: "DENNIS WILLIAMS" <DWILLIAMS_at_LIFETOUCH.COM>
> > To: <oracle-l_at_freelists.org>
> > Sent: Friday, February 27, 2004 3:37 PM
> > Subject: RE: updating singly sys packages
> >
> >
> > > Juan
> > > Can you elaborate on "can't run patches"? Does that mean you are
> using
> > > 9.2.0.1? I had some real bad errors until I added the 9.2.0.4 patch
> set.
> > >
> > > Dennis Williams
> > > DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > >
> > > -----Original Message-----
> > > From: oracle-l-bounce_at_freelists.org
> > > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito
> Reyes
> > > Pacheco
> > > Sent: Friday, February 27, 2004 1:31 PM
> > > To: oracle-l_at_freelists.org
> > > Subject: updating singly sys packages
> > >
> > >
> > > Hi, I asked recently to Tom if I could do an extract ddl from
> utl_file
> > from
> > > 9.2.4 and run in 9.2,
> > > Because I can't run patches.
> > >
> > > Tom obviously said NO.
> > >
> > > But what can go wrong, except something not working.
> > >
> > > Some experience?
> > >
> > >
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> > >
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 27 2004 - 15:04:31 CST
