How to check Oracle database version?

So today I needed to check what was my Oracle version because the PARTITION is not working and as far as I understand my version is not compatible with it. Here’s how to do it.

  1. Log in as sysdba
    C:Usersrecon1>sqlplus / as sysdba
  2. Run the following query
     SQL> select * from v$version;
    BANNER
    --------------------------------------------------------------------------------
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
    PL/SQL Release 11.2.0.2.0 - Production
    CORE 11.2.0.2.0 Production
    TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
    NLSRTL Version 11.2.0.2.0 - Production

Sources

  • http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba004.htm#ADMIN11039
  • https://community.oracle.com/message/1199011#1199011

Leave a Comment

Your email address will not be published. Required fields are marked *