ORA-6502 when executing DBMS_STREAMS_ADM.MAINTAIN_TABLES (Doc ID 1252345.1)

Last updated on OCTOBER 25, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.2 - Release: 10.1 to 11.2
Information in this document applies to any platform.

Symptoms

An ORA-6502 is reported when running DBMS_STREAMS_ADM.MAINTAIN_TABLES when you are generating scripts for several hundred tables.

The procedure completes successfully for the 592nd table and fails for the 593rd.

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