> AFAIU, this is possible with synonyms only but the SQL specification has
> no such a feature. Nobody said we should follow exactly the Oracle's
> implementation.

What would you say about mandatory indication of schema in SQL
queries? If now I can just write "select * from a_table", with schemas
I'll have to write "select * from some_schema_name.a_table".
Sometimes I am lazy too, so I don't like unnecessary typing.

SY, SD.

PS: All your meaningful examples of schema usage are covered by replication.