Errors Encountered During The Database Upgrade From Insight 5.1 To 6.0 (Doc ID 1352774.1)

Last updated on AUGUST 26, 2011

Applies to:

Oracle Argus Insight - Version: 5.1 to 6.0 - Release: 5.1 to 6.0
Information in this document applies to any platform.

Symptoms


The following errors observed when upgrading Insight Database from 5.1 to 6.0:

1. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\SQL\ai_mart{grant}.sql


GRANT SELECT ON APR_MART.RPT_CASE to APR_MART;
SQL execution error, ORA-01749: you may not GRANT/REVOKE privileges to/from yourself


2. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\SQL\ai_mart_read_only{views}.sql


CREATE OR REPLACE VIEW APR_MART.v_rpt_case_clob AS SELECT * FROM APR_MART.v_rpt_case_clob;
SQL execution error, ORA-01731: circular view definition encountered

3. Opening File E:\Program Files\Oracle\ArgusInsight\Database\Upgrades\51_TO_60\SQL\ai_mart_read_only{synonym}.sql


CREATE OR REPLACE SYNONYM APR_MART.rpt_case FOR APR_MART.v_rpt_case_clob;
SQL execution error, ORA-00955: name is already used by an existing object


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms