• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • 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

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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