Home » Server Options » Replication » how to find installed option
how to find installed option [message #75319] Wed, 12 February 2003 00:03 Go to next message
Sahil Patel
Messages: 1
Registered: February 2003
Junior Member
I have to upgrade from 8.1.6 to 8.1.7. Now one of the standard guideline at the time of custom installation of 8.1.7 is
"Make sure you install all of the options you installed with the previous database, assuming you do not want to discontinue use of a particular option"

How do I find out that what all options are installed in my pervious database so that at the time of my new custom installation I can click those options very easily.

I am new at this site and expecting reply asap.

Sahil
Re: how to find installed option [message #75343 is a reply to message #75319] Tue, 18 March 2003 06:56 Go to previous message
Frank Naude
Messages: 4569
Registered: April 1998
Senior Member
Hi,

Connect to SYS AS SYSDBA as issue the following query:

SQL> SELECT * FROM SYS.V_$OPTION;

Best regards.

Frank
Previous Topic: How to link a table from one tablespace to another?
Next Topic: Replication with different oracle versions
Goto Forum:
  


Current Time: Thu Sep 23 07:24:32 CDT 2021