Getting the create table command used in oracle 11g

Question

How can I get the create table command which is used to create a table in oracle 11g so that I can copy the command and run it in another database? Please help.

Do you have PLSQL Developer? Which tools do you have to work? — Andrew Paes
– Andrew Paes, Commented Jan 9, 2014 at 11:05

user330315 · Accepted Answer · 2014-01-09 11:05:00Z

3

select dbms_metadata.get_ddl('TABLE', 'YOUR_TABLE_NAME_GOES_HERE')
from dual;

answered Jan 9, 2014 at 11:05

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Yogamurthy Over a year ago

This query worked. you saved me from a 4 hour search.

Dba · Accepted Answer · 2014-01-09 11:06:12Z

1

Try to spool the output of the below query,

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM USER_TABLES u;

Like,

set pagesize 0
set long 90000
set feedback off
set echo off 

spool schema.sql 

SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM USER_TABLES u WHERE TABLE_NAME = '<your_table>';

spool off;

Reference: http://www.dba-oracle.com/oracle_tips_dbms_metadata.htm

answered Jan 9, 2014 at 11:06

Dba

6,6791 gold badge26 silver badges33 bronze badges

Comments

Maheswaran Ravisankar · Accepted Answer · 2014-01-09 11:06:27Z

1

Please use the below Query

select dbms_metadata.get_ddl('TABLE','YOUR_TABLE_NAME','YOUR_SCHEMA_NAME') from dual;

if you use SQL Developer, select the table name , and right click to choose Open Declaration and then Click SQL tab on the window that opens!

enter image description here

answered Jan 9, 2014 at 11:06

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

1 Comment

Yogamurthy Over a year ago

nice info to add to this question

Collectives™ on Stack Overflow

Getting the create table command used in oracle 11g

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related