Re: RMAN - ORA-30928 and ORA-1652

On Tue, Aug 12, 2008 at 2:52 PM, Jared Still <jkstill_at_gmail.com> 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

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