From oracle-l-bounce@freelists.org Wed Jan 26 16:52:06 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0QMq6tj024087 for ; Wed, 26 Jan 2005 16:52:06 -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 j0QMq5em024081 for ; Wed, 26 Jan 2005 16:52:05 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0ACDF6583D; Wed, 26 Jan 2005 16:51:18 -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 30840-08; Wed, 26 Jan 2005 16:51:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8517565C7D; Wed, 26 Jan 2005 16:51:17 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=Eq9dn7sSB7qoauSXM7z8l9q+JU0ZDwaWhgM0Ib/OiowRoOIFG1ho7NOIttxR2jPJlMmGps1C0dQ7TIrddgRqXRmYkD1ZazixPRUboFH+ijo99NzWBfjmtrIXTid6obBsMMMoi05Uds/thTIj349Xd8d3xsljHWvzc9ySuk6S4BI= Message-ID: <4b368772050126134922a7d3a6@mail.gmail.com> Date: Wed, 26 Jan 2005 16:49:36 -0500 From: Luc Demanche To: oracle-l@freelists.org Subject: Transportable tablespace Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit X-archive-position: 15291 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lucdemanche@gmail.com Precedence: normal Reply-To: lucdemanche@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Hi gurus, We are on Oracle 9.2 and I'm using the transportable tablespace to refresh my development environment. I notice that the - FUNCTIONS - PACKAGES - PROCEDURES - SEQUENCES - SYNONYMS - VIEWS are not transfered. Is that normal? What can I do? Should I use export/import with ignore=y and rows=n to complete ? Thank you Luc -- Luc Demanche Oracle DBA (514) 867-9977 -- http://www.freelists.org/webpage/oracle-l