If you perform a soft upgrade, you will not be able to perform
certain functions that are not available in older versions of .
For example, the following Version
10.2 features cannot be used in a database that has been soft upgraded from
10.0:
- SYNONYMS
- Creating tables using the GENERATED BY DEFAULT option for identity columns
- Reclaiming unused space using the SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
procedure
The following 10.2 features cannot be accessed from a database which
has been soft upgraded from 10.1:
- GRANT/REVOKE
- Online backup procedures SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT and
SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT.
- The encryption or re-encryption of a database with a new phrase/key.
Other new features in that
do not affect database structure, such as using timestamp arithmetic, are
allowed in a soft upgraded database.
To perform a soft upgrade on a
database created using an earlier version of :