bug on context index and xmltype column

Track changes to Oracle schemas in your existing version control system.

bug on context index and xmltype column

Postby errr3 » Wed Feb 12, 2014 7:23 am

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
 
Posts: 3
Joined: Wed Feb 12, 2014 7:21 am

Postby Brian Donahue » Thu Feb 13, 2014 5:53 pm

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
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Postby errr3 » Wed Aug 06, 2014 12:26 pm

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
 
Posts: 3
Joined: Wed Feb 12, 2014 7:21 am

Postby Brian Donahue » Wed Aug 06, 2014 3:02 pm

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
 
Posts: 6590
Joined: Mon Aug 23, 2004 10:48 am

Re: bug on context index and xmltype column

Postby waleed12 » Wed Jan 07, 2015 5:57 am

Hi,

Although Schema Compare for oracle correctly compares object grants, Source Control For Oracle seems not.
Apparently SCFO is ignoring the grants to roles.
If you are looking for fast success in learn french then join today to find complete learn to speak italian resources and pass passguide certifications on first try. A person can pick bbc selftestengine for its easiness.
waleed12
 
Posts: 1
Joined: Wed Jan 07, 2015 5:29 am

Re: bug on context index and xmltype column

Postby richardjm » Mon Jan 12, 2015 5:27 pm

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
Richard Mitchell
Project Manager
Red Gate Software Ltd
richardjm
 
Posts: 507
Joined: Fri May 20, 2005 9:44 am
Location: Red Gate Software Ltd


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests