v$version - will it show if edition is Standard or Enterprise?
and how do we go about getting (or upgrading to) Enterprise edition if we only have standard?
The first row in v$version will show whether it's standard or enterprise edition.
As for upgrading you simply need to do the following:
1. Take a backup and stop database
2. De-install the standard edition software or install enterprise edition in a new home
3. Modify you "oratab" file to point to the new home
4. Start your database and run "catalog.sql" and "catproc.sql"
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
I'm running 8.1.5 on NT4 . Heres my v$version info ...
Oracle8i Release 184.108.40.206.0 - Production
PL/SQL Release 220.127.116.11.0 - Production
CORE Version 18.104.22.168.0 - Production
TNS for 32-bit Windows: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
oratab? Is that Unix?
I suppose we have to buy Enterprise edition (or at least upgrade our licensing and support)?
oratab is UNIX yes, if itīs windows then you might as well delete the stuffs in registry after uninstallation process
Click Here to Expand Forum to Full Width