INSERT with CONNECTION to an external Database.
I have to INSERT an internal table values to an external Oracle Database. The Solution I saw in Forums are with CONNECTION Addition in INSERT option with DBCON.
insert TABLE_NAME@SCHEMA CONNECTION 'PAYPROD'
from table gt_summary.
I am getting syntax error that "TABLE_NAME@SCHEMA", is unknown. It does not exist.
Can anyone help me an example with CONNECTION option in INSERT.