Youu can create a synonym (read up on public and private synoyms to see the difference) or when you do the select, prefix the table/view name with the owner, i.e.
select * from "schema_name"."table_name";
In your case:
select * from sys.v$xatrans$;
Bazzza




Reply With Quote