Re: Transportable tablespaces - changing file names

Chuck wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Is it possible to change datafile names when transporting tablespaces
> between two databases? If so, how? The docs don't say much at all about
> how to do this. For example I have a tablespace named TTS with one
> datafile. My datafile name on the source db might be
> /u01/sourcedb/tts01.dbf but on the target db I want it to be
> /u01/targetdb/tts01.dbf. Same tablespace name but different datafile
> name. In fact the names would have to be different if the two dbs are on
> the same server.
>
> TIA.
It's been a while since I transported a tablespace, and of course whilst I can guess you're using a Unix of some sort, I am completely in the dark regarding your version... which may or may not affect things (probably not in this specific case, but I hope you get the message for the future).

But the import parameters specified when you do a transportable tablespace are there precisely to allow you to specify an altered data file name.

Try, for example, IMP HELP=Y, and look at the DATAFILES parameter.

In fact, when transporting a tablespace (at least in 8i and 9i, which was the last time I checked), you don't need to specify the TABLESPACE parameter, because the dump file itself indicates quite obviously what tablespace is being imported. So the tablespace name doesn't need specifying, but the DATAFILES parameter always MUST be specified -and precisely because it likely won't be now where it used to be originally.

Regards
HJR Received on Thu Dec 02 2004 - 15:24:07 CST