cancel
Showing results for 
Search instead for 
Did you mean: 

SP level for Oracle 12.1 Upgrade

0 Kudos

Hello,

I'm preparing the upgrade of Oracle 11.2.0.3 to 12.1 and my system is NW 7.01 SP12 (BASIS).

I would like to be sure of the SP Level requierement for Oracle Upgrade. I have read SP18 but without certainty.

Is someone could let me know how check that and how find doc/guide for procedure SP12 to SP18 ?

Thanks !

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

I found the following command but not sure it's enough ...

> SELECT table_name, compression, compress_for FROM user_tables;

> SELECT table_name, column_name, securefile, compression FROM user_lobs;

> SELECT count(*) FROM user_tables where compression='DISABLED';

> SELECT count(*) FROM user_tables where compression='ENABLED';

Answers (1)

Answers (1)

0 Kudos

OK, following the note 1914631 and 2157904, SP18 must be applied if "Advance Compression Option (ACO)" is enabled for my database.

How to check if ACO is enabled ?