Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle support of Oracle Database 11g on VMWare

891176Sep 28 2011 — edited Sep 28 2011
My company is considering an installation of Oracle database on VMWare. I read some comments that Oracle does not alwayes support issues in the environment like this. Does anybody know whether Oracle supports Oracle database installed in VMWare or not in case we have some issues?
Thank you very much.
This post has been answered by cRazy DBA on Sep 28 2011
Jump to Answer

Comments

Kalpataru

Hi Soofi,

Is your source database and destination database version are same , check the both database version properly ?

Is your view have rowid column ?

If yes then remove the rowid column and try.

You can also check this threads for your reference.

http://www.orafaq.com/forum/t/119514/

ORA-02070: database TO_LINK does not support operator USERENV in this cont

SQL Error: ORA-02070: database does not support in this context

If your issue is not resolved then you can ask it in Oracle Support Forms forum for better help.

Andreas Weiden
Answer

If oyu use a "foreign" database other than Oracle, the concept of ROWID's is unknown.

You can overcome this by changing the Key-Mode of the block to "Non-Updateable" and mark your PK-column-item in the block by Setting the property "Primary Key" to "Yes"

Marked as Answer by Soofi · Sep 27 2020
Soofi

Thanks Andreas Weiden,

It worked for me. But what if my foreign table has no primary key.

Regards,

Soofi

Andreas Weiden

But what if my foreign table has no primary key.

Well, then you are out of luck (and you have a problem with the database-design).

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 26 2011
Added on Sep 28 2011
2 comments
200 views