on 07-21-2017 1:57 PM
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 !
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';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.