Allowed values for DDL OBJTYPE

user9013481

Does anyone have experience with filtering object types using DDL EXCLUDE OBJTYPE clause. I'm interested in filtering out all constraints but regular DDL EXCLUDE ALL OBJTYPE 'CONSTRAINT' doesn't do the job. Also, documentation only covers TABLE, INDEX and SEQUENCE. Are these the only ones supported here?

-joe

Hi.

All DDL object types not documented unsupported should be supported.

SQL> select distinct(object_type) from dba_objects where object_type='CONSTRAINT';
no rows selected

It's not filtering because CONSTRAINT isn't a valid object type in Oracle. Try something like:

DDL INCLUDE ALL EXCLUDE INSTR ‘ADD CONSTRAINT’

Good luck,
-joe