tablespace files moving from one db to another

[MSaeed]

Given the datafiles belonging to a tablespace, how can I move them to another d/b and assign them to a tablespace with the same name without loosing the contents of the file.

Is there a way to attach a tablespace to a file without loosing it's contents ?

Thanks for all your help.

MS

[jodie]

Check out Transportable tablespaces. There's a good article on how to do this on this site:

http://www.dbasupport.com/oracle/ora8/page9.shtml

One note... the article says to set the tablespace to read-write and then copy the datafile. You MUST copy the datafile BEFORE you set the tablespace back to read-write.

Good Luck!
Jodie

[MSaeed]

Jodie:

Thanks for your response. That article is good. However due to the restrictions/pre-requisites it is not an option.

Any other solutions ?

thanks for your help and insight.

MS

[jodie]

I'm not aware of any other way to move a datafile to another db and assign it to a Tablespace.

Maybe someone else does....

Sorry!
Jodie

[pando]

you cannot attach files to tablespaces, you move tablespaces not files, even with transporatblespace tablespaces

[SANJAY_G]

Pando,
I think you meant, "you move tablespace WITH files.."
You have to move files in TTS but you can not plug them to the exisitng tablespace.

Sanjay

[pando]

I meant when we transport we transport tablespaces since tablespaces is formed by datafiles...
We dont transport files