1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Using one global temporary table

Discussion in 'General' started by mariasmile509, May 3, 2018.

  1. mariasmile509

    mariasmile509 Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    mariasmile509
    Hi there,

    I'm new to using global temporary tables in Oracle.
    I'm using Ora cle 10g R2.
    I have multiple schema's in the database. Each schema has its own set of database objects (tables, views, procedures ... etc).
    One of the schemas has a global temporary table which is filled with a stored procedure.
    If I want to use the global temporary table and the stored procedure in another schema ( or maybe more schemas in the future) what is the best practice?
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,600
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    It's global so any user that wants to use it can; simply grant them privileges on the stored procedure.