Hello Everyone, We have a form named “LA:SoftwareInstall.” For years we have queried the database using the view name “la_softwareinstall.” Now that view is no longer present. If I look at a list of all our views on the database (Oracle 10.2 db) I see views for the other forms, but nothing resembling “la_softwareinstall.” It is missing in both our test and live databases.
Last year we copied our existing database to a new server, then installed the 7.1 ARS system on top of it. Is it possible that the “la_softwareinstall” view somehow got left behind in the database copy? Is there an easy way to get it back again? I know we could use a complicated "create view" statement directly in Oracle, but would that even be wise? Dwayne Martin James Madison University
