title: INSERT ALL INTO a table over a dblink .. Is it possible?
body: <p>When I execute the following:</p>
  
  <pre><code>INSERT ALL INTO table@database_link(columnName) VALUES (columnValue)
  SELECT columnValue FROM localTable;
  </code></pre>
  
  <p>I get an error</p>
  
  <blockquote>
    <p>SQL Error: ORA-02021: DDL operations are not allowed on a remote
    database
    02021. 00000 -  "DDL operations are not allowed on a remote database"
    *Cause:    An attempt was made to use a DDL operation on a remote database.
               For example, "CREATE TABLE tablename@remotedbname ...".
    *Action:   To alter the remote database structure, you must connect to the
               remote database with the appropriate privileges.</p>
  </blockquote>
  
  <p>Note that when I do a regular (not an insert ALL into) ... the insert works over the database link. (Grants are valid).</p>
  
  <p>There are also NO triggers on either tables.</p>
  
  <p>And I explicitly need the INSERT ALL INTO, to allow for the ability to insert into multiple tables.</p>
  
  <p>Are INSERT ALL INTO operations not allowed into database link tables?</p>