Oradba Linux <oradba_linux_at_comcast.net> wrote in
news:zwMrd.126460$V41.71826_at_attbi_s52:
> 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.
>>
>> Oracle 9.2.0.5.0
>> SunOS 5.8
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.2.5 (MingW32) - GPGshell v3.23
>>
>> iD8DBQFBr4TGzIf+rZpn0oQRAt0XAJoCvUE3h7VEk1KW8QfCj/aUFym1agCgmV3/
>> FkkKYw13CPPT1SFaD+MWlDE=
>> =1GF4
>> -----END PGP SIGNATURE-----
>
>
http://asktom.oracle.com/pls/ask/f?p=
4950:8:5744908849121846004::NO::F4
> 950_P8_DISPLAYID,F4950_P8_CRITERIA:5497671490649,
Thanks for the link. I read through it but still can't find anything on
how it knows which datafiles go with which tablespaces. In the example
there was one tablespace. In my application I'm going to need to
transport about 10 tablespaces some with multiple datafiles. How will it
know which datafiles go with which tablespaces if the names have
changed?
Received on Fri Dec 03 2004 - 10:42:50 CST
