View Single Post
  #3 (permalink)  
Old 07-02-09, 14:28
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,297
Quote:
Originally Posted by jp7234
BUt I do not want to use the shema in front of the table [system_t] or synonyms. Are there other ways for this?
Why don't you want to use synonyms? A user synonym is the perfect solution for your problem. You can even automate the creation for that.

The only other workaround would be to use views but that is more or less the same as user synonyms.

On a side note: tables in Oracle are never written with this strange bracket notation
Reply With Quote