Re: RMAN - ORA-30928 and ORA-1652

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 Aug 2008 15:03:30 -0700

On Tue, Aug 12, 2008 at 2:52 PM, Jared Still <jkstill@xxxxxxxxx> wrote:

>
> I have opened an SR on this, and googled as well, so far to no avail.
>
>
I spoke too soon.

Just after hitting <SEND> 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

Other related posts: