Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Querying multiple datastore

930542Aug 24 2012 — edited Aug 24 2012
Hi:

I was wondering whether it is possible to query tables present in different datastore.

For example...suppose there are 2 datastore (DS1 and DS2) and each having 1 table.

Datastore | Table Name
--------------------------------
DS1 | TableA
DS2 | TableB

Is it possible to have a query joining tables "TableA" and "TableB" in 2 datastore ?

I know timesten does not support dblink. But is there any alternative for it. ?

Thanks
Ved

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2012
Added on Aug 24 2012
1 comment
72 views