srinivasa.dinesh

 Profile Answers by srinivasa.dinesh 

• Jan 29th, 2008

 

you can use SPOOL command of Oracle.

spool c:temptest.txt
describe table_name
spool off

After executing the above commad u would fine the definition of the table, table_name in test.txt.

Hope this answers your question.

Cheers,
Srini.

sasmita03

 Profile Answers by sasmita03 

• May 22nd, 2008

 

create table (table name) like (source table)

krishnaindia2007

 Profile Answers 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 textfilename
select dbms_metadata.get_ddl('TABLE','EMP','CMSJAN') from dual;
spool off;

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

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