Search Mailing List Archives

Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[protege-discussion] Oracle DB project user privileges?

Jonathan Carter jonathan.carter at
Wed Feb 6 03:04:11 PST 2008

I forgot to ask, Timothy - any thoughts on my SQL Server 2005 problem - see
We're seeing more and more of that at our clients and would really like to
be in a position to support it. 
In the meantime, I'm using Oracle as a fallback as that particular client
has both.
Thanks very much for your help

*Failed to create index for 'short_value' column because the index key
exceeds the 900 byte limit. MS have posted a work-around 'solution' for
indexing nvarchar columns.
Jonathan Carter - Head of Technical Architecture
Enterprise Architecture Solutions Ltd



From: protege-discussion-bounces at
[mailto:protege-discussion-bounces at] On Behalf Of Timothy
Sent: 05 February 2008 22:23
To: User support for Core Protege and the Protege-Frames editor
Subject: Re: [protege-discussion] Oracle DB project user privileges?

How are things going with using Oracle?  I don't know of any particular
problems with running Oracle.  The comment you found was written some time
ago by Ray but I don't remember having to do anything with privileges.
There was an issue with Oracle and a limitation of how long the value field
can be but this was fixed relatively recently.


On Jan 21, 2008, at 3:20 AM, Jonathan Carter wrote:

When I was looking in the problem I have with MS SQL Server 2005 (and I have
to say, I lay that one at Microsoft's door...) I noticed in the source code
for the, a comment in the code that says "For some
bizarre reason on Oracle doing an index on the function of a column requires
that a user have an obscure addition privelege on the database.
Unfortunately this privelege is disabled by default."
This is a comment on the createIndexOnLowerValue() method of
OK, my question is: What is this obscure addition privilege for the user
that I need to know about? 
What are the things that I need to know in order to use Oracle as the DB
backend - beyond the standard, driver, URL, table, user name and password? 
Thanks for your help - any experiences of using Oracle as the database would
be great.

Jonathan Carter - Head of Technical Architecture
Enterprise Architecture Solutions Ltd

Assess your EA maturity at:

W O R L D    C L A S S    A R C H I T E C T U R E

protege-discussion mailing list
protege-discussion at

Instructions for unsubscribing: 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the protege-discussion mailing list