Solved

Creating view of a table from another user

Posted on 2002-06-03
5
179 Views
Last Modified: 2010-04-01
Hi

i had  a user "sim" representing the main office having following tables
acc_glday,cashes,day_one,day_two andday_sub . for obtaining some consolidated
reports from all branches i had created another user "conso " and created all
the above tables on that user area also.
i am importing data from all branches including the main office  into tables in
user conso.

 i would like to  create a view by the union of tables of user sims and tables
of user conso on the user conso. if i can do taht   it is possible to avoid
importing  data from user sim to user conso and data redundancy can be
eliminated.

please help me for creating such a view of any of above mentioned tables on the
user area conso.


sincerely

rajesh
 
0
Comment
Question by:rajeshnalankal
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 4

Expert Comment

by:pellep
ID: 7053631
what database?
0
 
LVL 4

Expert Comment

by:pellep
ID: 7053632
that is, what type of database system are you using?
0
 

Author Comment

by:rajeshnalankal
ID: 7054074
Hi

sorry for not mentioning full details

i am using oracle database

rajesh
0
 
LVL 4

Expert Comment

by:pellep
ID: 7054176
maybe you should ask this question in the oracle TA instead.
0
 
LVL 5

Accepted Solution

by:
kelfink earned 100 total points
ID: 7055069
Oracle can define both VIEWs and SYNONYMs.

The VIEW you ask about is possible.  Sounds like you want to join tables between the two users.

For example:

CREATE VIEW V_SOME_TABLE_JOINED
SELECT * FROM  SIM.SOMETABLE a, CONSO.MYTABLE b
WHERE a.id = b.some_id ;

Remember that SIM must grant permission to CONSO to read his tables...

SIM>  GRANT SELECT ON SOMETABLE TO CONSO;



0

Featured Post

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Choosing a core focus or particular set of features and options can be tough. To help out, we’re going to highlight a handful of things your business needs on one of your social media pages. In other words, if one of these is missing, you should imp…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question