In Oracle, how do I create the "CREATE TABLE..." syntax for an existing table?

Question

SQL Server has a way to let you "export" an existing table's schema, in the form of its necessary SQL "Create Table" commands.

How do you do this in Oracle? Is there a nice automated way of doing it?

Community · Accepted Answer · 2017-05-23 10:27:36Z

3

SQL Server parallels to Oracle DBMS_METADATA.GET_DDL?

Gives a good example.

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Nov 24, 2009 at 2:30

David

1,3157 silver badges8 bronze badges

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

Comments

Jim Hudson · Accepted Answer · 2009-11-24 14:16:55Z

3

Using a tool like SQL Developer or Toad is probably simplest. But the information is all available in the data dictionary. In particular, check the documentation for DBMS_METADATA.get_ddl. Something like

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

should do what you want.

answered Nov 24, 2009 at 14:16

Jim Hudson

8,0992 gold badges26 silver badges15 bronze badges

Comments

Santosh Gokak · Accepted Answer · 2009-11-24 01:45:42Z

2

You can use SQLDeveloper for this. It is freely available and you can just right click on the table and can export the DDL query,export data in various format,etc.

Below is the link to sample Export HOW-To http://www.oracle.com/technology/products/database/sql_developer/howtos/export_intro.htm

answered Nov 24, 2009 at 1:45

Santosh Gokak

3,4213 gold badges24 silver badges24 bronze badges

Collectives™ on Stack Overflow

In Oracle, how do I create the "CREATE TABLE..." syntax for an existing table?

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related