Author Topic: Repository support for Oracle Express  (Read 3696 times)

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Repository support for Oracle Express
« on: March 14, 2006, 06:01:01 am »
Please consider explicit support for EA Corporate repositories using the new Oracle Express no-cost version.

[If the schema etc. for Oracle 9.x works well, please consider adding instructions for Oracle Express, along the same lines as your support for MSDE and SQL Server.]
No, you can't have it!

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Repository support for Oracle Express
« Reply #1 on: April 06, 2006, 10:45:47 am »
For those interested in this...

I've finally had the bandwidth to install and work with Oracle 10g Express, mentioned in this thread.

Using the Oracle 9i script provided by Sparx I was able to get up and running without incident. To this point I have done only minimal testing but all appears to work correctly.

My Oracle installation as fresh - there was no Oracle software, client or server - on the machine before the 10g installation. I installed the Unicode version of the Oracle 10g Server package, which installs the Oracle client as well. I immediately tried bringing EA up, with no problems whatsoever, following normal Oracle procedures for a new schema. [Oracle 10g Express does not (seem to) allow customized creation of tablespaces, so I just accepted those offered.]

I have loaded a good sized class hierarchy (the CWM from OMG) into the test model, and accessed it through automation (via .Net). Both worked without incident. It is still too early to tell how the performance stacks up against other EA repository platforms.

Please let me know if any of you try this, and your experiences differ.

David
No, you can't have it!