Transportable tablespace confirm Q

[nirasha]

I just wanted to confirm a question on transportable tablespaces. I have been using the document in this site to plan this.

I noticed when you export you specify the tablespace but not datafiles and when you import you specify the tablespaces and datafiles.

My scenario is somthing like this:

txndata (tablespace name)
/u04/destiny/txndata_01.dbf
/u05/destiny/txndata_02.dbf

indx
/u06/destiny/indx_01.dbf

In the target system I want them placed like this:
txndata (tablespace name)
/u01/tiger/txndata_01.dbf
/u02/tiger/txndata_02.dbf

indx
/u03/tiger/indx_01.dbf

exp tablespaces=txndata, indx

imp datafiles = '/u01/tiger/txndata_01.dbf', '/u02/tiger/txndata_02.dbf', '/u03/tiger/indx_01.dbf'
tablespaces = txndata,indx

Is this correct??? Des imp know which datafiles go to which tablespace, and also does it recognise the new name /location??

Thanks,
Nirasha

[nirasha]

Also at which stage do I perform the os copy?

Thanks,
Nirasha

[Pinakin]

As per my knowledge exporting/importing datafiles is not permitted.
Kindly describe the purpose of transporting your tablespaces. Do you want to move your data (may be from one database to another) or just want to move the data files from one physical location to another ... ????
If you want to move your datafiles from one phy location to another then you can use

ALTER TABELSPACE txndata RENAME DATAFILE /u04/destiny/txndata_01.dbf TO /u01/tiger/txndata_01.dbf ;

/* Checkout the exact Syntax */

If your want to move your data from one DB to another then exporting TS is the best option.

Good Luck.

Pinakin.

[nirasha]

I am exporting tablespaces. I am taking the tablespaces to the QA from Production system. My question here was referring as to how the import treats the listing of the datafiles, when the place you will be copying them to in the target server will be different.

Thanks,
Nirasha

[nirasha]

Please help someone!!!

[nirasha]

Got it.. it worked. Just look out for Note:113881.1. It helped alot.

Transportable tablespaces are a dream.

Thanks,
Nirasha

[nirasha]

Just a warning that packages etc don't come through in tablespace exports.

Nirasha