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 -> Re: Transportable tablespaces - changing file names

Re: Transportable tablespaces - changing file names

From: Oradba Linux <oradba_linux_at_comcast.net>
Date: Thu, 02 Dec 2004 22:18:07 GMT
Message-ID: <zwMrd.126460$V41.71826@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::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5497671490649, Received on Thu Dec 02 2004 - 16:18:07 CST

Original text of this message

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