From oracle-l-bounce@freelists.org Thu Sep 1 17:57:18 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j81MvI0o023342 for ; Thu, 1 Sep 2005 17:57:18 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j81MvDIP023332 for ; Thu, 1 Sep 2005 17:57:15 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 689FF1E8BE6; Thu, 1 Sep 2005 17:57:05 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07800-09; Thu, 1 Sep 2005 17:57:05 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C42031E8C7B; Thu, 1 Sep 2005 17:57:04 -0500 (EST) Message-ID: <431786D1.3040504@pacbell.net> Date: Thu, 01 Sep 2005 15:55:13 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: Oracle Discussion List Subject: Re: Logical standby problem References: <9177895d05090111587cb37760@mail.gmail.com> In-Reply-To: <9177895d05090111587cb37760@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed X-archive-position: 24938 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.1 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Set the following logical standby parameter. DBMS_LOGSTDBY.SKIP('NON_SCHEMA_DDL'); I had the exact same problem, this worked. This may have the side affect of skipping all grants whatsoever, I haven't checked. However, for non-DML changes of this nature you are probably better off bypassing the guard tempoarily and performing them directly in the logical standby, so that's not necessarily a show-stopper. -- 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'; -- http://www.freelists.org/webpage/oracle-l