[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

Temp Space use accross dblink

Hi Guys,
 Sorry if this is a n00b questions I should know, but since I'm not 100% sure of myself I have thrown myself on the mercy of the community. Here's what I have going on: One main database and a second machine with a sort of warehouse database. I want to aggregate some data each night on the second machine using a stored procedure. Inside the stored proc. are some table references to tables in the main database that I access via a dblink. My question is: Does the query on the second machine use TEMP space on the primary machine when querying those tables, or does it use the TEMP space on the machine where the stored proc. is executed and just streams the data from the primary database?

Thanks a million...
1 Solution
It does open a new session in the taarget database. I have seen it. If you will query for the user name it will either show Oracle or Null. I would say it does uses the TEMP space of the taarget database.

If you wwant to dig deep into thiss topic then post aa question in ASKTOM. I think you have a very good question.

richl796Author Commented:
Thanks Sugit. That explains a lot.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now