From oracle-l-bounce@freelists.org Thu Jun 30 12:22:20 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j5UHMJr8000963 for ; Thu, 30 Jun 2005 12:22:19 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180] (may be forged)) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j5UHJmIP032476 for ; Thu, 30 Jun 2005 12:19:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 854951C7160; Thu, 30 Jun 2005 11:13:15 -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 32271-06; Thu, 30 Jun 2005 11:13:15 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 089BB1C6F99; Thu, 30 Jun 2005 11:13:14 -0500 (EST) Message-ID: <42C42816.908@inter.net.il> Date: Thu, 30 Jun 2005 19:12:54 +0200 From: Yechiel Adar User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: oracle-l@freelists.org Subject: Re: Moving data to tablespace with new name References: <962cf44b050630074768c09659@mail.gmail.com> In-Reply-To: <962cf44b050630074768c09659@mail.gmail.com> Content-Type: multipart/alternative; boundary="------------010809050407070900000200" X-archive-position: 21905 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: adar76@inter.net.il Precedence: normal Reply-To: adar76@inter.net.il X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-1.6 required=5.0 tests=AWL,BAYES_00, FROM_ENDS_IN_NUMS,HTML_MESSAGE autolearn=no version=2.63 --------------010809050407070900000200 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit You forgot to mention that transportable tablespace require two things: 1) The tablespaces needs to be a self sustaining set. 2) They need to be in read only when you copy them. Dex did not mention that his data copy can accommodate these requirements. Adar Yechiel Rechovot, Israel zhu chao wrote: >The easiest way would use transportable tableespace. You export your >tablespace with transportable tablespace, edit the dumpfile header, >change tablespace name , and import it into new database. > >THis takes least down time > > >On 6/30/05, J. Dex wrote: > > >>We want to move application data from one database to another. However, in >>the new database we want to change the tablespace names so that they follow >>a new naming convention. What is the easiest/most efficient way of doing >>this? >> >> >> > -- >Regards >Zhu Chao >www.cnoug.org >-- >http://www.freelists.org/webpage/oracle-l > > > --------------010809050407070900000200 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit You forgot to mention that transportable tablespace require two things:
1) The tablespaces needs to be a self sustaining set.
2) They need to be in read only when you copy them.

Dex did not mention that his data copy can accommodate these requirements.
Adar Yechiel
Rechovot, Israel


zhu chao wrote: 
The easiest way would use transportable tableespace. You export your
tablespace with transportable tablespace, edit the dumpfile header,
change tablespace name , and import it into new database.

THis takes least down time


On 6/30/05, J. Dex <cemail_219@hotmail.com> wrote:
  
We want to move application data from one database to another.  However, in
the new database we want to change the tablespace names so that they follow
a new naming convention.   What is the easiest/most efficient way of doing
this?

    
 -- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
--------------010809050407070900000200-- -- http://www.freelists.org/webpage/oracle-l