Oracle Database Discussions

Hi all,

11.2.0.3

I want to disable constraints of all tables when importing all tables in HR schema. I created disable scripts using the dba_constraints view as:

select 'ALTER TABLE '||OWNER ||'.'|| TABLE_NAME || ' disable constraint '|| CONSTRAINT_NAME ||';' from dba_constraints where OWNER = 'HR';

I can not understand why my result contains an VIEW with contraints? Hence my script has error.

select owner,table_name,constraint_name,status from dba_constraints where OWNER = 'HR' and table_name='VW_CHANGEMP'

select * from dba_objects where object_name='VW_CHANGEMP'

ALTER TABLE HR.VW_CHANGEMP enable constraint SYS_C0011953;

*

ERROR at line 1:

ORA-00942: table or view does not exist

Please help why a view IS INCLUDED in dba_constraints table?

Thanks,

pK