Re: check original version of database

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 Jan 2005 05:31:14 -0800
Message-ID: <1104759074.591749.289710@z14g2000cwz.googlegroups.com>

Major releases of Oracle involve the installation of completely new binaries so even if you started with version 7 and upgraded to 8 and then to 9 you have the version 9 binaries installed.

Log onto the instance and read the SQLPlus logon information. Then query the dictionary view, product_component_version.

This will tell you what version of Oracle you are currently running no matter what versions were initially installed.

HTH -- Mark D Powell -- Received on Mon Jan 03 2005 - 07:31:14 CST