I am trying to view the script behind a View created in our Oracle database. I keep getting the following error:
“The requested database object information has not been retrieved. Object information is retrieved by SYS.DBMS_METADATA. Check to see that you have privileges for this package.”
I’ve been told that this has to be caused by some sort of setting in TOAD because if a different tool is used to access the database with the same credentials/authentication, there is no issue. Any ideas?