ok as i have stated above in my post, the Oracle Stream is setup to replicate any DDL & DML on TABLE A on DATABASE A to TABLE B on DATABASE B, & both Databases sit on same machine, after making changes & committing on TABLE A of DATABASE A, the changes are not showing up on TABLE B of DATABASE B, so now i can not be more specific than that, unless you can point out to something which i can look into!!!

i have tried setting my global names = true but then my database link does not works, please note that the database link is working just fine without having the global names = true & both databases sit on the same machine!!

thanks for your extensive reply, but as i have stated in earlier posts, whenever i set the global names parameter = true, the database link does not work, for example if i run a simple select query on db2 from db1, it does not work, but rather if i have global names = false the same query works fine, i will post the error message later,

well i have been able to fix the global_names situation, but even after fixing that the stream is not working, my AQ_TM_PROCESSES parameter was set to 0, can some one please expand on this parameter & help me get this baby working!!