Re: Transportable tablespaces - changing file names

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Howard J. Rogers wrote:
> Chuck wrote:
>> 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
The imp help=y doesn't help much either. It doesn't give any more info than the 9i manual did. All it says is "DATAFILES datafiles to be transported into database".

How does the import utility know which datafiles in the DATAFILES= parameter to associate with which tablespaces in the export file?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32) - GPGshell v3.23

iD8DBQFBr4l7zIf+rZpn0oQRArN2AJ9jCEuPMGHQ2Jq1g28WNvwvGt1EbACfRjq8 xM1QMcbqntUvCfCLvEqlLWI=
=XFUv
-----END PGP SIGNATURE----- Received on Thu Dec 02 2004 - 15:30:42 CST