How can we help you today? How can we help you today?

bug on context index and xmltype column

Refresh after commit changes show incorrect changes with context index on xmltype column.

For example:
create table t1(col xmltype);

create index idx_test on t1(col)
indextype is ctxsys.context
parameters ('datastore ctxsys.default_datastore
filter ctxsys.null_filter
section group ctxsys.auto_section_group
sync (on commit) memory 16m');
errr3
0

Comments

5 comments

Sort by
  • Brian Donahue
    I am thinking that Source Control for Oracle does not support the CONTEXT index type. When the program attempts to create a DDL script for this, it ends up like
    CREATE INDEX idx_test ON t1(SYS_MAKEXML(0,"SYS_NC00002$"));

    I'll see if I can get some confirmation about this.
    Brian Donahue
    0
  • errr3
    Bug still exists in Source Control for Oracle 2.0.3.489. Customers who use xml index cannot use you product normally, developpers don't want to migrate to your poduct while this bug exist.
    errr3
    0
  • Brian Donahue
    Sorry for the lack of response. This syntax seems to be working now in Source Control for Oracle 2.0.3.489, which just came out today on Red Gate Check for Updates.
    Brian Donahue
    0
  • waleed12
    Hi,

    Although Schema Compare for oracle correctly compares object grants, Source Control For Oracle seems not.
    Apparently SCFO is ignoring the grants to roles.
    waleed12
    0
  • richardjm
    I've just had a quick look and Source Control for Oracle (SOCO) seems to support grants to roles and I'm not aware of any existing problems.

    Can you give an example or your issue - perhaps using support@red-gate.com
    richardjm
    0

Add comment

Please sign in to leave a comment.