RE: Database components

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Thu, 12 Jun 2003 14:08:58 -0700
Message-ID: <F001.005B0C0E.20030612135011@fatcity.com>

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).

Received on Thu Jun 12 2003 - 16:08:58 CDT