Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Truncate a table using database link

592323May 30 2008 — edited Aug 28 2009
Hi,

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2009
Added on May 30 2008
7 comments
9,645 views