Re: Access 97 -> Oracle 7i Newbie-Questions

You can forget the entire idea. Access SQL will not work in Oracle. And the entire concept of importing views into Oracle is also a non-starter.

Either create an ODBC link and do insert queries into Oracle tables or export the data as delimited or fixed-length ASCII files and bring it in using SQL*Loader.

If you want to work in Oracle ... and think you can translate what you were doing in Access into Oracle you are going to either leave horribly frustrated and unhappy thinking Oracle doesn't work ... or worse.

Get with the program. Oracle requires reading and training.

Daniel Morgan

Stefan Donath wrote:

> Hi there!
>
> I try to convert my Access-Backend on Oracle.
>
> Now I wanted to export my queries as views.
> But if I want do insert data in the way I did in Access (the same
> SELECT-Query that search the data), Oracle display the message "data
> manipulation operation not legal on this view"
> How do I insert data with my forms?
>
> Another problem is, that I can't change a field that's referenced by another
> field.
> A table MK has a field KN. The table AV has a field KN as primary key. The
> MK:KN has a reference on AV.KN.
> If I want to change the value of MK.KN, it should make the same change in
> AV.KN. But it doesn't. Instead of that it gives an error.
> Can this be done with a trigger? If yes, how?
>
> Thanks for tips,
>
> Bye,
> Stefan D.
Received on Tue Feb 26 2002 - 13:49:25 CST