Is there a way to define the Oracle server and schema as a property in a linked server? I need to link to server 'g1' and a schema 'trl.' I can define the server or the schema but not both. I tried this:

exec sp_addlinkedserver
@server = 'test',
@srvproduct = 'Oracle',
@provider = 'MSDAORA',
@datasrc = 'g1',
@location = '',
@provstr = '',
@catalog = 'trl'

The sp executed but the linked server didn't work. I imagine obviously because the "schema" isn't a catalog.