title: Table Name with more than 30 characters
body: <p>I have a table in a MySQL database. The name of the table is more than 30 characters long 
  and I want to make the same table in Oracle 11g, but Oracle only allows tables with a maximum of 30 characters in the name.<br>
  I can't change the name of the table to make it less than 30 charachters, because the system is based on these tables, and it will cost me a lot if I change the name, so changing the table name is not the answer I am looking for. </p>
  
  <p>There is a table called <code>user_tables</code>, and when I describe the table it says the the <code>table_name</code> field has a datatype <code>varchar2(30)</code>, so I tried to alter the table and make the <code>table_name varchar2(255)</code> but I couldn't, it gives me an error saying: </p>
  
  <blockquote>
    <p>ORA-00942: table or view does not exist</p>
  </blockquote>
  
  <p>I am connect as <code>sys</code>.</p>
  
  <p>Does anyone know how to solve my problem? </p>