我在Amazon EC2上两个Oracle数据库表空间的快照。 目前,我们能够对表空间中的一个启动数据库。有没有什么办法可以导入第二个表与一个单独的用户神谕。
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.
我们试图创建一个新的表指示在同一DBF文件,并将其关联到一个新的用户,但用户没有任何访问的任何对象。该DBF内容不会被装载到数据库中。
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.
任何帮助吗?
感谢。
您可能能够使用传输表空间到那里。这就是说,有不能简单地创建一个新表,然后将数据复制到新的表空间的理由吗?你可以这样做,要么通过数据泵或SQL。
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.