OFSA-43003: Insufficient freespace to create table or index in tablespace Error Running Transformation ID
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.
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:  - oexec(), oexn()
SQL Function:  - 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.
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