Getting "SQL execution error, ORA-00959: tablespace 'ARGUS_DATA_XX' does not exist" When Upgrading From Safety 6.0 To 6.0.1 (Doc ID 1554877.1)

Last updated on JULY 23, 2013

Applies to:

Oracle Argus Safety - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

We came across an issue during upgrade scripts from 6.0 to 6.0.1 (the ones that are provided as part of the Safety 7.0.2 installation)

The creation SQL for some DLP tables, indexes, and LOB is using the ARGUS_DATA_01 tablespaces instead of the appropriate DLP tablespaces (DLP_DATA_xx, DLP_INDEX_xx, DLP_LOB_xx).
As the Argus tablespaces doesn't exist in the DLP database, the steps fail with SQL execution error, ORA-959: tablespace 'ARGUS_DATA_05' does not exist"

It seems as if the Installer or one of the SQL scripts is using wrong tablespace variables.

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