Re: How to tell if Partitioning is installed

"Richard Piasecki" <ogo_at_mailcity.com> wrote in message news:0cv4ttkuia4ff6d3olqe3d27ptulbicl0v_at_4ax.com...
> Does anyone know if there is a way to know programmatically (e.g. through
a
> shell script) if the partitioning option is installed? I'm using 8.1.7 on
a
> Sun Solaris 8 system.
>
>
> --- Rich
>

select * from v$option in sql*plus.
sqlplus -s can be used in a filter

Hth,

Sybrand Bakker,
Senior Oracle DBA Received on Sun Oct 21 2001 - 03:33:39 CDT