• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

A few Good questions..

 
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic