• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • 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...)
0
vkchaitu82
Asked:
vkchaitu82
1 Solution
 
grzessioCommented:
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

0
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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