EA4.0 Corp:Unable to transfer EAP into Oracle DBMS

[michal]

Dear EA authors,

I am evaluationg EA 4.0 in Corporate mode.
I created database repository for EA in
Oracle 8.1 and have datasource ready.
I am able to connect there, perform
create table, insert,select,delete,drop table

I have my EA-Test.eap file with few elements.
I launch EA in Corporate mode and select
Tools/Data management/Data transfer
select .EAP into DBMS option, carefully select
my EA-Test.eap as a source and my Oracle DB
as a target, then I select Oracle Provider for OLE DB
etc Test connection says successfull.

When I finally click Transfer data button,
EA I get
DAO.Database [3065]
Cant execute select query.

What do I do wrong ?
Thank you for your help, I really like your tool

Best regards
Michal

[Bruno.Cossi]

Hi Michal,

you do not mention creating the actual repository tables, i.e. running the SQL script in your Oracle db. That could be cause of your problem.

Bruno

[michal]

Hi Bruno,

the original problem I posted was certainly
caused by the missing tables etc in the DB.

I've downloaded the Oracle installation
.sql script.

It does not run for me. I am running Oracle
8.1.5, but the installer script mentions Oracle 9i.
Does someone succesfully run my version of Oracle
as a repositorty for EA ?

Thanks
Michal

[Bruno.Cossi]

Hi Michal,

I do not, but I see no reason why it should not be possible. We may have to edit the sql script a little... what are the errors you get when you try to execute it?

Bruno

[hd]

EA is only supported on Oracle 9i upwards - it will not run on version 8.

[michal]

I thought so, thanks for your reply...