Is there a way to capture complete query along with the bind values in oracle ?

sgalaxy

I think auditing is going to capture all the records being run in the database

It depends. If you want all then all are registered.

Auditing allows registering actions - for example:

1) at the session level, whatever a db user does.

2) at a/some objects owned by a db user and a/some operations(for example dml operations).

e.t.c.

You can consult the Oracle doc:

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4007.htm#SQLRF01107

https://docs.oracle.com/cd/B16240_01/doc/install.102/e12914/ap_oracle_database_auditing.htm  <some examples>

Auditing may be used only to catch the dml operations on tables{sql scripts}.

Greetings

Martin Preiss

if you just want to replicate the data of table x in database 1 to a corresponding object in database 2 then you could create a materialized view in database 2 accessing table x in database 1 and refreshing the MV whenever you think it adequate. Tim Hall provides a small example (as usual) in https://oracle-base.com/articles/misc/materialized-views. If you want something different then maybe the MV is not your option: so maybe you could be a little bit more verbose on your actual requirements.