Errors After Enabling Fbda ORA-1950 ORA-942 ORA-30036 (Doc ID 1330817.1)

Last updated on APRIL 25, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Created one table and gave unlimited quota on Flashback archive tablespace.
Not able to do DML operation and found below entry information FDA trace and alert log

In FDA trace
---------------
Flashback Archive: Error ORA-942 in SQL insert into ICOMPUSR08.SYS_FBA_DDL_COLMAP_132425 (ENDSCN, COLUMN_NAME, TYPE, HISTORICAL_COLUMN_NAME)values (NULL, 'PLN_PKG_VOL_TOT_QY', 'NUMBER(20,6)', 'PLN_PKG_VOL_TOT_QY')
Flashback Archive: Error ORA-942 in SQL "select count(*) from ICOMPUSR08.SYS_FBA_DDL_COLMAP_132425"
Flashback Archive: Error ORA-942 in SQL "select count(*) from ICOMPUSR08.SYS_FBA_DDL_COLMAP_132425"

Alert log
----------
Mon Jun 13 15:01:46 2011
Errors in file /SALES/u001/oracle/diag/rdbms/a559/A559/trace/A559_smon_11457.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'
Errors in file /SALES/u001/oracle/diag/rdbms/a559/A559/trace/A559_smon_11457.trc:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'
Errors in file /SALES/u001/oracle/diag/rdbms/a559/A559/trace/A559_smon_11457.trc:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'
Errors in file /SALES/u001/oracle/diag/rdbms/a559/A559/trace/A559_smon_11457.trc:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'
Errors in file /SALES/u001/oracle/diag/rdbms/a559/A559/trace/A559_smon_11457.trc:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO01'



Issue more close to Bug 9735867  but here issue came in the picture even having unlimited quota on Flashback archive tablespace.

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