Truncating from a remote database is not allowed. On a development database environment, developers are in need of truncating certain tables on a regular basis. Delete is allowed over database link, that’s an option. But, that’s a bad example for allowing fragmentation and high water mark over the period of time.
If you try to truncate a table on a remote database, you will get the following error:
ORA-02021: DDL operations are not allowed on a remote database.
As, procedure can be executed over a dblink, so following workaround can be a good option on such scenario.
1. Create a procedure on Remote Database that can truncate
2. Execute the procedure from local database.