aspose file tools*
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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "A few Good questions.." Watch "A few Good questions.." New topic
Author

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,
Chhaya
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

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
Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
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.
Beksy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A few Good questions..