Hi Guys!
further to my topic, i'm now facing a problem chosing a proper oracle DBMS for the RedHat. I'm going to install 10gR2 on my RHEL AS4, from documentation it appears that it is supported, but i would appreciate if anybody confirm this or let me know the version which is 100% compartible.
And one more question, i was wondering if anybody tried to import configuration DB exported from oracle 9 on sparc solaris to the oracle DB server on x86 linux and succeeded? Is it possible at all?
And last but not least, i need to prepare a query to query LogDB on the oracle directly for the alarm history, but i still don't have an oracle

I've made this query for the MSSQL (by altering initial genesys request), can anyone kindly adjust it for the oracle please?
USE Genlog
select G_LOG_MESSAGES.ID, convert(char,TIMEGENERATED) as TIMEGENERATED, a1.ATTR_VALUE, a2.ATTR_VALUE problem_name, APPNAME, HOSTNAME, a3.ATTR_VALUE problem_description
from G_LOG_MESSAGES, G_LOG_ATTRS a1, G_LOG_ATTRS a2, G_LOG_ATTRS a3
where (G_LOG_MESSAGES.MESSAGE_ID = 4200) and (G_LOG_MESSAGES.PRIORITY = 5) and (a1.ATTR_NAME = 'CAT') and (a2.ATTR_NAME = 'AC_NAME') and (a3.ATTR_NAME = 'LM_TEXT') and (G_LOG_MESSAGES.ID = a1.LRID) and (G_LOG_MESSAGES.ID = a2.LRID) and (G_LOG_MESSAGES.ID = a3.LRID) and G_LOG_MESSAGES.TIMEGENERATED > convert(char,'2009-04-23')
order by TIMEGENERATED desc
GO
Many thanks in advance,
K.