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 -- //www.freelists.org/webpage/oracle-l