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?