Upgrade Guide › Upgrading Databases › Pre-upgrade Database Considerations › Oracle Issues

Oracle Issues

Be aware of the following issues:

Oracle 9i not supported

Important! If upgrading from version 6.0, be aware that Oracle 9i is no longer supported.

If your existing CMS has an Oracle 9i database, you must upgrade to Oracle 10g or 11g before you can upgrade your CMS.

Oracle users need extra privileges

Before upgrading your CMS, you may need to manually grant extra privileges to your Oracle primary user and, if specified, the schema owner:

If upgrading from 12.0, you must grant:

• CREATE MATERIALIZED VIEW

If upgrading from 6.0, you must grant:

• CREATE JOB
• CREATE MATERIALIZED VIEW
• EXECUTE ON DBMS_LOCK
• SELECT ANY DICTIONARY

CREATE SESSION Privilege

The CREATE SESSION privilege is granted directly to New Search User accounts created for CA DataMinder 14.1 or later. Search User accounts created for earlier versions of CA DLP were granted this privilege indirectly via the CONNECT ROLE.

For a full list of required privileges, see the Database Guide; search for ‘privileges’.