Search for a command to run...
I recently tried to user SQL Developer with a schema and found that I could not view packages, procedures or functions. I would get ORA-00942: table or view des not exist. I still don't know why, but granting SELECT_CATALOG_ROLE to the user solved the problem.
Update: I had a similar problem in Oracle Data Miner (Data Mining). I granted unlimited tablespace to the user and the problem went away. It may have been a tablespace issue for SQL Developer as well...
No comments yet. Be the first to comment.
Did I write this? No, not at all. I gave an AI a prompt, had a little back and forth conversation, made a few edits, and, boom, another blob of text, more bits in an unending garbage dump of digital e
A color picker in minutes, using CSS classes you already have.
One File, Every Page
Finding matches in delimited strings and much more...
There are several great blog posts on this topic. In particular, this on from United Codes covers the details of each step. Marwa and I also did an APEX Instant Tip (episode 191) on this topic. This p