Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Moving data to tablespace with new name
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_at_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-lReceived on Thu Jun 30 2005 - 10:53:48 CDT
![]() |
![]() |