• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

How can I export only constraints from existing database w/o other DDLs

Only want to get the export of Constraints. No create tables, no other objects (pcks, procs...)
1 Solution
you could try this one:
select dbms_metadata.get_ddl('CONSTRAINT', constraint_name) from all_constraints; (or dba_constraints or user_constraints)

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now