Here is the query to check what is the Database version
Connect as sys/pwd@dbname as sysdba
select username,account_status,default_tablespace,temporary_tablespace,created
from dba_users
Sample Output
PRODUCT VERSION STATUS
NLSRTL 10.2.0.1.0 Production
Oracle Database 10g Enterprise Edition 10.2.0.1.0 Prod
PL/SQL 10.2.0.1.0 Production
TNS for Linux: 10.2.0.1.0 Production
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment