Query - Joining Tablespaces??

Hi again, everyone.

I'm trying to select from two tablespaces like this:

Code:

---

SELECT
        st1.tag_name tag1,
        st2.tag_name tag2
FROM
        schema1.table_name st1,
        schema2.table_name st2
WHERE st1.id = st2.id

---

It's working fine when I'm logged in as SYSTEM, but when I'm logged in as schema1, I get the following error:

Quote:

---

ORA-00942: table or view does not exist

---

I realize this is because schema1 can't see the tables in schema2, but I don't know how to resolve it. Anyone have any input?

Thanks !!!

Couple of ways -

grant select on schema_name.table_name to public;
grant select on schema_name.table_name to username;

joining tablespaces?!?!?!

He's from SQL Server, forgive him his trespasses.

Stecal,

Thanks for the code. Is there any way to grant priveleges to the entire tablespace?

Also, believe me, I know it's a sin. It's just as bad in MSSQL. Nevertheless, I have two disparate systems that I have to select from in combination with eachother for reporting purposes.

Thanks for your patience :)