Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> query referential constraints
Hi,
How do I extract information about about a schema object's referential constraints? DBA_CONSTRAINTS view only provides a list of constraint names without explicitly identifying the referenced columns. I suppose that this will be a joint between DBA_CONSTRAINTS and DBA_INDEXES. I am looking for a way to duplicate all constraints from a schema to another. Thanks.
Hop Pham
pham_hop_at_bah.com
Received on Tue Feb 01 2000 - 16:19:25 CST