I have been learning SQL server and talk about sweet - check out the DTS stuff. Now, when is Oracle going to come out with a tool like that (not like SQL*Loader) that is free and very intuitive and does exactly what you want to do and has an intuitive interface and sets up out-of-the box and is well-integrated with their RDBMS engine. Have I missed that tool somehow?
-----Original Message-----
From: Jose Luis Delgado [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 12, 2003 4:38 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Database components
George:
For Oracle7 up to 8.0:
cd $ORACLE_HOME/orainst
./inspdver
For Oracle 8i and above:
cd $ORACLE_HOME/install
cat unix.rgs
And **explicitly** for:
partitioning option, data mining, etc...
sql> select * from v$option;
HTH
JL
--- "Rusnak, George A. (SEC-Lee) CTR"
<[EMAIL PROTECTED]> wrote:
>
> Group,
> Can someone please give me the steps to produce a
> listing of EE database
> components installed, ie. partitioning option, data
> mining, etc. ???
>
> I need to compare what is installed on two machines.
> Both are 9i, one is
> Solaris and the other is HP.
>
>
> THANKS,
>
> Al Rusnak
> DBA - WEB Team
> 804-734-8371
> Never take life seriously. Nobody gets out alive
> anyway
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Rusnak, George A. (SEC-Lee) CTR
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jose Luis Delgado
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
