I have snapshots of two oracle database tablespaces in amazon ec2. Currently we are able to start a database against one of the tablespaces. Is there any way to import the second tablespace into the oracle with a separate user.
We tried creating a new tablespace pointing at the same dbf file and associate it to a new user but the user does not have any access to any objects. The dbf contents are not loaded into the database.
Any help ?
Thanks开发者_JAVA百科.
You might be able to get there using transportable tablespace. That said, is there a reason you cannot simply create a new tablespace and then copy the data to the new tablespace? You could do that either via data pump or SQL.
I am assuming you are more interested in duplicating the data held in that tablespace versus the tablespace itself.
精彩评论