sql - Oracle user_constraints view not showing all constraints -
i need info oracle metadata objects (such constraints, indices , on). when browsing database pl/sql developer, able view and/or edit objects of such kind. objective data programmatically desktop application.
and here, issue comes:
when executing query user_constraints
of constraints, not of them (i still can see them in pl/sql developer though). , same situation occurs when try data all_constraints
(i don't have access dba_constraints
).
can help?
p.s. problem solved
tried filtering user_constraints
view constraints' names (and strangely didn't find them), able see them once filtered names of tables own them.
anyway, help!
Comments
Post a Comment