From oracle-l-bounce@freelists.org Mon Feb 23 11:57:18 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1NHvIr27395 for ; Mon, 23 Feb 2004 11:57:18 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1NHvHo27388 for ; Mon, 23 Feb 2004 11:57:17 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B965D394E21; Mon, 23 Feb 2004 12:59:03 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 23 Feb 2004 12:58:02 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id CD1F5394912 for ; Mon, 23 Feb 2004 12:57:59 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 23 Feb 2004 17:58:58 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00015@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: EXP-00091 when full database export (9.2.0.4) ??? Date: Mon, 23 Feb 2004 11:58:34 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 1615 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Mary Will statistics=safe get rid of his export error? From your posting, it looks like an import parameter. Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: Mary Bahrami [mailto:mbahrami@seattletimes.com] Sent: Monday, February 23, 2004 11:36 AM To: oracle-l@freelists.org Subject: RE: EXP-00091 when full database export (9.2.0.4) ??? Actually, you'd want to use "statistics=3Dsafe" from metalink: What is the new value SAFE of the STATISTICS parameter at IMPORT ? The = 4 possible values for this parameter are : -> ALWAYS : = Always imports database optimizer statistics regardless of wether or not = they are questionable. =20 -> NONE : Does not import or recalculate the database optimizer = statistics. =20 -> SAFE : Imports database optimizer statistics back only if they = are not questionable. If they are questionable, recalculates the = optimizer statistics. =20 -> RECALCULATE : Does not import the database optimizer statistics. = Instead, recalculates them on import. =20 Never heard of expdp or impdp; they're not in the $ORACLE_HOME/bin = directory. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Pete Sharman Sent: Monday, February 23, 2004 9:29 AM To: oracle-l@freelists.org Subject: RE: EXP-00091 when full database export (9.2.0.4) ??? On 9i? Do you know something the rest of use don't? :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, February 24, 2004 4:06 AM To: oracle-l@freelists.org Subject: Re: EXP-00091 when full database export (9.2.0.4) ??? Export with "STATISTICS=3DNONE". You should also use expdp and impdp instead of exp/imp. On 02/23/2004 11:38:58 AM, dba1 mcc wrote: > We have ORACLE database run under SUN solaris 9 and > ORACLE 9.2.0.4. While wd doing "FULL" database > export, we got lots of error like: >=20 >=20 > . . exporting table AQ$_INTERNET_AGENTS =20 > 0 rows exported > . . exporting table AQ$_INTERNET_AGENT_PRIVS =20 > 0 rows exported > EXP-00091: Exporting questionable statistics. > . . exporting table DEF$_AQCALL =20 > 0 rows exported > EXP-00091: Exporting questionable statistics. > . . exporting table DEF$_AQERROR =20 > 0 rows exported > . . exporting table DEF$_CALLDEST =20 > 0 rows exported > EXP-00091: Exporting questionable statistics. >=20 >=20 > Can anyone tell me how to fix it? >=20 > Thanks. >=20 > __________________________________ > Do you Yahoo!? > Yahoo! Mail SpamGuard - Read only the mail you want. > http://antispam.yahoo.com/tools > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- >=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------