From oracle-l-bounce@freelists.org Thu Jul 29 11:41:29 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6TGfEW03767 for ; Thu, 29 Jul 2004 11:41:24 -0500 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 i6TGf4603747 for ; Thu, 29 Jul 2004 11:41:14 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 325DD72D3CA; Thu, 29 Jul 2004 11:19:09 -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 30349-44; Thu, 29 Jul 2004 11:19:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 71C7872D018; Thu, 29 Jul 2004 11:19:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 29 Jul 2004 11:17:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B72672CDE2 for ; Thu, 29 Jul 2004 11:17:39 -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 28954-88 for ; Thu, 29 Jul 2004 11:17:39 -0500 (EST) Received: from bionet.bio.dfo.ca (50xt.mar.dfo-mpo.gc.ca [142.176.61.190]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F012472C079 for ; Thu, 29 Jul 2004 11:17:38 -0500 (EST) Received: from MSGMARBIO01.bio.dfo.ca ([142.2.12.122]) by bionet.bio.dfo.ca (PMDF V5.2-32 #39490) with ESMTP id <0I1M00802H65NY@bionet.bio.dfo.ca> for oracle-l@freelists.org; Thu, 29 Jul 2004 13:44:29 -0300 (ADT) Received: by msgmarbio01.bio.dfo.ca with Internet Mail Service (5.5.2657.72) id ; Thu, 29 Jul 2004 13:44:51 -0300 Content-return: allowed Date: Thu, 29 Jul 2004 13:44:51 -0300 From: "Boivin, Patrice J" Subject: RE: Annoying full export full import To: "'oracle-l@freelists.org'" Message-id: <1A4AC4BAB9C50A42854582B69B08C0340426325B@MSGMARBIO05> MIME-version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 6420 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BoivinP@mar.dfo-mpo.gc.ca Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I had a "discussion" with Oracle Support on import dropping objects referring to invalid db links. During an upgrade to 8i years ago, one of the servers our db links pointed to was assigned a new IP address at the same time we were doing the upgrade. Result: Missing objects. Oracle Support informed me that this is expected behaviour, we're not supposed to have invalid db link pointers in our database... Patrice. -----Original Message----- From: Paula_Stankus@doh.state.fl.us [mailto:Paula_Stankus@doh.state.fl.us] Sent: July 29, 2004 1:24 PM To: oracle-l@freelists.org Subject: RE:Annoying full export full import Doing a full export from 8.0.6 to import of 9.2.0.4 you would think that = dependencies would be handled correctly. I found out however that views were created (not even showing up with a = definition and an invalid status) due to database links not being there. = However, the import did do database links at some point. I am running = the import a second time with rows=3Dno hoping to save myself some time. I thought all permissions are granted/handled through full = export/import. However, a number of permissions to sys. objects were = not. That must be because I ran the full export/import as system - = right? If I had run it under "sys" then that wouldn't have happened = because the permissions would be there? =20 Any suggestions for a cleaner full export/import between 8.0.6 and = 9.2.0.4? Thanks, Paula ---------------------------------------------------------------- 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 -----------------------------------------------------------------