Getting "SQL execution error, ORA-00959: tablespace 'ARGUS_DATA_XX' does not exist" When Upgrading From Safety 6.0 To 6.0.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.
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.
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