I have an IAL that I want to duplicate in another IFS system. I do not have access to the original source. Does anyone have suggestions how I can extract the IAL and copy it to my other IFS system?
Both are IFS8 running Oracle 12c.
Best answer by CallumW
View original
+15
I use the PL/SQL Developer IDE and I normally access it by typing out the IAL in full and then whilst holding Ctrl, right click the line
If you use a different IDE such as SQL Developer - just perform a google search on how to view the view, there should be some set of instructions on how to do it.
Failing that you can perform an SQL query:
select text from dba_views a where view_name = 'SALES_VALUES_FORECAST_IAL'
+18
Callum’s answer is the correct one. Adding to it…
IFSINFO may not have permission to read the dictionary view DBA_VIEWS, so you can use USER_VIEWS instead while logged in as IFSINFO.
Callum’s first answer provides the sql, complete with the ‘create or replace….’ statement. Not just the ‘select...’
His second answer provides the sql without the ‘create or replace...’ portion.
I found a third one using pl/sql developer. In the views for user IFSINFO, right mouse click on the view you are interested in. Select ‘View Documentation’. It will display the columns followed by the sql statement to create the view.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.