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
-----------------------------------------------------------------
Received on Fri Feb 27 2004 - 14:48:35 CST
