This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes A few Good questions.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "A few Good questions.." Watch "A few Good questions.." New topic

A few Good questions..

Chhaya Dhanani
Ranch Hand

Joined: Apr 11, 2001
Posts: 70
hi all,
i have a couple of questions regarding oracle..
i have two different schemas.
1)can i create a view of the table form one schema into another schema and then update the view so that the underlying table will also be updated?
2)what kind of rights do i have to set to the tables for the above to be true.?
3)can i update the table by updating the view thru a java code when the table is in different schema than then the view?
Thanx in advance,
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17276

1. There are things called db_links.
Here is a link to some examples of using and creating database links. If on that page you scroll up a little bit you will see the CREATE DATABASE LINK command syntax.
(I just couldn't find a good anchor number to use to get you to this part of the page.)
2. No special rights than normal.
3. Not quite sure what youa re asking here, but you could always created stored procedures that would handle this, if you can't directly in Java.
I haven't heard of the ability to create updatable views from java code, but I am not completely experienced enough in that area of Oracle to know if there is.
Hope that helps

Perfect World Programming, LLC - iOS Apps
How to Ask Questions the Smart Way FAQ
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
As far as I know,You can do update throgh a view only if
1.Your view is a simple subset of a single table.
2.All "not null" columns for the table are in the view.
3.The primary key is in the view.
I agree. Here's the link:
subject: A few Good questions..
It's not a secret anymore!