Truncate a table using database link
592323May 30 2008 — edited Aug 28 2009Hi,
I created a shell script to truncate a table on the remote database and insert into it.When i execute the shell script,while truncating the table,it gave the error
ORA-02021: DDL operations are not allowed on a remote database
but all the records are inserted in to the table.
Since its a remote database,i dont know about the priveleges that have to the schema.So what are the priveleges required for the truncate statement to work so that required so that the truncate command can work from script
Thanks