Cannot Create Table Create$Java$Lob$Table On Tablespace Installing OFSA 4.5 (Doc ID 205969.1)

Last updated on DECEMBER 24, 2012

Applies to:

Oracle Financial Data Manager - Version 4.5.20 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Oracle Financial Data Manager - Version: 4.5.2

Checked for relevance on 24-Dec-2012.

Symptoms

When running the installation for OFSA 4.5.2 and at the step for creating the table Create$Java$Lob$Table on the tablespace, an error occurs:

ERROR
Error while loading oracle/ofsa/security/Password ORA-00942: table or view does not exist

The default tablespace is autoextensible.  Rerunning the FDM_PACKAGES.SQL as the db owner does not fix the issue.

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