How can I copy the stucture of a table to a text file.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table ABC as (select * from XYZ where 1=2)

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 21st, 2008

You can copy the definition of objects to text file using dmbs_metadata package.This is the query to copy emp table definition to text file.spool textfilenameselect dbms_metadata.get_ddl('TABLE','EMP','CMSJAN') from dual;spool off;

Answer Question  Select Best Answer