Hi Tom !

I have 2 databases, A and B. Created a database link from A pointing to B.
Let's call it "dblinkB".

In database B there's a table "mytable" with a trigger, that captures information from the instance using V$SESSION.

I make inserts from A in this table "mytable" like "INSERT INTO MYTABLE@dblinkB VALUES('myvalues');".

I would like to track the database identification from which database this INSERT was made, for logging purposes.

Tried to use SYS_CONTEXT variables, but all the information I receive is concerned to database B.

Thank you !

Antonio

sys_context ( 'USERENV', 'DBLINK_INFO' )