My Oracle Support Banner

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

Last updated on NOVEMBER 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.