From oracle-l-bounce@freelists.org Fri Jul 30 03:06:22 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6U85vQ03192 for ; Fri, 30 Jul 2004 03:06:07 -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 i6U85l603146 for ; Fri, 30 Jul 2004 03:05:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1AA0172CBA4; Fri, 30 Jul 2004 02:43:45 -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 17895-52; Fri, 30 Jul 2004 02:43:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 64CCB72C8B9; Fri, 30 Jul 2004 02:43:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 30 Jul 2004 02:42:11 -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 764FA72CC0E; Fri, 30 Jul 2004 02:42:10 -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 17940-11; Fri, 30 Jul 2004 02:42:10 -0500 (EST) Received: from amis-colo-mail2.vanco.nl (amis-colo-mail2.vanco.nl [194.7.240.242]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5AC5172CBF9; Fri, 30 Jul 2004 02:42:09 -0500 (EST) Received: from amis-colo-mail2.vanco.nl (localhost [127.0.0.1]) by amis-colo-mail2.vanco.nl (8.11.7+Sun/8.11.6) with ESMTP id i6U89Vk10437; Fri, 30 Jul 2004 10:09:32 +0200 (MEST) Received: from miov11 (miov11.eu.amis.com [138.203.104.77]) by amis-colo-mail2.vanco.nl (8.11.7+Sun/8.11.6) with ESMTP id i6U89VF10433; Fri, 30 Jul 2004 10:09:31 +0200 (MEST) Received: from noteseu01.eu.amis.com ([138.203.105.217]) by mail.eu.amis.com (PMDF V5.2-32 #40601) with ESMTP id <01LD2HF8B2TMCVAGHA@mail.eu.amis.com>; Fri, 30 Jul 2004 10:09:31 +0100 (MET) Date: Fri, 30 Jul 2004 10:09:30 +0200 From: jo_holvoet@amis.com Subject: RE:Annoying full export full import To: oracle-l@freelists.org Cc: oracle-l@freelists.org, oracle-l-bounce@freelists.org Message-id: MIME-version: 1.0 X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Content-type: text/plain; charset=us-ascii X-MIMETrack: Serialize by Router on NotesEU01/SRV/AMIEU(Release 5.0.12 |February 13, 2003) at 30/07/2004 10:09:30, Serialize complete at 30/07/2004 10:09:30 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 6500 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jo_holvoet@amis.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Isn't it due to the underlying tnsnames file being incomplete and not due to the db links themselves not being there ? Ran into the exact same thing myself recently during an exp/imp upgrade from 8.0.5 (!) to 9.2.0.4 (management wanted to use the exp/imp route to have a fallback scenario, i.e. revert back to the 8.0.5 in case of disasters). mvg/regards Jo Paula_Stankus@doh.state.fl.us Sent by: oracle-l-bounce@freelists.org 07/29/2004 18:23 Please respond to oracle-l To: oracle-l@freelists.org cc: 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 -----------------------------------------------------------------