Logical standby problem
Logical standby problem -- rjamya 2005-09-01
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.
select standard_disclaimer from company_requirements where category = 'MANDATORY';