| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving data to tablespace with new name
Mr. Dex,
Create the objects in the new tablespace in the 9206 database. Perform your import using the "ignore=Y" option and your data will be imported just fine.
Tom
-----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 10:17 AM
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:28:32 CDT
 |
 |