Re: Any diff using Synony

In article <8A8E4AA.0BBB000E57.uuout_at_onwe.co.za>, frank.naude_at_onwe.co.za (FRANK NAUDE) says:
>
>In article <D7tzLD.I0L#crash.cts.com> pme_at_crash.cts.com (Phil Melendez)
>write:
>
>>Is there any difference in performance when using synonyms vice the fully
>>qualified table name? Example:
>>
>> select emp_name, emp_code
>> from emp
>> where emp_name = 'John'
>>
>> select emp_name, emp_code
>> from misc.emp <--
>> where emp_name = 'John'
>
>Our PC-Lab guys told me that Oracle Forms 4.5 prefix object names
>with the current schema (ie SCHEMA.TABLE). They don't like it since
>it makes the application static/unportable (they can't move it to a
>different schema). So they need to revise _all_ generated triggers and
>edit it out!
>
>Any ideas on how to avoid this?
>
>Cheers
>Frank

  We have an application owner which owns all the tables. PAYOWNER, for example. Each user account, PAYUSER for example, has a synonym for each table owned by PAYOWNER. For example:

        CREATE SYNONYM PAYUSER.TABLE1 FOR PAYOWNER.TABLE1;   Then, the app is coded to reference TABLE1. No prefix (schemaname) required (or desired).
  Exports can then easily be imported into another schema, producing development data for testing with.

	                                  Brian

--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com