Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Transportable tablespaces - changing file names

Transportable tablespaces - changing file names

From: Chuck <skilover_nospam_at_softhome.net>
Date: 2 Dec 2004 21:10:33 GMT
Message-ID: <Xns95B3A48CEC03Eskiloversofthomenet@130.133.1.4>


-----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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US