Hey guys just want to get some generic feedback about using MySource with an oracle database…
What things should I be aware of? what things might need to be changed to get all working correctly? what languages must be loaded into the db/schema to get triggers stored procedures working etc?
Any information would be good.
Our Oracle guru is actually on a PostgreSQL course this week, so there may be a delay in answering. 
I know there needs to be a date style modification, but otherwise I'm clueless.
trying to get some ammunition to push for the default postgres, so we do not have to change the system to much to get it running.
Would much prefer to stay with recommended DBMS…
[quote]Our Oracle guru is actually on a PostgreSQL course this week, so there may be a delay in answering. I know there needs to be a date style modification, but otherwise I’m clueless.
[right][post=“8022”]<{POST_SNAPBACK}>[/post][/right][/quote]
You'll be lucky to get a response this year acutally. He's off on a well earned holiday after that course.
As far as I know, it's a standard Oracle install (whatever that is). We dont require any special packages.
We have tested on 9i and 10g.
You do have to change the NLS_DATE_FORMAT (I think thats the name of the config var) so dates are in the correct format in the DB. Avi can probably dig that format up??
Its a tough question to answer: If you have inhouse Oracle skills and spare Oracle resources and licences, Oracle is usually faster than PostgreSQL (because you have all this hardware dedicated to it and a bunch of people who's job it is to make sure it runs fast).
On the other hand, PostgreSQL can be wrapped up into a "black box" operation, where your DBAs aren't even aware of it. Under normal operating conditions there is absolutely no human interaction required with the PostgreSQL system. Simply put, it should just keep running.
Edited to add that I can find the NLS_DATE_FORMAT string if required from one of our running Oracle installs.
I agree with you Avi, we do have in house resources for Oracle, and servers currently running, but large recurring costs per year for access to them.
Our preferred approach possibly would be to install postgres, and send some staff on training for that.
But I guess as normal we place our recommendations and its the people up high who make the choice
[quote]Its a tough question to answer: If you have inhouse Oracle skills and spare Oracle resources and licences, Oracle is usually faster than PostgreSQL (because you have all this hardware dedicated to it and a bunch of people who’s job it is to make sure it runs fast).
On the other hand, PostgreSQL can be wrapped up into a “black box” operation, where your DBAs aren’t even aware of it. Under normal operating conditions there is absolutely no human interaction required with the PostgreSQL system. Simply put, it should just keep running.
Edited to add that I can find the NLS_DATE_FORMAT string if required from one of our running Oracle installs.
[right][post=“8026”]<{POST_SNAPBACK}>[/post][/right][/quote]