This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,056 Users
  • 2,269,775 Discussions
  • 7,916,823 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.