Author Topic: Repository: Any Problems with Oracle 10g database?  (Read 1968 times)

CapJo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Repository: Any Problems with Oracle 10g database?
« on: September 06, 2006, 01:45:13 am »
The manual describes how to create a repository on Oracle 9i.

We have to use Oracle 10g and I would ask if there are any compatibility problems with this version of Oracle.

Maybe someone is using already this configuration?

I also read about some bugfixes in EA 6.5 version which refer to the Oracle DB.

Are there any changes on the table definitions in the new EA Version?
« Last Edit: September 06, 2006, 05:10:48 am by CapJo »

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Repository: Any Problems with Oracle 10g datab
« Reply #1 on: September 06, 2006, 04:04:36 am »
I have used Oracle 10g Express without difficulty. Just follow the directions for 9i. [If you are using the Express product remember that you will not be able to explicitly set workspaces since this version of the product does not offer this option. Otherwise everything will happen as you would expect. This limitation does not apply if you are using any other edition of 10g.]

Sparx made a small tweak to the Oracle 10g support recently, to correct a data type flaw. I had not noticed anything with my EA repository though. My guess is that this only affected the data modelling profile.

Unfortunately the documentation and Sparx Web site don't seem to have caught up, and still explicitly mention only Oracle 9i. I have brought this to Sparx' attention without results to date. Perhaps you will take a moment to add your voice in the Suggestions and Requests section of the forum.

David
No, you can't have it!

CapJo

  • EA Novice
  • *
  • Posts: 15
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: Repository: Any Problems with Oracle 10g datab
« Reply #2 on: September 06, 2006, 05:12:14 am »
Thank you for this detailed information.

Andreas