Re: Moving data to tablespace with new name

From: zhu chao <zhuchao@xxxxxxxxx>
To: cemail_219@xxxxxxxxxxx
Date: Thu, 30 Jun 2005 22:47:38 +0800

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@xxxxxxxxxxx> 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

Follow-Ups:

Re: Moving data to tablespace with new name
From: Yechiel Adar

References:
- Moving data to tablespace with new name
  - From: J. Dex

Re: Moving data to tablespace with new name

Other related posts: