Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Transportable tablespaces - changing file names
-----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-----
Received on Thu Dec 02 2004 - 15:10:33 CST
![]() |
![]() |