Oracle Ride
  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
    • Registration
    • Feedback
  • Contact Me

ORA-02030

Database ERRORS

ORA-02030: can only select from fixed tables/views

When we Grant the Select privilege on a V$ view we will get an ora-02030 error. As ORA-02030 says, that we can only select from fixed tables/views, which means V$INSTANCE is not a table or view. We know that actual view created on the dynamic performance table that is V_$. The Read more…

By Ahmad, 2 years2 years ago
Oracle ACE
Oracle ACE Associate
Awarded Top 60 Oracle Blogs
Recent Posts
  • Live Online Session 26th February 2023 Sunday
  • ORA-12520: TNS listener could not find available handler for requested type of server
  • Oracle GoldenGate 21c(21.3.0) is out for use!
Categories
  • Career (1)
  • Cloud (7)
  • Data Guard (3)
  • Database (104)
  • ERRORS (6)
  • GoldenGate (11)
  • Interview Questions (44)
  • Online Event (1)
  • Oracle12c (7)
  • Oracle19c (7)
  • Oracle20c (2)
  • Oracle21c (5)
  • Performance Tuning (4)
  • Personal (2)
  • RAC (6)
  • Webinars & Presentations (1)

Riaz Ahmad Ansari is an Oracle Consultant, Speaker, Blogger, YouTuber & Mentor.

He is famous for Ahmad’s nickname in the IT industry.

He has many years of experience as a production Oracle DBA managing all operating system based Oracle Databases.

He started working with Oracle Database starting from Oracle 9i to 10g/11g/12c18c/19c.

He has hands-on experience in real-world Production environments.

He is skilled with Oracle technologies such as Core DBA work, Data Guard, RMAN, Backup & Recovery, RAC, Cloud Control, and Performance Tuning.

  • Email
    ahmad@oracleride.com
  • Phone
    +91 9648108988
Follow Me
  • whatsapp
  • linkedin
  • facebook
  • twitter
  • youtube

Copyright ©️ 2020 OracleRide. All Rights Reserved.


  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
  • Contact Me
Developed and Maintained by Demunix