Oracle Database Discussions

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!

global temporary table over distributed transaction

jymarkusgMay 8 2008 — edited May 10 2008

Hi.

Can I use global temporary tables for the following situation:

db A:
- temp table with ON COMMIT PRESERVE ROWS
- procedure P_CAT which inserts data into temp table

db B:
- call P_CAT over DB Link

Can I query the temp table from db B over a db link?

Thanks
Markus

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2008

Added on May 8 2008

#general-database-discussions

8 comments

1,914 views