Logical standby problem

From: rjamya <rjamya_at_gmail.com>
Date: Thu, 1 Sep 2005 14:58:42 -0400
Message-ID: <9177895d05090111587cb37760@mail.gmail.com>

A colleague is trying to create a logical standby database. During apply, it is getting stuck on

LOGSTDBY stmt: grant select,insert on sys.ora_temp_1_ds_24148 to "SYSTEM" LOGSTDBY status: ORA-00942: table or view does not exist LOGSTDBY Apply process P004 pid=27 OS id=913594 stopped

Now we all know that this temp tablename is generated when collecting stats. System owns the package that generated the stats in the actual database. Is there a way to resolve this? I have no clue about it and Metalink has been less than helpful. A TAR has been loggged, but I needed it to be run by you all.

Any pointers are greatly appreciated.
Raj

---

select standard_disclaimer from company_requirements where category = 'MANDATORY';

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

Received on Thu Sep 01 2005 - 15:31:57 CDT