on 07-08-2016 8:29 AM
Hi Guys,
is it possible to
1. save and activate OR
2. redeploy a view
via sql console?
Thanks in advance
Sebastian
Hello Sebastian
SQL Console is used to execute statements and preview the results. Save and activate, Redeployment are done at the view level. May I know why do you want to achieve these functionalities via SQL Console.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Gowthami,
there is a phenomenon that sometimes views are invalidated by an unknown issue.Then, it's possible to identify those views via SQL. Based on that analysis, I would like to redeploy or reactivate them. Therefore i need a command to do that within the SQL console. The goal is to use a script for identification and activation at ones.
Otherwise you are right, i can use the graphical interface but there i need to select every view by its own and activate it afterwards.It would be nice to shorten that process by the explained idea above.
Best regards
Sebastian
Sebastian,
there is no such way to activate from SQL console, as version management of file is not done through SQL console. You can check _SYS_REPO.ACTIVE_OBJECTS or _SYS_REPO.INACTIVE_OBJECTS tables for activae and inactivated object and activate them manually. Below two thread will give you details, related to this topic, which is already discussed.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.