Re: Nested table TYPE, global temp table , and rollback segment

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9qppoq01p4j_at_drn.newsguy.com>...
> In article <ff68d4e6.0110190216.65684f56_at_posting.google.com>,
> jlale.cs_at_clearstream.com says...
> >
> >Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
> >news:<9qmkgb0ac6_at_drn.newsguy.com>...
> >> In article <ff68d4e6.0110180157.3b6bff45_at_posting.google.com>,
> >> jlale.cs_at_clearstream.com says...
> >> >
> >> >Hi,
> >> >
> [snip]
>
> [snip]

Hi again,

thanks for the pointers Tom. DBA has changed the RBS allocation following your advice. He's also increased the PCTVERSION for the LOB datatype columns from 10 to 40 - the temp_table and the collection have clob columns, and the dbms_lob package is used in the collection access function to select a substr from clob. There was an error message in the trace file to point to this as the root of the problem. My function didn't catch this error message (just reported the 1555) which is why I couldn't include for information. All's working fine again now.

James Received on Thu Oct 25 2001 - 12:05:07 CDT