OraFAQ Forum: Client Tools » Generate DDL using Sql Developer

Home » Other » Client Tools » Generate DDL using Sql Developer (Oracle 12.1.0.2 ,Windows server 2012 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generate DDL using Sql Developer [message #664621]

Tue, 25 July 2017 01:29

chad_2000
Messages: 23
Registered: February 2017

Junior Member

Hi,

There is a way for generating tables definition scripts using Oracle SQL Developer(using the "Tools" > "Database Export" menu entry.), but the problem is that the tables are exported in the alphabetical order ( not depending on foreign key constraints - Parent and child tables definition).

How can generate tables,indexes,constraint definition scripts which does not have this issue?

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664623 is a reply to message #664621]

Tue, 25 July 2017 02:11

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Generate first all tables without constraints then add constraints.

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664624 is a reply to message #664623]

Tue, 25 July 2017 02:47

chad_2000
Messages: 23
Registered: February 2017

Junior Member

Thank you so much for your useful reply.
In the generated script for those tables that have a referenced partition, foreign key constraints are added, despite unchecked constraint at option type selection step.

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664626 is a reply to message #664624]

Tue, 25 July 2017 06:23

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

chad_2000 wrote on Tue, 25 July 2017 02:47

Thank you so much for your useful reply.
In the generated script for those tables that have a referenced partition, foreign key constraints are added, despite unchecked constraint at option type selection step.

So what prevents you from taking saving the generated ddl to a file, then editing it to put things in the order that you need?

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664636 is a reply to message #664621]

Tue, 25 July 2017 09:03

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

The FK constraints are listed AFTER all the tables, so table order shouldn't matter.

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664637 is a reply to message #664636]

Tue, 25 July 2017 10:06

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For the constraints, generate first the primary key and unique constraints, then the FK.

[Edit: missing letter]

[Updated on: Fri, 17 August 2018 00:20]

Report message to a moderator

Re: Generate DDL using Sql Developer [message #664644 is a reply to message #664637]

Tue, 25 July 2017 23:32

chad_2000
Messages: 23
Registered: February 2017

Junior Member

Thank you so much.

Report message to a moderator

Re: Generate DDL using Sql Developer [message #671209 is a reply to message #664644]

Thu, 16 August 2018 16:35

Sewers
Messages: 1
Registered: August 2018

Junior Member

Good job

Report message to a moderator

Previous Topic:	Convert ASCII number 177 to character +/-
Next Topic:	SQL Developer Loosing Connect

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:40:07 CDT 2025