File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A few Good questions..

 
Chhaya Dhanani
Ranch Hand
Posts: 70
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17276
6
IntelliJ IDE Mac Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Beksy Kurian
Ranch Hand
Posts: 254
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic