Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [09-2005 Date Index] [Date Next] || [Thread Prev] [09-2005 Thread Index] [Thread Next]

Logical standby problem

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Sep 2005 14:58:42 -0400
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';




[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.