OFSA-43003: Insufficient freespace to create table or index in tablespace Error Running Transformation ID (Doc ID 287044.1)

Last updated on AUGUST 10, 2009

Applies to:

Oracle Financial Services Applications (OFSA) - Version: 4.5
Oracle Financial Data Manager - Version: 4.5.39
This problem can occur on any platform.

Symptoms

Running a Transformation ID results in an 'Internal Error' in Server Status and the following error is received in the server ofste.XXXXX log file :

Connect to database OFSA45 was successful.
Running --- Process ID: 101201, Configuration ID: 90004
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:

OCI Function: [4] - oexec(), oexn()
SQL Function: [34] - PL/SQL EXECUTE
Oracle Error: ORA-20000: OFSA-44309: Error in block: Table Extents and Space
ORA-20000: OFSA-43003: Insufficient freespace to create table or index in tablespace: DATA_TS
ORA-06512: at "OFSAPPS.OFSA_DBA", line 5770
ORA-06512: at "OFSAPPS.OFSA_SQL", line 616
ORA-06512: at line 1

Driver Function: drv_oci::Execute()

SQL Statement: BEGIN OFSA_SQL.IA_CREATE_TABLE('OFSAPPS',101201,0,0,'LEDGER_STAT
','(((LEDGER_STAT.FINANCIAL_ELEM_ID = 100) OR (LEDGER_STAT.FINANCIAL_ELEM_ID = 4
20) OR ....


AUTOEXTENSIBLE='YES' for the datafiles which contain the DATA_TS and INDEX_TS tablespaces. Running a query on DBA_FREE_SPACE which does not take into account the "autofree" amounts returns very low space amounts.

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