Re: Transportable tablespaces - changing file names

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 04 Dec 2004 01:52:57 GMT
Message-ID: <ZL8sd.45439$AL5.31723@twister.nyroc.rr.com>

"Chuck" <skilover_nospam_at_softhome.net> wrote in message news:Xns95B492C109773skiloversofthomenet_at_130.133.1.4... -snip-
> There must be something in the files themselves that links them to the
> metadata that gets exported. Especially considering that the file names
> can change when being plugged into a new database.
> --
> Chuck

A dump of file headers does reveal this ..

alter session set events 'immediate trace name FILE_HDRS level 10';

-snip-
 FILE HEADER:

        Software vsn=135290880=0x8106000, Compatibility Vsn=134217728=0x8000000
        Db ID=2120118466=0x7e5e70c2, Db Name='XXX'
        Activation ID=0=0x0
        Control Seq=254402=0x3e1c2, File size=128000=0x1f400
        File Number=13, Blksiz=8192, File Type=3 DATA

Tablespace #9 - USER_DATA rel_fn:13
-snip-

Anurag Received on Fri Dec 03 2004 - 19:52:57 CST