Oracle SQL Developer - ORA-00942

UpdatedDecember 1, 2022

•1 min read

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...

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Using APEX_STRING.SPLIT in SQL

Finding matches in delimited strings and much more...

Mar 15, 20263 min read

How to Run Oracle APEX on your Local Machine

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

Mar 2, 20267 min read

Using Faceted Search in Additional Region Types

Interactive Reports, Interactive Grids, Charts...they all could benefit from faceted search.

Nov 21, 20258 min read

Using Faceted Search in Additional Region Types

Using Declarative APEX REST Data Sources via PL/SQL APIs #JoelKallmanDay

I have written and done several APEX Instant Tips about the topics of using the declarative features of APEX (instead of writing code) and about using APEX REST Data Sources: APEX Instant Tips #180: Deploying APEX applications that include REST Data...

Oct 15, 20255 min read

Using APEX_DEBUG Without an APEX Session

Check out APEX Instant Tips episode 178 for more information on this topic. Code instrumentation is key to developing maintainable and testable applications. The APEX_DEBUG PL/SQL API has everything I need and a lot of features under the covers that ...

Aug 23, 20253 min read

apex_debug

132 posts

Oracle SQL Developer - ORA-00942

Command Palette

Comments

More from this blog