Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving data to tablespace with new name
Also if the tables that you are moving have LOB columns you have to precreate the table first, changing the LOB storage to the new tablespace. I ran into this a few times.
Rich
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Lex de Haan
Sent: Thursday, June 30, 2005 10:34 AM
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
Subject: RE: Moving data to tablespace with new name
if you make sure that the new (intended) destination tablespace is set as the default tablespace for the user performing the import, and if you make sure the importing user also has sufficient quota on that tablespace, import will create the tables in the new tablespace.
in general, if the create table command fails during import because the tablespace doesn't exist, the tables are crteated in the importing user's default tablespace. so you just have to make sure that there is no tablespace in the destination database with the original name. hope this helps,
kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of J. Dex
Sent: Thursday, June 30, 2005 16:17
To: oracle-l_at_freelists.org
Subject: Moving data to tablespace with new name
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?
If we initially change the tablespace names and then try and do an import, won't
the import fail?
Is there an easy way to create a new tablespace and copy everything into it and
then drop the old tablespace?
The original database is 8.1.7.4. We want to try and copy into one 8.1.7.4 database and one 9.2.0.6. They original database is on a seperate server than the two new databases (the OS's are all Solaris).
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 30 2005 - 10:48:07 CDT
![]() |
![]() |