RE: Database components
Hi George, Here's a starting point. For more detail, you can always fire the lovely Installer and click on Installed Products. Lisa Koivu Oracle Database Stressmonkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 (FACD-ELVIS)select * from v$option; PARAMETERVALUE - Partitioning TRUE Objects TRUE Real Application ClustersFALSE Advanced replication TRUE Bit-mapped indexes TRUE Connection multiplexing TRUE Connection pooling TRUE Database queuing TRUE Incremental backup and recovery TRUE Instead-of triggers TRUE Parallel backup and recovery TRUE Parallel execution TRUE Parallel loadTRUE Point-in-time tablespace recoveryTRUE Fine-grained access control TRUE Proxy authentication/authorization TRUE Change Data Capture TRUE Plan Stability TRUE Online Index Build TRUE Coalesce Index TRUE Managed Standby TRUE Materialized view rewriteTRUE Materialized view warehouse refresh TRUE Database resource managerTRUE Spatial TRUE Visual Information Retrieval TRUE Export transportable tablespaces TRUE Transparent Application Failover TRUE Fast-Start Fault RecoveryTRUE Sample Scan TRUE Duplexed backups TRUE Java TRUE OLAP Window FunctionsTRUE Block Media Recovery TRUE Fine-grained AuditingTRUE Application Role TRUE Enterprise User Security TRUE Oracle Data GuardTRUE Oracle Label SecurityFALSE OLAP TRUE Heap segment compression TRUE Join index TRUE Trial Recovery TRUE Oracle Data Mining TRUE Online Redefinition TRUE Streams TRUE File Mapping TRUE 47 rows selected. (FACD-ELVIS) -Original Message- Sent: Thursday, June 12, 2003 2:25 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the
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).
RE: Database components
Title: RE: Database components 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).