Re: Upgrade with compressed objects

From: John Hallas <>
Date: Wed, 27 Dec 2017 13:44:26 +0000
Message-ID: <>

In a word NO.

The application may or may not continue to work but these scripts should be run with no users logged in or applications running


On 25 December 2017 at 01:35, Nitin Saxena <> wrote:

> Hello All,
> I am battling a upgrade currently. Current production is, which
> is obsolete and version number can tell that we couldn't upgrade this
> database due to no downtime provided.
> Current Challenges-
> Compressed objects are not supported with Goldengate classical extract
> which is the only extract mode compatible with 11.1 database version.
> Compressed Objects are not supported with Logical standby , so logical
> transient upgrade is also crossed from list.
> Compressed objects are not supported with Streams on 11.1.
> We have 26 such table and the biggest one is 1 TB and second biggest 500GB
> , Rest are tiny ones.
> We can't uncompress tables due to exclusive lock on tables and we don't
> have space on current box , more over it may be change sql plans on
> uncompressed .
> Finally we have proposed cold upgrade by shutting down primary for 12 odd
> minutes.
> I have one question :
> Can I run following sqls when application is UP and running fine?
> _at_?/rdbms/admin/utlu112s.sql
> _at_?/rdbms/admin/catuppst.sql
> _at_?/rdbms/admin/catbundle.sql psu apply
> Thanks
> --
> Nitin


*Technology Manager - Databases and System Management*

Wm Morrison Supermarkets PLC

Tel 0845 611 4589 (Int. 7949 4589)
Mob: 07876 790540



Wm Morrison Supermarkets Plc is registered in England with number 358949. 
The registered office of the company is situated at Gain Lane, Bradford, 
West Yorkshire BD3 7DL. This email and any attachments are intended for the 
addressee(s) only and may be confidential.

If you are not the intended recipient, please inform the sender by replying 
to the email that you have received in error and then destroy the email.
If you are not the intended recipient, you must not use, disclose, copy or 
rely on the email or its attachments in any way.

This email does not constitute a contract in writing for the purposes of 
the Law of Property (Miscellaneous Provisions) Act 1989.

Our Standard Terms and Conditions of Purchase, as may be amended from time 
to time, apply to any contract that we enter into. The current version of 
our Standard Terms and Conditions of Purchase is available at:

Although we have taken steps to ensure the email and its attachments are 
virus-free, we cannot guarantee this or accept any responsibility, and it 
is the responsibility of recipients to carry out their own virus checks.

Received on Wed Dec 27 2017 - 14:44:26 CET

Original text of this message