I've pictures of two oracle database tablespaces in amazon . com ec2. Presently we could begin a database against among the tablespaces. Can there be in whatever way to import the 2nd tablespace in to the oracle having a separate user.

We attempted developing a new tablespace pointing in the same dbf file and connect it to a different user however the user doesn't have any use of any objects. The dbf contents aren't loaded in to the database.

Any help ?


You may have the ability to make it happen using transportable tablespace. Nevertheless, it is possible to reason you can't simply produce a new tablespace after which copy the information towards the new tablespace? You could do this that either via data pump or SQL.

I'm presuming you care more about copying the information held for the reason that tablespace versus the tablespace itself.