FAQ

On Tue, Aug 12, 2008 at 2:52 PM, Jared Still wrote:
I have opened an SR on this, and googled as well, so far to no avail.
I spoke too soon.

Just after hitting I saw that Oracle had replied.

It's a bug in 10g, the fix is to be in 11g

Here's the fix:

*Workaround

Delete the statistics for the fixed table X$KCCRSR on target database :

SQL> connect / as sysdba;
SQL> execute dbms_stats.delete_table_stats(ownname=>'SYS',
tabname=>'X$KCCRSR');
*

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 12, '08 at 9:52p
activeAug 12, '08 at 10:03p
posts2
users1
websiteoracle.com

1 user in discussion

Jared Still: 2 posts

People

Translate

site design / logo © 2022 Grokbase