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 (See ORA-00942.ora-code.com): 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';
A colleague is trying to create a logical standby database. During apply, it is getting stuck on <br> <br> LOGSTDBY stmt: grant select,insert on sys.ora_temp_1_ds_24148 to "SYSTEM "<br> LOGSTDBY status: ORA-00942 (See ORA-00942.ora-code.com): table or view does not exist<br> LOGSTDBY Apply process P004 pid=27 OS id=913594 stopped<br> <br> 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.<br> <br> Any pointers are greatly appreciated.<br> Raj <br>-- ---- ---- ---- ---- ---- --<br>select standard_disclaimer from company_requirements where category = 'MANDATORY';<br>
