Forum Stats

  • 3,875,203 Users
  • 2,266,862 Discussions
  • 7,912,106 Comments

Discussions

Allowed values for DDL OBJTYPE

user9013481
user9013481 Member Posts: 5 Blue Ribbon
edited Oct 20, 2010 12:01AM in GoldenGate
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?

Answers

  • -joe
    -joe Member Posts: 226
    edited Oct 20, 2010 12:01AM
    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
This discussion has been closed.