Using sys.dbms_streams_adm Getting ORA-1330 (Doc ID 338983.1)

Last updated on AUGUST 23, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.6 and later   [Release: 9.2 and later ]
Information in this document applies to any platform.

Symptoms

DBMS_STREAMS_ADM.ADD_TABLE_RULES fails with an error:

ORA-1330 problem loading a required build table

BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'myuser.mytable',
streams_type => 'capture',
streams_name => 'mycapture',
queue_name => 'strmadmin.streams_queue',
include_dml => true,
include_ddl => true);
END;
/

BEGIN
*
ERROR at line 1:
ORA-01330: problem loading a required build table
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 75
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 21
ORA-06512: at line 2

On alert.log file the following error can be observed:

ORA-1653 unable to extend table SYS.LOGMNRG_COL$ by 84 in tablespace SYSTEM

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