Re: what is this sqlplus output?

There are two synonyms with the name PAYROLL_TRANSACTION_DETAIL

A public synonym PAYROLL_TRANSACTION_DETAIL for OPS$KTCO.KTCOPROD_PAYROLL_TRANS_DETL (Schemaname.Tablename)

A private synonym PAYROLL_TRANSACTION_DETAIL in schema OPS$PROFOUND for OPS$PROFOUND.KTCOPROD_PAYROLL_TRANS_DETL

What it means is that when user OPS$PROFOUND issue a SELECT * FROM PAYROLL_TRANSACTION_DETAIL the statment is executed against OPS$PROFOUND.KTCOPROD_PAYROLL_TRANS_DETL. Other users doing the same SELECT * FROM PAYROLL_TRANSACTION_DETAIL the statment is executed against OPS$KTCO.KTCOPROD_PAYROLL_TRANS_DETL. JhMa

Martin Meadows wrote in message <353EB30A.1EE2_at_indy.net>...
>I just ran a command in sqlplus that produced output I don't understand.
>Can someone please explain it?
>
>SQL> SELECT * FROM ALL_SYNONYMS
> 2 WHERE SYNONYM_NAME = 'PAYROLL_TRANSACTION_DETAIL';
>
>OWNER
>SYNONYM_NAME
>------------------------------
>------------------------------
>TABLE_OWNER
>TABLE_NAME
>------------------------------
>------------------------------
>DB_LINK
>----------------------------------------------------------------------
>PUBLIC
>PAYROLL_TRANSACTION_DETAIL
>OPS$KTCO
>KTCOPROD_PAYROLL_TRANS_DETL
>
>
>OPS$PROFOUND
>PAYROLL_TRANSACTION_DETAIL
>OPS$PROFOUND
>KTCOPROD_PAYROLL_TRANS_DETL
>
>
>OWNER
>SYNONYM_NAME
>------------------------------
>------------------------------
>TABLE_OWNER
>TABLE_NAME
>------------------------------
>------------------------------
>DB_LINK
>----------------------------------------------------------------------
>
>
>Thanks,
>Martin Meadows
>Indianapolis, In.
Received on Thu Apr 23 1998 - 06:33:24 CDT