 <p>The <code>DATATYPE</code> are different in <code>Oracle</code>. </p> <p>Also, <code>auto_increment</code> is not in <code>Oracle</code>. In <code>11g</code> and prior, create a <code>SEQUENCE</code> to populate the ID column, in <code>12c</code>, use <code>IDENTITY COLUMNS</code>.</p> <pre><code>SQL&gt; DROP TABLE metadata PURGE; Table dropped. SQL&gt; SQL&gt; CREATE TABLE MetaData 2 ( 3 ID NUMBER NOT NULL, 4 metaDataId VARCHAR2(255) NOT NULL, 5 parentId number NOT NULL, 6 locked number, 7 userId number NOT NULL, 8 CONSTRAINT p_id PRIMARY KEY (id), 9 CONSTRAINT u_metadataid UNIQUE (metaDataId) 10 ); Table created. SQL&gt; </code></pre> <p>For the <code>auto_increment</code> of ID, in <code>Oracle 10g</code>, you need to create a <code>sequence</code>.</p> <p>In <code>12c</code>, you can have an <code>IDENTITY COLUMN</code>.</p>