Home » RDBMS Server » Backup & Recovery » Attach a tablespace to a database?
- Attach a tablespace to a database? [message #257197] Tue, 07 August 2007 13:32 Go to next message
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,

Report message to a moderator

- 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
Michel Cadot
Messages: 68755
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

Previous Topic: Recovery Catalog Database Creation
Next Topic: Dataguard 2nd Standby on private IP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 04 18:56:15 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.