Set the following logical standby parameter.
DBMS_LOGSTDBY.SKIP('NON_SCHEMA_DDL');
-- Mark Bole http://www.bincomputing.com
rjamya wrote:
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';
-- //www.freelists.org/webpage/oracle-l