My Oracle Support Banner

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 13, 2023

Applies to:

Oracle Life Sciences 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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.