开发者

import a dbf file in oracle

开发者 https://www.devze.com 2023-04-07 09:39 出处:网络
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 o

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消