Oracle Database Discussions

Hi Experts,

My DB version is 10.2.0.5 and OS windows platform

I need metadata of tables,indexes and constraints of one schema, I can able to get metadata of tables & indexes as

select dbms_metadata.get_ddl('TABLE','table_name',owner) from dba_tables where owner='BIUS';

but when I'm tring to get metadata of constraints from all_constraints then i can able to see only 7 constraints metadata and terminating with error " but i have around 500+ constraints when i checked with
select count(*) from all_constraints where owner='BIUS';

Here i can change user password and i can get it after login to user, but without changing user password can i get it?

Is it possible to get only metadata of constriants using export/import?

Please share your ideas, appriciated for right anwers.

Thanks