From oracle-l-bounce@freelists.org Wed Feb 2 08:33:56 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j12EXu5o025986 for ; Wed, 2 Feb 2005 08:33:56 -0600 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 j12EXuem025981 for ; Wed, 2 Feb 2005 08:33:56 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4CABD6C5B4; Wed, 2 Feb 2005 08:33:01 -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 07842-02; Wed, 2 Feb 2005 08:33:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1C346C5E2; Wed, 2 Feb 2005 08:33:00 -0500 (EST) Message-ID: From: "Mercadante, Thomas F" To: "'JaehneRS@state.gov'" , Oracle-L@freelists.org Subject: RE: Oracle 8i export to Oracle 9i import. Date: Wed, 2 Feb 2005 08:31:17 -0500 MIME-Version: 1.0 Content-type: text/plain X-OriginalArrivalTime: 02 Feb 2005 13:31:21.0326 (UTC) FILETIME=[7BAF58E0:01C5092B] Content-Transfer-Encoding: 8bit X-archive-position: 15661 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: Sean, When I want to do what you are doing, this is what I do: Create the new 9i database. Create any public database links that your application needs. Create the roles that I need. Create the users that I need - assign roles to the users as needed. Export *only* the schema's from the 8i database. I don't do a full export. I don't think it's worth it. Import into the new schema. It takes all of the silly problems you are having out of the picture. Good Luck! Tom -----Original Message----- From: Jaehne, Richard S [mailto:JaehneRS@state.gov] Sent: Tuesday, February 01, 2005 4:46 PM To: Oracle-L@freelists.org Subject: Oracle 8i export to Oracle 9i import. All, I need to migrate my production database from Oracle 8i to my new Oracle 9i database server. One problem I'm having is that the directory structure on the new server is different than the old server. So when the import tries to create the TEMP_TS or RBS DBFs we get an error that it doesn't exist. Then because it failed to build TEMP the user imports fail because it can't grab the TEMP_TS tablespace for their temporary tablespace. I could just export/import the tables piecemeal but I would rather do a full imp/exp so we can get the grants, triggers etc. Is there a workaround for this? Thanks, Sean Jaehne -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l