Renaming Tablespace Using Transportable Tablespace Feature
666678Sep 8 2009 — edited Sep 9 2009I have a 10g database that has some tables with CLOB datatype. I want to bring that data into our 10g Data Warehouse.
Both systems are running on Linux and it looks like transportable tablespaces is the way to go.
I've looked the docs on how to do this and it doesn't look too difficult
However the tablespace name I want to export already exists in my Data Warehouse so how do I work around it?
I see mention of "rename either the tablespace to be transported or the destination tablespace before the transport operation."
So do I run some ALTER TABLESPACE tbs1 RENAME TO tbs2 before my exp command and that will cover it?
What about the associated datafile or does it not come into play.
TIA