Re:Named users!
YES, minus SYS, SYSTEM, OUTLN, etc... Dick Goulet Reply Separator Author: O'Neill; Sean [EMAIL PROTECTED] Date: 10/21/2002 4:58 AM Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
STANDBY fle status RECOVER
Hi I have data guard setup.When I run select file#,status,enabled,checkpoint_change#,checkpoint_time,name from v$datafile on primary site its looks ok.But on standby site some of datafiles are showing status RECOVER. Log shipping and dataguard log is showing ok.Nothing on alert log either of primary or standby.What could be reason?How to fix this problem if this is? Thx -Seema _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Actual list of supported/desupported versions of Oracle
Bob - I don't feel Oracle makes it easy. They keep changing the location and format. On Metalink, have you clicked on the tab on the left side labeled Certify Availability? Once you are in that section, there are tabs at the top for Product Availability and Desupport Notices. I don't think the finite list of supported/desupported versions exists, but you can get the information you need a piece at a time and gradually build your list. Does that meet your requirements? Yes, for sure they certainly do not make it easy. much akin to using the space shuttle to cross the street) I did manage to find the info though with your guys suggestions. Interestingly enough I entered desupported, desupported versions, version support all with no results... sigh What perplexes me now is the fact that Oracle Support told me on the phone that they don't support any version less than 8.1.7 on WIN2K server... I have 7.3.4, 8.0.5, 8.1.6.3 and now 8.1.7 from NT40 to WIN2K From the documents on the web(below) it appears all platforms are treated equal, so?? I suppose I have to propose that question to the support tech again when I get them on the phone, now that I have the actual documents from their website. Below is a clipping from pertaining to the versions Im interested in. Thanks to all for pointing me in the right direction.. bob # Product:Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition Product Version(s): 7.3.4 Platform(s):Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-DEC-2000 Extended Assistance Support (EAS): 31-DEC-2003 Extended Maintenance Support (EMS): 31-DEC-2002 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 7.3.4 on the following platform(s): ALL Platforms, effective 31-DEC-2000. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.0.6 or Oracle8i on any Oracle certified platform. EAS will be provided until 31-DEC-2003, if the customer has a current support contract in place. Product Version(s): 8.0.5 Platform(s):Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 30-JUN-2000 Extended Assistance Support (EAS): 30-JUN-2003 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 8.0.5 on the following platform(s): ALL Platforms, effective 30-JUN-2000. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.0.6 or Oracle8i 8.1.5 on any Oracle certified platform. EAS will be provided until 30-JUN-2003, if the customer has a current support contract in place. ## Product Version(s): 8.1.6 (8i) Platform(s):Platform Version(s): ALL Platforms ALL Desupport End Dates: Error Correction Support (ECS): 31-OCT-2001 Extended Assistance Support (EAS): 31-OCT-2004 Product Obsolescence / Desupport Information: Oracle Corporation announces the end of Error Correction Support for Oracle Server - Client, Enterprise Edition, Parallel Server, Personal Edition, RAC Standard Edition version(s) 8.1.6 (8i) on the following platform(s): ALL Platforms, effective 31-OCT-2001. Oracle Corporation recommends customers upgrade/migrate to the following as soon as possible to maintain the highest level of support: Oracle Server - Client, Enterprise Edition, Personal Edition Standard Edition/Workgroup Server 8.1.7 (8i) on any Oracle certified platform. EAS will be provided until 31-OCT-2004, if the customer has a current support contract in place. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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
Re:RE: Named users!
I sure have! :( Dick Goulet Reply Separator Author: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 10/21/2002 10:48 AM I have heard rumors that Oracle has tried out this interpretation on some clients. I have also heard some people were a bit outraged. Have you known anyone that paid up based on this interpretation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Oracle now say that if the database interacts with any other system that has users these must be counted too ! e.g. You have a database that runs a warehouse management system. If this receives orders from another ERP type system via an interface and this system can take internet orders, even if it has its own database license, then either you count all customers or use processor licensing. DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 21/10/2002 15:54 Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Named users! Sean - I think you are recalling the old Concurrent Users. A named user is defined as follows: Named User: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted as a Named User in addition to all individuals authorized to use the programs, if such devices can access the programs. If multiplexing hardware or software (e.g., a TAP monitor or a Web server product) is used, this number must be measured at the multiplexing front end. I feel a good measure today is that anyone who can even contemplate interacting with your database qualifies as a named user. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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
RE: Named users!
Yes, I do. This ploy worked on some of the large corporations in the U.S. And I happen to know this worked on at least one large financial institution. RWB DENNIS WILLIAMS [EMAIL PROTECTED]@fatcity.com on 10/21/2002 01:48:54 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: I have heard rumors that Oracle has tried out this interpretation on some clients. I have also heard some people were a bit outraged. Have you known anyone that paid up based on this interpretation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Oracle now say that if the database interacts with any other system that has users these must be counted too ! e.g. You have a database that runs a warehouse management system. If this receives orders from another ERP type system via an interface and this system can take internet orders, even if it has its own database license, then either you count all customers or use processor licensing. DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 21/10/2002 15:54 Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Named users! Sean - I think you are recalling the old Concurrent Users. A named user is defined as follows: Named User: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted as a Named User in addition to all individuals authorized to use the programs, if such devices can access the programs. If multiplexing hardware or software (e.g., a TAP monitor or a Web server product) is used, this number must be measured at the multiplexing front end. I feel a good measure today is that anyone who can even contemplate interacting with your database qualifies as a named user. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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
RE: Anybody There?
I am here... where is there? Regards, Pat. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Anybody There?
Previous mail, sent by me, was a mistake... Should have replied to someone else... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 18:38 I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: Named users!
I have heard rumors that Oracle has tried out this interpretation on some clients. I have also heard some people were a bit outraged. Have you known anyone that paid up based on this interpretation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 10:31 AM To: Multiple recipients of list ORACLE-L Oracle now say that if the database interacts with any other system that has users these must be counted too ! e.g. You have a database that runs a warehouse management system. If this receives orders from another ERP type system via an interface and this system can take internet orders, even if it has its own database license, then either you count all customers or use processor licensing. DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 21/10/2002 15:54 Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Named users! Sean - I think you are recalling the old Concurrent Users. A named user is defined as follows: Named User: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted as a Named User in addition to all individuals authorized to use the programs, if such devices can access the programs. If multiplexing hardware or software (e.g., a TAP monitor or a Web server product) is used, this number must be measured at the multiplexing front end. I feel a good measure today is that anyone who can even contemplate interacting with your database qualifies as a named user. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Anybody There?
Pa napisi adresu ondfa na koju da posaljem! :) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 18:38 I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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: services on windows?????
Not exactly. Someone else has already pointed out that registry entries can be created to gracefully shutdown the database: Doc ID 136214.1 If these are not setup properly, then stopping the services without first shutting down the database is actually harsher than a shutdown abort. This is also detailed somewhere on MetaLink, but I don't have the doc #. Jared Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/21/2002 08:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: services on windows? If you stop the service you perform shutdown abort which is not recommended for cold backup. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 4:19 PM Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: is this block cleanout ?
MetaLink document 40689.1 contains a very nice description of delayed block cleanout, and walks the reader through an example. Jared Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/19/2002 08:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: is this block cleanout ? Stephane, The db version in question is 7.3.2. And as of 7.3 the init parameter, delayed_logging_block_cleanouts, defaults to TRUE (for OPS and non-OPS). From my understanding of the delayed block cleanout, when oracle commits a transaction the blocks that it changed are not immediately marked with the commit time. The change to blocks can be due to insert, update or delete. However, if those blocks were still in the buffer cache, the cleanout will take place immediately and there won't be any disk i/o for the cleanout. If select count(*) is causing an FTS, then the changed blocks that are not in the buffer cache may be getting cleaned. If there is no FTS, then there is something else going on And that's why I said 'sounds about right.' Hopefully tracing the session may reveal what's going on... Regards, - Kirti -Original Message- Sent: Saturday, October 19, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Deshpande, Kirti wrote: That's sounds about right... - Kirti -Original Message- Sent: Saturday, October 19, 2002 3:48 AM To: Multiple recipients of list ORACLE-L when i do a count(*) an a 1.2GB table, just after an app finishes inserting 20 million records i can see from iostat that, that disk is being read as well as written to !!! the only reason i can think of WRITES being performed while being READ is the block cleanout is being performed by the count(*) !! i would appreciate if anyone could explain further ! regards PS: 7.3.2 on AIX, the file is raw and async_io is true Kirti, This is also what I thought, but wouldn't a 'count(*)' just use the primary key? (Unless it is a 1.2 G unindexed table). Morover, in my mind a block cleanout is associated with a delete, not an insert. Might it be say the cleanout of temporary segments after say a direct load ? Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Can 9iAS Rel2 still do SSLv2 40bit encryption?
Hi We have 9iAS Rel.1 running 40-bit and 128-bit encryption. We are migrating to Release2 and I am wondering if it will still allow 40-bit. The security guide says: Clients can only connect with one of the specified protocols: SSLv3 - SSL version 3.0 or All - SSL version 3.0 and any other version supported by Oracle products. What do they mean by any other version supported? Are they just leaving the door open for SSLv4? Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben 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: Anybody There?
Some may not be all there :-) Go Giants! -Original Message- Sent: Monday, October 21, 2002 11:03 AM To: Multiple recipients of list ORACLE-L We're still here. -Original Message- Sent: Monday, October 21, 2002 11:38 AM To: Multiple recipients of list ORACLE-L I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
9i external tables question
List, In the 4th Qtr 2002 Select Journal magazine there is an interesting article by Robert G.Freeman of this list. Congratulations on being published again and helping the DBA's of the world increase their knowledge. The article talks about 9i external tables and it also creates a few questions about using external tables. Being a DBA I always try to make life easier for myself so I can use my time more productively. The article describes in detail the method of creating external tables and populating them from the alert_log. With the tables created you can access them from the database after they are populated with a load procedure. The updates to the external table are periodically made with updates into a temp table controlled by a scheduled job. While this method would suffice for keeping a copy of the alert_log in the database it is only up to date as the job that loads the temp and ultimately the external table. Working with different OS's can get confusing at times as the structure and commands can be different and confusing. It would be much nicer to create an external table that was actually the real alert_log that was being used by Oracle then you could access the database with the standard SQLPLUS command and select from the alert_log with any condition you desire. That way you would not have to remember all of the different locations and commands the view the alert_logs on different servers. The conclusions section of the article is a key part and informs us that this is just the beginning of the possibilities for external tables and encourages us to experiment on our own. When I get through with the latest server migration and I get 9i loaded in my test box I plan to experiment a lot. Thanks for the article, Ron Rogers DBA OCP ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: How to get the count of all tables using dbms_sql
If the database is 8i+, you can try 'EXECUTE IMMEDIATE' command. Does make life somewhat simpler. Regards, Charu -Original Message- Ling Catherine (CSC) Sent: Thursday, October 17, 2002 3:25 PM To: Multiple recipients of list ORACLE-L Hi, I've found the answer. DECLARE countval NUMBER; curidBINARY_INTEGER; retval NUMBER; BEGIN for i in (select OWNER,TABLE_NAME from DBA_TABLES WHERE ROWNUM) loop curid:= dbms_sql.open_cursor; dbms_sql.parse( curid, 'BEGIN SELECT count(*) INTO :cntval FROM '|| i.owner||'.'||i.table_name||'; END;', dbms_sql.v7 ); dbms_sql.bind_variable( curid, 'cntval', countval ); retval:= dbms_sql.execute( curid ); dbms_sql.variable_value( curid, 'cntval', countval ); dbms_sql.close_cursor( curid ); dbms_output.put_line( 'Count is:= ' || countval ); end loop; END; / Regds, New Bee -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Thursday, October 17, 2002 4:12 PM To: '[EMAIL PROTECTED]' Subject:How to get the count of all tables using dbms_sql Hi, I need to insert the total number of records all the tables into the table, MIGRATION_TABLE. I want to use the How do I obtain the count(*) into a variable in dbms_sql.parse(cid, 'SELECT COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7); ? TIA Declare cid INTEGER; BEGIN for i in (select OWNER,TABLE_NAME from DBA_TABLES) loop -- Open new cursor and return cursor ID. cid := dbms_sql.open_cursor; /* Parse and immediately execute dynamic SQL statement built by concatenating table name to DROP TABLE command. (Unlike DML statements, DDL statements are executed at parse time.) */ dbms_sql.parse(cid, 'SELECT COUNT(*) FROM ' ||i.owner||'.'||i.table_name, dbms_sql.v7); /* Close cursor. */ dbms_sql.close_cursor(cid); end loop; EXCEPTION /* If an exception is raised, close cursor before exiting. */ WHEN OTHERS THEN dbms_sql.close_cursor(cid); END; Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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). * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi 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: 9i external tables question
Title: RE: 9i external tables question I implemented this a couple of months ago. One part of db is we send out a 'heartbeat' to our external customers. To see when the 'heartbeat' goes out, I made available the external log file as a table and wrote code that measures the time between to successive heartbeats as a view. Internal customers are happy, external customers are happy, and we don't get bugged about the times anymore. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Anybody There?
We're still here. -Original Message- Sent: Monday, October 21, 2002 11:38 AM To: Multiple recipients of list ORACLE-L I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: services on windows?????
James and list: You can backup the database without stopping the services. Just shut it down. If you are going to attempt a restore and blow away the control files, etc., then by all means stop the services first. The services would need the control files to be present if it is to be restarted or the registry would have to be changed. A simple rule would be to stop the services if a restore needed to be done or if the configuration and control files were going to be wiped. Otherwise leave the services up. Now can we move on? I think this issue has been debated enough. RWB James Damiano [EMAIL PROTECTED]@fatcity.com on 10/21/2002 10:24:46 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Dear List, I had a situation on a lone Windows/NT system a couple of years ago, where I had installed 8i and was testing a number of facilities prior to going online with an application. Since I wasn't familiar with NT, I played around a bit, the final step of which was to test recovery with a cold backup. So I did a shutdown immediate and took a cold backup of the database (while having left the Oracle services up). Frankly I didn't **purposely** leave the services up because it didn't enter my mind that I had to do so or not. All I know is that when I blew away the existing database control, data, and log files, and restored them with the cold backup for a test of recovery, the database would not start back up. (I didn't note what the specific error messages were because I was in a big hurry at the time and could't mess around with it.) I DO know that I was stunned at this because on UNIX and Netware, I never had such a thing occur. So, I rebuilt the database from scratch, reloaded, and then tried the recovery scenario again. This time I did the shutdown immediate and then shut down the Windows Oracle service for the database before doing the cold backup, took the backup, blew away the existing database, restored the cold backup database files, and restarted the database successfully without incident. Having been in a hurry, maybe originally I did something illogical or idiotic which was the reason for my obtaining the results I did (when in reality it had nothing to do with Window services, I don't know.) I always meant to go back and revisit that whole issue but haven't had the time or inclination I guess. Given what is being said in this discussion, I would like to do so in a methodical manner to see if I can get down to the fact of the matter. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Anybody There?
I haven't recieved anything from this list since friday evening. I know there usually isn't as much traffic on the weekend, but there is some. And there has been nothing at all this morning either. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry 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: services on windows?????
No, Even under Oracle8 it's enough to shutdown the database to do cold backup. Services themselves, when the database is shutdown, do not hold on to the database files. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 10:43 AM It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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: services on windows?????
Not necessarily, shutdown mode (when you stop services)depends on registry setting: ORA_SID_SHUTDOWNTYPE I - for immediate a - for abort Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 11:08 AM Subject: Re: services on windows? If you stop the service you perform shutdown abort which is not recommended for cold backup. Yechiel AdarMehish - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 4:19 PM Subject: Re: services on windows? Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe
Re: Installation
On Mon, Oct 21, 2002 at 02:38:22AM -0800, Santosh Varma wrote: I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief -- I smell Darwin award! http://www.darwinawards.com/ === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: services on windows?????
Not sure, but here we do net stop service_name_goes_here_without_brackets and net start xxx. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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: Installation
Santosh - Let me understand . . . Oracle is already installed and in production at this site? Are you installing a commercial product? Then you should probably follow the instructions that come with the product. If it is a quality product with quality instructions, then tablespaces, etc. will be dealt with. If this is a production site, you should definitely install this on their test system first, probably after backing up the test system. Am I missing something here with your situation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hello all, I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: services on windows?????
Dear List, I had a situation on a lone Windows/NT system a couple of years ago, where I had installed 8i and was testing a number of facilities prior to going online with an application. Since I wasn't familiar with NT, I played around a bit, the final step of which was to test recovery with a cold backup. So I did a shutdown immediate and took a cold backup of the database (while having left the Oracle services up). Frankly I didn't **purposely** leave the services up because it didn't enter my mind that I had to do so or not. All I know is that when I blew away the existing database control, data, and log files, and restored them with the cold backup for a test of recovery, the database would not start back up. (I didn't note what the specific error messages were because I was in a big hurry at the time and could't mess around with it.) I DO know that I was stunned at this because on UNIX and Netware, I never had such a thing occur. So, I rebuilt the database from scratch, reloaded, and then tried the recovery scenario again. This time I did the shutdown immediate and then shut down the Windows Oracle service for the database before doing the cold backup, took the backup, blew away the existing database, restored the cold backup database files, and restarted the database successfully without incident. Having been in a hurry, maybe originally I did something illogical or idiotic which was the reason for my obtaining the results I did (when in reality it had nothing to do with Window services, I don't know.) I always meant to go back and revisit that whole issue but haven't had the time or inclination I guess. Given what is being said in this discussion, I would like to do so in a methodical manner to see if I can get down to the fact of the matter. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano 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: Named users!
Seán, I don't believe that is the situation. We have named users license for the development server where there are 3 developers and 2 testers, But the dba_users lists all 250 users that are on the production system. Each user can have a different role or table access allowed and must be tested properly. It comes down to a matter of integrity and honesty when dealing with the licenses. 10 Named users allows up to 10 people to use the product legally. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/21/02 08:58AM Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: services on windows?????
I use Oracle 7.3.4, 8.0.5 and 8.1.7 on windoze and none of them require that the windoze service to be stopped. You can but it is not necessary. Dave -Original Message- Sent: Monday, October 21, 2002 9:44 AM To: Multiple recipients of list ORACLE-L It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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: services on windows?????
It seems I was completely wrong, is it the same as for Oracle 8 and 8i? Last time I've worked with Windows it was on Oracle 8 and I thought that you had to stop the services because Windows was not letting you copy the database files. --- Igor Neyman [EMAIL PROTECTED] a écrit : Joe, You can stop the services, which should shutdown the database (for cold backup). But, that's not the only option. You can leave services running, and just shutdown the database (using svrmgrl, or sqlplus), and then do the cold backup. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Monday, October 21, 2002 9:28 AM Subject: services on windows? My partner sent me a question about services on windows. when doing a cold backup is it necessary to shutdown the windows services?, I have no idea as I've not had the nightmare of dealing with oracle on windoze. joe = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Actual list of supported/desupported versions of Oracle
Bob - I don't feel Oracle makes it easy. They keep changing the location and format. On Metalink, have you clicked on the tab on the left side labeled Certify Availability? Once you are in that section, there are tabs at the top for Product Availability and Desupport Notices. I don't think the finite list of supported/desupported versions exists, but you can get the information you need a piece at a time and gradually build your list. Does that meet your requirements? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 9:04 AM To: Multiple recipients of list ORACLE-L All Ive been scowering the web and metalink to find a finite list of supported /desupported versions Ive found one list on metalink bit couldn't bookmark the page and cant find it again. All the websites I have found have just bits and pieces Is there a known list of supported/desupported database versions Operating Systems? Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: How to find an object associated with a file # and block #
I got it!!! V$datafile and dba_extents will get what I need. Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: How to find an object associated with a file # and block # om 10/21/2002 09:54 AM Please respond to ORACLE-L Hi, Can someone tell me how I can find which object resides in a given file # and block #? This is from a trace file. I do not have a rowid to use dbms_rowid. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Named users!
Sean - I think you are recalling the old Concurrent Users. A named user is defined as follows: Named User: is defined as an individual authorized by you to use the programs which are installed on a single server or multiple servers, regardless of whether the individual is actively using the programs at any given time. A non human operated device will be counted as a Named User in addition to all individuals authorized to use the programs, if such devices can access the programs. If multiplexing hardware or software (e.g., a TAP monitor or a Web server product) is used, this number must be measured at the multiplexing front end. I feel a good measure today is that anyone who can even contemplate interacting with your database qualifies as a named user. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Not a particularily technical query but a rather practical one. With a named user licence is one user taken per each username returned from a select username from dba_users? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Actual list of supported/desupported versions of Oracle
Hi, I am not sure if it is a definitive list but on the left side of MetaLink is a button Certify and Availability. It should provide you with all info you need. Certify - Oracle's Certification Matrices Welcome to Certify! This application provides product certification information, including patches and workarounds, for Oracle and non-Oracle products. For assistance with this application, please review our online documentation. NEW! Desupport Notices and Product Availability are now part of Certify. To view Desupport Notices, select 1. View Certifications by Product then select Desupport Advisories and Notices. Rick Bob Metelsky bmetelsky@cps To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 92.com cc: Sent by: Subject: Actual list of supported/desupported versions of Oracle [EMAIL PROTECTED] om 10/21/2002 10:04 AM Please respond to ORACLE-L All Ive been scowering the web and metalink to find a finite list of supported /desupported versions Ive found one list on metalink bit couldn't bookmark the page and cant find it again. All the websites I have found have just bits and pieces Is there a known list of supported/desupported database versions Operating Systems? Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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).
oraperf comment
An recent oraperf report included the comment: Never split index and data files to different sets of disks. It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word Never inappropriate here? Maybe this is their way of saying don't use old technology. Is there some other reason I am missing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: is this block cleanout ?
Rahul: If you're working under Oracle 7.3 and delayed_logging_block_cleanouts=TRUE (default), the block cleanouts will be delayed until another transaction modifies the blocks (when the block is required in current mode again). A simple select will not force the cleanout. If you set delayed_logging_block_cleanouts=FALSE (default in Oracle 8), a select (of course you'll have to force a FTS) will do the cleanouts. Please correct me if I'm wrong. HTH Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 7:18 AM list / Gopal, this is not a direct load, the app does normal insert .. 20+ million of them !! i checked the block cleanout parameter .. and it does default to TRUE in verion 7.3+ now.. .can turning this parameter to FALSE will speed up the FTS after the insert.. but then the inserts will take longer !! right ? because each insert will do the cleanout too .. -- From: K Gopalakrishnan[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 10:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: is this block cleanout ? Stephane: INSERTs certainly associated with block cleanout. But the issue here Rahul is doing a Direct load and this does not work as expected in earlier versions (7.3 and below). They do not use ITLs as in the regular inserts and there used be some bugs in 7.x versions were ITLs are not used in regular fashion, and this results in incorrect count(*) during the direct loads (something similar to Dirty read). These bugs are fixed in 8i and above versions where Direct inserts are also behave like regular inserts. But in any case Inserts are also associated with block cleanouts. Best Regards, K Gopalakrishnan -Original Message- Faroult Sent: Saturday, October 19, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Deshpande, Kirti wrote: That's sounds about right... - Kirti -Original Message- Sent: Saturday, October 19, 2002 3:48 AM To: Multiple recipients of list ORACLE-L when i do a count(*) an a 1.2GB table, just after an app finishes inserting 20 million records i can see from iostat that, that disk is being read as well as written to !!! the only reason i can think of WRITES being performed while being READ is the block cleanout is being performed by the count(*) !! i would appreciate if anyone could explain further ! regards PS: 7.3.2 on AIX, the file is raw and async_io is true Kirti, This is also what I thought, but wouldn't a 'count(*)' just use the primary key? (Unless it is a 1.2 G unindexed table). Morover, in my mind a block cleanout is associated with a delete, not an insert. Might it be say the cleanout of temporary segments after say a direct load ? Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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
What is wrong with this package? Pls. help
When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile package body we are getting the error 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a package specification and must be defined in the package body Package: CREATE OR REPLACE PACKAGE P1 is msg_g number(3); function check_OK (n1 in number) return number; procedure test; end p1; create or replace package body p1 as function check_ok (nn in number) return number IS KK number; BEGIN KK := msg_g * nn; return KK; end check_ok; procedure test as v1 number; begin null; end test; end p1; / Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Record count within a procedure
Within an update or load procedure, is there any way to return the transaction count for the number of rows affected? Kind of like the Feedback / NoFeedback option of SQL*PLUS? Thanks! R. Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: CodeNotes for Oracle9i...
I have an odd question about these on-line books. Can I copy-and-paste the text? Like many of you, I seem to end up with long commutes (why are the best jobs never in your neighborhood?). I find listening to books on CD to be a better use of time than reading bumper stickers. Nobody ever seems to issue Oracle books on audio. So I got a text-to-voice program, and it works pretty good to create an audio version of a book. But many of these eBooks zealously protect their text and prevent you from doing copy-and-paste on the text. Fortunately Oracle makes their books readily available. Any ideas are welcome. And my apologies to the authors on the list that are going he wants to do WHAT with my book!!. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennnis Did you get any more info re books on tape? Id be very interestd in audio documentation ;-) I have a boring 1 hour ride each direction Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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).
logoff trigger
Hello, We are on 8.1.7.4.0 (on Solaris), and are having a problem with a logoff trigger and ORA-00164: autonomous transaction disallowed within distributed transaction. The logoff trigger is defined as: CREATE OR REPLACE TRIGGER get_logoff_stats_trg BEFORE LOGOFF ON DATABASE BEGIN capture_session_stats_prc; END; The purpose of the procedure called by the trigger is to capture session stats and commit them to a table, so the procedure is defined as an autonomous transaction; removing the autonomous transaction pragma results in: ORA-00604: error occurred at recursive SQL level 1 ORA-04092: cannot ROLLBACK in a trigger ORA-06512: at CAPTURE_SESSION_STATS_PRC, line 116 ORA-04092: cannot COMMIT in a trigger Most of our users only encounter this error when executing some SELECT which involves a reference to a database link, which apparently qualifies as a distributed transaction. Anyway, the SELECT executes successfully, but we fail to capture their session stats upon exit. The suggested oerr action for ora-164 is to rollback or commit before calling the autonomous transaction pragma; but Oracle does not allow a rollback or commit in the trigger which calls the autonomous transaction procedure. An exception handler doesn't seem to catch an ora-00164 error. (Anyone know why? I thought all ORA- errors could be captured by exception handlers.) ORA-00164 is fixed in Oracle9i (actually, Oracle says this is not a bug, but a feature that was changed, not fixed), but we can't upgrade to 9i because some of our third-party tools are not yet compatible. The only thing I can think of is to ask users to do a commit or rollback in their sessions just before exiting if they referenced a db link. I know this isn't practical. Does anyone have a better suggestion? As always, many thanx to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: What is wrong with this package? Pls. help
Easy one. The function declaration does not match between the spec and the body. function check_OK (n1 in number) function check_ok (nn in number) Argument names must be the same. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] To: [EMAIL PROTECTED] 10/21/2002 01:43 cc: PM Subject: What is wrong with this package? Pls. help Please respond to ORACLE-L When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile package body we are getting the error 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a package specification and must be defined in the package body Package: CREATE OR REPLACE PACKAGE P1 is msg_g number(3); function check_OK (n1 in number) return number; procedure test; end p1; create or replace package body p1 as function check_ok (nn in number) return number IS KK number; BEGIN KK := msg_g * nn; return KK; end check_ok; procedure test as v1 number; begin null; end test; end p1; / Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas 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: What is wrong with this package? Pls. help
Rao, You've defined the package to use n1 as a parameter to CHECK_OK, but nn in the body. Make them match and all should be well. HTH! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:maheswara.rao;sungard.com] Sent: Monday, October 21, 2002 3:43 PM To: Multiple recipients of list ORACLE-L Subject: What is wrong with this package? Pls. help When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile package body we are getting the error 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a package specification and must be defined in the package body Package: CREATE OR REPLACE PACKAGE P1 is msg_g number(3); function check_OK (n1 in number) return number; procedure test; end p1; create or replace package body p1 as function check_ok (nn in number) return number IS KK number; BEGIN KK := msg_g * nn; return KK; end check_ok; procedure test as v1 number; begin null; end test; end p1; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: What is wrong with this package? Pls. help
[EMAIL PROTECTED] wrote: When we compile this package body, we are getting the error - PLS - 00323. Please help. Platform: Solaris 7. Oracle 8.1.6. Package is getting created without any errors. When we try to compile package body we are getting the error 3/12 PLS-00323: subprogram or cursor 'CHECK_OK' is declared in a package specification and must be defined in the package body Package: CREATE OR REPLACE PACKAGE P1 is msg_g number(3); function check_OK (n1 in number) return number; procedure test; end p1; create or replace package body p1 as function check_ok (nn in number) return number IS KK number; BEGIN KK := msg_g * nn; return KK; end check_ok; procedure test as v1 number; begin null; end test; end p1; / Thanks, Rao -- Rao, Replace n1 with nn in the package part and it will work like a charm. PL/SQL is _very_ stupid and prameters must bear the same names in specifications and actual declaration, even if doesn't make much sense. I always use cut-and-paste :-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).
trigger - need help writing
When detail_comments in the testable is inserted or updated too then I want it to update the various_comments column which is in the same table (testtable). What would be the most efficient way to write the trigger to do this? CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE AFTER INSERT OR UPDATE ON TESTTABLE FOR EACH ROW ? UPDATE :NEW.VARIOUS_COMMENTS ..??? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon 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: is this block cleanout ?
Please read MetaLink document # 40689.1 Jared dcutrone [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/21/2002 02:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: is this block cleanout ? Rahul: If you're working under Oracle 7.3 and delayed_logging_block_cleanouts=TRUE (default), the block cleanouts will be delayed until another transaction modifies the blocks (when the block is required in current mode again). A simple select will not force the cleanout. If you set delayed_logging_block_cleanouts=FALSE (default in Oracle 8), a select (of course you'll have to force a FTS) will do the cleanouts. Please correct me if I'm wrong. HTH Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 21, 2002 7:18 AM list / Gopal, this is not a direct load, the app does normal insert .. 20+ million of them !! i checked the block cleanout parameter .. and it does default to TRUE in verion 7.3+ now.. .can turning this parameter to FALSE will speed up the FTS after the insert.. but then the inserts will take longer !! right ? because each insert will do the cleanout too .. -- From: K Gopalakrishnan[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 10:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: is this block cleanout ? Stephane: INSERTs certainly associated with block cleanout. But the issue here Rahul is doing a Direct load and this does not work as expected in earlier versions (7.3 and below). They do not use ITLs as in the regular inserts and there used be some bugs in 7.x versions were ITLs are not used in regular fashion, and this results in incorrect count(*) during the direct loads (something similar to Dirty read). These bugs are fixed in 8i and above versions where Direct inserts are also behave like regular inserts. But in any case Inserts are also associated with block cleanouts. Best Regards, K Gopalakrishnan -Original Message- Faroult Sent: Saturday, October 19, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Deshpande, Kirti wrote: That's sounds about right... - Kirti -Original Message- Sent: Saturday, October 19, 2002 3:48 AM To: Multiple recipients of list ORACLE-L when i do a count(*) an a 1.2GB table, just after an app finishes inserting 20 million records i can see from iostat that, that disk is being read as well as written to !!! the only reason i can think of WRITES being performed while being READ is the block cleanout is being performed by the count(*) !! i would appreciate if anyone could explain further ! regards PS: 7.3.2 on AIX, the file is raw and async_io is true Kirti, This is also what I thought, but wouldn't a 'count(*)' just use the primary key? (Unless it is a 1.2 G unindexed table). Morover, in my mind a block cleanout is associated with a delete, not an insert. Might it be say the cleanout of temporary segments after say a direct load ? Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: oraperf comment
Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of "parallelization" in "range-scan" operations, but there is no evidence that this is happening. For example, while performing an indexed range-scan,if we wanted to read a batch of index entries from the index "leaf blocks" and submit a list of I/O requests for data blocks on the corresponding table, we could do so. However, when I've performed "truss" operations on an Oracle server process performing such a range-scan operation (at least through Oracle8i), I've not seen this happening. Purely generic "read()" operations, one at a time, sequentially... --- The only real advantages of separating tables from indexes into different tablespaces are: different recoverability requirements indexes can be rebuilt instead of restored data(tables and clusters)must be restored -- cannot be "rebuilt" from anything different types of I/O requests indexes are predominantly accessed using single-block, random read I/O (i.e. UNIQUE scans, RANGE scans, FULL scans) relatively seldom are accessed with multi-block sequentially-accessedread I/O (i.e. FAST FULL scans) while tables are often accessed with a mix of the two types of I/O, depending on the application OLTP usually has heavier single-block, random read I/O due to heavy use of indexes DW usually has heavier multi-block, sequentially-accessed read I/O due to heavy use of FULL table scans may be advantages from this inOracle9i where different blocksizes are possible for different tablespaces These last points are related to performance, but not in the sense that the mythical"conventional wisdom" dictates... Hope this helps... -Tim - Original Message - From: "Ray Stell" [EMAIL PROTECTED] To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, October 21, 2002 2:43 PM Subject: oraperf comment An recent oraperf report included the comment: "Never split index and data files to different sets of disks." It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word "Never" inappropriate here? Maybe this is their way of saying don't use old technology. Is there some other reason I am missing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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: CodeNotes for Oracle9i...
Bob Thanks for asking. No, most of the replies were along the lines that I'd be less of a road hazard were I drunk with a cell phone in each ear. But knowing someone else is interested is encouraging. Given the easy access to broadband, maybe we could arrange some audio file swaps. Shouldn't be too illegal, assuming you already own the texts in print format. And only slightly less moral than driving with the radio on. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 4:44 PM To: Multiple recipients of list ORACLE-L I have an odd question about these on-line books. Can I copy-and-paste the text? Like many of you, I seem to end up with long commutes (why are the best jobs never in your neighborhood?). I find listening to books on CD to be a better use of time than reading bumper stickers. Nobody ever seems to issue Oracle books on audio. So I got a text-to-voice program, and it works pretty good to create an audio version of a book. But many of these eBooks zealously protect their text and prevent you from doing copy-and-paste on the text. Fortunately Oracle makes their books readily available. Any ideas are welcome. And my apologies to the authors on the list that are going he wants to do WHAT with my book!!. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennnis Did you get any more info re books on tape? Id be very interestd in audio documentation ;-) I have a boring 1 hour ride each direction Thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: oraperf comment
Ray, In addition, there are apps that expect to find indexes and data in separate locations. SAP is one of those. Jared Ray Stell [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/21/2002 01:43 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:oraperf comment An recent oraperf report included the comment: Never split index and data files to different sets of disks. It goes on to state that striping is better. If the system in question does not have raid support, wouldn't it be better to split the index and data across spindles? That would make the word Never inappropriate here? Maybe this is their way of saying don't use old technology. Is there some other reason I am missing? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Get together at OOW
Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Get together at OOW
Jared, you're going to SF and not OOW?, what you there for(although i wont be, i dont care for the large crowds at OOW). joe [EMAIL PROTECTED] wrote: Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Get together at OOW
No plans yet. I will probably not be attending OOW but would look forward to getting together with list members also. Last time we met at Chevy's (corner of Howard and 3rd Street). How about Tuesday Nov. 12th? I can make a reservation for, say 15 people at 7pm. Sound good? Gerardo -Original Message- Sent: Monday, October 21, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Molina, Gerardo 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: Get together at OOW
Jared, Count me in as I live in San Jose, and will drop in on any agreed date. Gerardo Molina (of SF, still on this list?) and self pulled together a group of illustrious personalities that even included Steve Adams (and the Goddess of course!) It would be a pleasure to meet you after all these years! John Kanagaraj -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Monday, October 21, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Get together at OOW Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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: Get together at OOW
Not this year... we have several highly visible apps going live anywhere from 10/31 through 11/8 (well, they were all scheduled for 10/31, all the database group's work is done but the developers..) and while I am not the production DBA (a refreshing change), I still don't think be away the first few weeks is advisable. Rachel --- John Kanagaraj [EMAIL PROTECTED] wrote: Jared, Count me in as I live in San Jose, and will drop in on any agreed date. Gerardo Molina (of SF, still on this list?) and self pulled together a group of illustrious personalities that even included Steve Adams (and the Goddess of course!) It would be a pleasure to meet you after all these years! John Kanagaraj -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Monday, October 21, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Get together at OOW Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Get together at OOW
I will be in SFO for the OW. Please let me know if we decide on the date and the place. I would appreciate it if someone sent an e-mail to my hotmail address. I will be out of the country till Nov 10th, but will be in SFO on Nov 11th. Thanks. - Kirti -Original Message- Sent: Monday, October 21, 2002 6:44 PM To: Multiple recipients of list ORACLE-L Jared, Count me in as I live in San Jose, and will drop in on any agreed date. Gerardo Molina (of SF, still on this list?) and self pulled together a group of illustrious personalities that even included Steve Adams (and the Goddess of course!) It would be a pleasure to meet you after all these years! John Kanagaraj -Original Message- From: [EMAIL PROTECTED] [mailto:Jared.Still;radisys.com] Sent: Monday, October 21, 2002 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Get together at OOW Dear list, Though I won't be attending OOW, I will be in San Francisco during those same dates ( 11/10 - 11/15), just a couple miles from the Moscone Center where OOW is held. Are there any plans yet among list members to get together one evening? I think Monday is spoken for myself, but it would be nice to meet a few list members another evening. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: Installation
it is a telecom product. i am asking about any oracle specific installations.. like tables,indexes,tablespaces etc. i hope i am clear santosh -Original Message- WILLIAMS Sent: Monday, October 21, 2002 8:49 PM To: Multiple recipients of list ORACLE-L Santosh - Let me understand . . . Oracle is already installed and in production at this site? Are you installing a commercial product? Then you should probably follow the instructions that come with the product. If it is a quality product with quality instructions, then tablespaces, etc. will be dealt with. If this is a production site, you should definitely install this on their test system first, probably after backing up the test system. Am I missing something here with your situation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hello all, I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma 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: Installation
Santosh, Your problem is still not clear. Are you going to install the product which will also install tables etc. in an oracle database? Or it is an independent product and you just want to be sure that it can co-exist with oracle? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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: Installation
Santosh, I don't mean to be rude here, and there are lots of people, including myself, who try to be helpful. But, it's simply not possible to give a list of what all needs to be installed. It's like showing up in a room full of construction workers and saying, Hi, I'm about to start building my house, but I've never done this before. Can you please give me a list of things I need to do and pointers as to what I need to look out for? If you have specfic issues or problems, or if a particular concept is not clear, I'm sure there are many who would be willing to help. Ask specific questions, you'll get specific answers. Also, always specify O/S, O/S version, and Oracle version. Oracle is a constantly moving target. It's impossible to give a clear and complete answer without that. Hope that helps, -Mark On Tue, 2002-10-22 at 01:13, Santosh Varma wrote: it is a telecom product. i am asking about any oracle specific installations.. like tables,indexes,tablespaces etc. i hope i am clear santosh -Original Message- WILLIAMS Sent: Monday, October 21, 2002 8:49 PM To: Multiple recipients of list ORACLE-L Santosh - Let me understand . . . Oracle is already installed and in production at this site? Are you installing a commercial product? Then you should probably follow the instructions that come with the product. If it is a quality product with quality instructions, then tablespaces, etc. will be dealt with. If this is a production site, you should definitely install this on their test system first, probably after backing up the test system. Am I missing something here with your situation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hello all, I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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: Installation
ok. i will make it clear. i am going to install the product which will also install tables/indexes/table space etc. can i have some scripts to do it or should i manually create the tables one by one ?? -Original Message- Nahata Sent: Tuesday, October 22, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Santosh, Your problem is still not clear. Are you going to install the product which will also install tables etc. in an oracle database? Or it is an independent product and you just want to be sure that it can co-exist with oracle? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma 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: Installation
u r right Mark. as regards version, i am using 8.1.5 I will come down to asking how to create the tablespace... santosh -Original Message- Bobak Sent: Tuesday, October 22, 2002 11:48 AM To: Multiple recipients of list ORACLE-L Santosh, I don't mean to be rude here, and there are lots of people, including myself, who try to be helpful. But, it's simply not possible to give a list of what all needs to be installed. It's like showing up in a room full of construction workers and saying, Hi, I'm about to start building my house, but I've never done this before. Can you please give me a list of things I need to do and pointers as to what I need to look out for? If you have specfic issues or problems, or if a particular concept is not clear, I'm sure there are many who would be willing to help. Ask specific questions, you'll get specific answers. Also, always specify O/S, O/S version, and Oracle version. Oracle is a constantly moving target. It's impossible to give a clear and complete answer without that. Hope that helps, -Mark On Tue, 2002-10-22 at 01:13, Santosh Varma wrote: it is a telecom product. i am asking about any oracle specific installations.. like tables,indexes,tablespaces etc. i hope i am clear santosh -Original Message- WILLIAMS Sent: Monday, October 21, 2002 8:49 PM To: Multiple recipients of list ORACLE-L Santosh - Let me understand . . . Oracle is already installed and in production at this site? Are you installing a commercial product? Then you should probably follow the instructions that come with the product. If it is a quality product with quality instructions, then tablespaces, etc. will be dealt with. If this is a production site, you should definitely install this on their test system first, probably after backing up the test system. Am I missing something here with your situation? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, October 21, 2002 5:38 AM To: Multiple recipients of list ORACLE-L Hello all, I am going to install a product in a client's place where oracle is installed. I am new to oracle. I wanted to know what all needs to be installed .. i mean like tables,tablespace etc... Please give me a list of these and how to do in brief Thanks and regards, Santosh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak 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 official ORACLE-L FAQ: http://www.orafaq.com -- Author: Santosh Varma 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).