Temp Space use accross dblink

Posted on 2005-04-26
Last Modified: 2013-12-11
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...
Question by:richl796
    LVL 11

    Accepted 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.


    Author Comment

    Thanks Sugit. That explains a lot.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now