I'm working with an application connected to a database containing reporting and non-reporting tables.
For 'performance issue', reporting tables can be moved to another database (same or different dataserver)
My application basically retrieves some info from non-reporting tables, compute them then write the output in reporting tables.
In the case where my reporting tables are not in the same database, which log segment is used during the process? are both log segment used?
Thanks for your feedback.