Oracle Database Discussions

I don't think that the migration workbench maps multiple databases from a Sybase server exactly the way that I am used to. I am used to switching between databases with similar (or identical) table definitions, but with different data by using the Sybase "use" database command. That is I will have a single user id for a collection of databases on a single server.

I have experimented a little bit with creating the same table in 2 different Oracle schemas (which I consider to be like Sybase database owner users). Then I can create Oracle "roles" to grant access on those tables to a 3rd Oracle user.

Then from the 3rd user I can use "set role" to get access to the appropriate table, but I still have to specify the schema of the table owner. It would be nice if I could associate synonyms with the role so that when I do the "set role" it would be more equivalent of the Sybase "use" command.

I suppose I could simulate this more by doing the "set role" followed by creation of synonyms for each of the tables that I have gotten the access to, but what if I have a few hundred tables, which will require a few hundred synonyms to be created.

Has anyone else figured out a way to do this?

Maybe I'm just trying to force a Sybase concept into an Oracle database and there is not a good Oracle equivalent.