on 05-02-2016 5:04 PM
Built a graphical CalcView in studio, activated it. (ABC is my package name)
Then went to the reporting tools (ex: Tableau) and tried to connect to the above mentioned CalcView.
Picked schema _SYS_BIC and then searched for the CalcView that I activated.
Saw two results:
1)_SYS_BIC.ABC/CalcView
2) ABC::CalcView
I know we should pick the 1st one (the one with _SYS_BIC) as all the activated column views (in fact all activated objects) reside here in _SYS_BIC schema.
but what I am curious about is the second result ..the one with :: in it (double colons)
What is it? Where is this coming from? Is this the design version of the view?
Any help is greatly appreciated and thanks in advance!
Hello Srinivas,
"ABC:CalcView" is the public synonym generated for your calculation view defined in the repository. It points to the catalog object ("_SYS_BIC"."ABC/CalcView").
You can check it in the Catalog View on DB level. Search for the public synonym in the "Public Synonyms" folder and open the synonym. The properties show you the target.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Adding to the points from Florian, It would be better if you go ahead and use ABC::CalcView
Regards,
Krishna Tangudu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for your response. After reading Florian's and your response , I went and did some reading, watched couple of videos on synonym topic and feeling lot better now. Thanks to both of you.
Follow up question - performance perspective -- is there any performance advantage between ABC::CalcView vs _SYS_BIC.ABC/CalcView?
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.