title: Copy a table including DDL statements for an Oracle table
body: <p>I Know of this below mentioned  command for copying table fully but i am not able to figure out how this command will work because i cant just find the mentioning of newly created table. (courtesy SO).</p>
  
  <pre><code>    SET LONG 5000
  SELECT dbms_metadata.get_ddl( 'TABLE', 'MY_OLD_TABLE_NAME' ) FROM DUAL;
  </code></pre>
  
  <p>And also i read in some oracle forum posts that this is  not a one shot solution to copy table ,its data and all the constraints , triggers , indexes and other such objects. 
  IS this true ?</p>