title: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired, exception is java.sql.SQLException
body: <pre><code>jdbcTemplate.execute("alter table UKIADATA rename to UKIADATA_temp");
  
  jdbcTemplate.execute("alter table UKIADATA_2 rename to UKIADATA");
  
  jdbcTemplate.execute("alter table UKIADATA_temp rename to UKIADATA_2");
  
  logger.info("Tables swapped.");
  </code></pre>
  
  <p>I am getting error SQL [alter table UKIADATA rename to UKIADATA_temp]; ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  ; nested exception is java.sql.SQLException: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired,</p>
  
  <p>In addition to this can you help me how can I insert commit statements in this piece of code .</p>