Hi,
My version:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
My Doubt:
I have two dbs: In local db I have two table History and Archieve, and in remote archieve.
When records are insert from histroy table to Archieve table (local db), records simultaneouly move to remote db archieve table. so here i create one trigger on local archieve table.
My script:
Create or replace trigger trg_dummy
after insert on FBNK_FUNDS_TRANSFER#ARC@esdevdb2
for each row
begin
if inserting then
@ copy_table_dummy.sql
end if;
end;
/
ERROR at line 2:
ORA-02021: DDL operations are not allowed on a remote database
Regards,
Prathap