My Oracle Support Banner

Object Registration is Failing With ORA-00959: tablespace '<ATOMIC TABLESPACE>' does not exist Errors (Doc ID 2643210.1)

Last updated on AUGUST 01, 2023

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Model Upload
Data Model
Table Space

Goal

The RegisterObjects.sh in the development environment is failing with the following error:
java.lang.Exception: Error while executing the query Failed Executing Batch: error occurred during batching: ORA-00959: tablespace '<ATOMIC TABLESPACE>' does not exist.

Last year the OFSAA database was converted to Automatic Storage Management (Oracle ASM) with compression. The DBA renamed the existing atomic tablespace. A new tablespace was created for compression. The old atomic tablespace was dropped and the new compressed tablespace was renamed. No tables should be in the old atomic tablespace.

Which table or file does the RegisterObjects process for tablespace?

Solution

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
Goal
Solution


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