title: Why regular oracle table support DML statements,but not the same for External table?
body: <p>This is known to us that all <em>DML</em> statement has been supported by <strong>Oracle Regular Table</strong> but not the same for <strong>External Table</strong>? I tried below :</p>
  
  <pre><code>SQL&gt; INSERT INTO  xtern_empl_rpt VALUES ('70','Rakshit','Nantu','4587966214','na
  tu.rakshit@ge.com','55');
  INSERT INTO  xtern_empl_rpt VALUES ('70','Rakshit','Nantu','4587966214','natu.ra
  kshit@ge.com','55')
               *
  ERROR at line 1:
  ORA-30657: operation not supported on external organized table
  
  
  SQL&gt; update xtern_empl_rpt set FIRST_NAME='Arup' where SSN='896743856';
  update xtern_empl_rpt set FIRST_NAME='Arup' where SSN='896743856'
         *
  ERROR at line 1:
  ORA-30657: operation not supported on external organized table
  
  
  SQL&gt;
  </code></pre>
  
  <p>So it seems <strong>External table</strong> not support this. But my question is - what the logical reason behind this design?</p>