Attach a tablespace to a database? [message #257197] |
Tue, 07 August 2007 13:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jhsong01
Messages: 7 Registered: July 2007
|
Junior Member |
|
|
What I am trying to do is that I want to attach a tablespace from DB A to DB B. The reason is that I can't open DB A up due to system parameter error (spfileSID.ora). So I created a new DB B and want to copy a tablespace from DB A. Is it like doing a restore from a cold backup? Then how can I take care of control files and parameter files?
Thanks,
|
|
|
Re: Attach a tablespace to a database? [message #257202 is a reply to message #257197] |
Tue, 07 August 2007 13:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You can't.
You have to first restore the first database, at least a subset of it including system tablespace, undo/rbs tablespace and your tablespaces.
Then you can use transportable tablespaces.
It is impossible to directly plug tablespaces/datafiles from another database.
Regards
Michel
|
|
|