Re: Windows ME and Net8
April, According to the following note there aren't any db server or client products currently supported on Windows ME: Note: 65995.1 Oracle Database Server Products for Windows 95 / 98 / ME Also the certification matrix on metalink doesn't include Windows ME as an available platform. HTH, -- Anita --- April Wells [EMAIL PROTECTED] wrote: We have several clients, mostly running NT or 98, and we have been able to get Net8 to install fine. Using the same CD, we cannot get it to install on Windows ME. I have been trying to get an answer as to support from Metalink, but so far have been unable to get an answer. Does anyone have any experience one way or another? Thank You April Wells -Original Message- Sent: Monday, June 04, 2001 1:24 PM To: April Wells April, Here is the error message that I received when attempting to install Oracle 8.1.6's Net on Windows ME. there was an problem in accessing the staging area. Please make sure the specified values for 'Source' and 'DESTINATION' are valid. The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
How to prevent oracle from committing a transaction?
Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
How to notify the firing a database trigger to the java application
Dear DBA Gurus, I have written an after update database trigger on a particular table. The trigger gets fired and does what I want. However I want to know as to how do I notify my java application that the trigger has fired? Anybody can let me know about this? Any help in this regard will be very much appreciated. TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
An Apology
I started all that chocolate stuff after Ethans post. Humble apologies to all concerned. Lee The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
RE: TUSC and Kevin Loney
HELP -Original Message- Sent: 05 June 2001 00:36 To: Multiple recipients of list ORACLE-L Who is Kevin Loney? -Original Message- Sent: Monday, June 04, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. 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] mailto:[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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
RE: How to prevent oracle from committing a transaction?
What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Hi Ranganath, There are several situation for oracle to commit. one of them of course you type 'commit;' manually others can be : when checkpoint occur when switch redo log occur when LRU function need to find space in your SGA when shutdown normal (am I wrong ?, Oracle rollback or commit ? I think oracle rollback uncommited transactions) ect... Sinardy -Original Message- Sent: Tuesday, 5 June 2001 3:30 PM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OCP Model Questions
That is because the underscore is now an illegal character in DNS records needs to be a hyphen What are the valid characters in a hostname? Hostnames can contain letters, numbers, and hyphens, and may not start with a hyphen. Underscore (_) is not a valid character in a hostname. While there are some DNS server software packages available that allow underscore within published host names, most do not. Using a domain or host name with an underscore will cause most name servers on the Internet to stop recognizing the related host/IP address from the bind faq at http://www.nominum.com/resources/faqs/bind-faqs.html#valid -Original Message- Subramanian Sent: Tuesday, 5 June 2001 3:35 PM To: Multiple recipients of list ORACLE-L I'm getting the following error While trying to retrieve the URL: http://smart_and_handsome.tripod.com/oracle.html The following error was encountered: Invalid URL Some aspect of the requested URL is incorrect. Possible problems: Missing or incorrect access protocol (should be `http://'' or similar) Missing hostname Illegal double-escape in the URL-Path Illegal character in hostname; underscores are not allowed Pl help. -- On Mon, 04 Jun 2001 12:44:25 Krishna Kakatur wrote: Hi, I have got this response from many and checked that the site is OK. May be the problem is with your proxy. I too can't access any site from my office which has an underscore within url, not the case when I access from my home. I think this is something to do with Proxy settings. Please check if you can change proxy settings/ try alternate solutions. -- Krishna From: Viraj Luthra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Model Questions Date: Mon, 04 Jun 2001 00:10:21 -0800 the url does not work On Sun, 03 Jun 2001 22:10:45 Krishna Kakatur wrote: Hi All, I have compiled some model questions for OCP DBA Test at http://www.oraref.com (mirrored at http://smart_and_handsome.tripod.com/oracle.html). If you have more, I will be happy to add them to the Web Page. -- Krishna _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Krishna Kakatur INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Peter McLarty INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: create temporary tablespace question
Use the former...You don't have to back them up, you can use them to have a read only standby, they do no logging of any kind...Although not explicitly stated in the manuals, I would say that they are the successor of the latter. hth connor --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi all, What is the different between: CREATE TEMPORARY TABLESPACE temp bla bla ; and CREATE TABLESPACE temp bla bla TEMPORARY ; Thank You Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
WAY OT. Graham Crackers
Anyone in the UK tell me if I can get Graham Crackers over here or the equivalent if they are rebadged as something else. Answers off list please. [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: Adding Indexes on Materialized views
You can but make sure they are non-unique, since Oracle does not give any guarantees of uniqueness during a refresh hth connor --- Vikas Kawatra [EMAIL PROTECTED] wrote: Has anyone created indexes on MV's ? Syntax? URLs ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Compute statisics
Sounds like nonsense to me...If you have half statistics, then the optimizer is going to use defaults for the others, which if anything, would (or should) lead to less optimal access paths It sounds like a weird attempt to get toward a first rows kind of approach, ie they want a rule type approach to small tables to keep indexes being used ... Demand an explanation. hth connor --- Browett, Darren [EMAIL PROTECTED] wrote: I have just received some notes from one our applications support, and they suggest after I compute statistics for the objects within their schema, that I then delete those statistics where num_rows * avg_row_len 65000 ?? What affect could this possibly have on the system ? I thought you would want statistics on all objects for the optimizer to function efficently Thank you in advance Darren - Darren Browett P.Eng This message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 download
Sinardy Xing wrote: Is Oracle 9i free download ?? Sinardy yeah, the download is free - but you have to own a SPARC box to use it. I saw a quote for the following - (refurbished) E450 2 x 400 MHz CPUs - 4 MB cache 4 x 256 MB RAM 4 x 9.1 GB hard drives SCSI controllers, fast ethernet, video adapter OS kit $12,000 Kinda steep when you're used to Intel boxes. Looks like I might hunt on Ebay for awhile longer. Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Windows ME and Net8
Sounds like a 650 MB patch (W2K Pro) is required, followed by an 80 MB patch (SP1). If you're brave - you can finish it off with W2K SP2. I did actually have a work-around for this. It includes first using an Oracle 7.3.4 client to create an oracle_home. But as its not a supported configuration - you're better off to use the semi-univeral solution for windows boxes: fdisk. hth, Paul A. Bardeen wrote: April, According to the following note there aren't any db server or client products currently supported on Windows ME: Note: 65995.1 Oracle Database Server Products for Windows 95 / 98 / ME Also the certification matrix on metalink doesn't include Windows ME as an available platform. HTH, -- Anita --- April Wells [EMAIL PROTECTED] wrote: We have several clients, mostly running NT or 98, and we have been able to get Net8 to install fine. Using the same CD, we cannot get it to install on Windows ME. I have been trying to get an answer as to support from Metalink, but so far have been unable to get an answer. Does anyone have any experience one way or another? Thank You April Wells -Original Message- Sent: Monday, June 04, 2001 1:24 PM To: April Wells April, Here is the error message that I received when attempting to install Oracle 8.1.6's Net on Windows ME. there was an problem in accessing the staging area. Please make sure the specified values for 'Source' and 'DESTINATION' are valid. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
set autocommit off (in sqlplus) and i'm not sure but cant you set this to be the default to happen in some glogin.sql file ? -Original Message- Sent: 05 June 2001 08:30 To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Ranganath, AFAIK, this can't be done. A normal exit has an implied commit. Perhaps someone else can suggest a way to do this programmatically. HTH, -- Anita --- Ranganath K [EMAIL PROTECTED] wrote: Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle 9i is on technet (NT)
Yeah, I created my Solaris Intel CDs at the weekend but it won't help me with 9i unfortunately 'cos the download's only for Sparc architecture. Maybe I'll need to spend cash. =( Regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: How to prevent oracle from committing a transaction?
Alternatively, you can also use QUIT. Stephane Faroult What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Steps for removing jobs
Simon, You are correct, although I don't know if using the DBMS_IJOB package directly is supported since it's a wrapped package and is not included in the documentation. -- Anita --- [EMAIL PROTECTED] wrote: Usefull article, but it missed one useful bit... * You can only manage your own jobs, even if you're a DBA user. -Not quite true, check out the DBMS_IJOB package. Does the same things as DBMS_JOB (submit, change delete jobs, etc) but lets you specify the 'owning' user. I found it in the O'Reilly Oracle Built-in Packages book It saves messing around with password-swapping and becoming other users. Simon Anderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: How to prevent oracle from committing a transaction?
Sinardy, I am afraid that you are under a number of misconceptions, and confusing writing to disk and commiting. The former is something physical, and the later more logical, althought it is also accompanied by a physical write. Whenever a disk flush occurs, the 'state' of your transaction is remembered (committed/uncommitted). As long as it's not committed, you can always rollback (or Oracle will do it for you if the machine crashes before you commit). Concerning the shutdown, in a shutdown normal (hardly anybody uses it) Oracle waits for all users to have logged off. Since you must (implicitely or explicitely) take a decision about accepting or rejecting your changes when logging off from Oracle, it means that everybody has to rollback or commit (usually, the default behaviour is to rollback when disconnecting. The exception is the SQL*Plus EXIT which commits and logs off). With the more widely used shutdown immediate, users are disconnected from Oracle (as they would be by say an operating system shutdown) and this forced disconnection comes with a rollback of pending transactions, then a flush of memory to disk. HTH, Stephane Faroult Oriole Corporation Hi Ranganath, There are several situation for oracle to commit. one of them of course you type 'commit;' manually others can be : when checkpoint occur when switch redo log occur when LRU function need to find space in your SGA when shutdown normal (am I wrong ?, Oracle rollback or commit ? I think oracle rollback uncommited transactions) ect... Sinardy -Original Message- Sent: Tuesday, 5 June 2001 3:30 PM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: export causes segmentation fault
Hi, Upload your ORA-7445 trace file by using iOraBugFinder. regards... "Nguyen, Long (ITS, Limestone Ave)" wrote: Hi, A friend of mine ran an export and got segmentation fault. It seems to be a bug with 8.1.6 on Solaris 5.8 and relates to character sets. Below is the info supplied by him. Anyone has experienced the same problem or could give a suggestion what to try? I searched Metalink and could not find any references to this problem. Thanks The database was created with charset and ncharset both set to WE8ISO8859P1: select * from NLS_DATABASE_PARAMETERS NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8ISO8859P1 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_NCHAR_CHARACTERSET WE8ISO8859P1 NLS_RDBMS_VERSION 8.1.6.0.0 --- When exporting the largest table, IF the client has US7ASCII set as the nls charset, the export works fine: $ export NLS_LANG=American_America.US7ASCII $ exp Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:37:28 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Username: aleg Password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Enter array fetch buffer size: 4096 2560 Export file: expdat.dmp /tmp/x.dmp (2)U(sers), or (3)T(ables): (2)U 3 Export table data (yes/no): yes Compress extents (yes/no): yes Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) topicrels . . exporting table TOPICRELS4826389 rows exported Table(T) or Partition(T:P) to be exported: (RETURN to quit) Export terminated successfully without warnings. --- Note the warning: "Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion)", which I guess we expect! Now, if we set the client NLS_LANG to match the database, the export fails: $ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 $ exp Export: Release 8.1.6.0.0 - Production on Mon Jun 4 10:41:38 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Username: aleg Password: Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Enter array fetch buffer size: 4096 2560 Export file: expdat.dmp /tmp/x.dmp (2)U(sers), or (3)T(ables): (2)U 3 Export table data (yes/no): yes Compress extents (yes/no): yes Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) topicrels . . exporting table TOPICRELS4826389 rows exportedSegmen tation Fault Other tables are exported just fine. The topicrels table looks like this: CREATE TABLE TOPICRELS ( FROMTIDVARCHAR2 (5) NOT NULL, TRTYPE VARCHAR2 (2) NOT NULL, TOTID VARCHAR2 (5) NOT NULL, SEQNUMBER (4)DEFAULT 0, UNCERTAIN CHAR (1)) TABLESPACE USERS NOLOGGING PCTFREE 1 PCTUSED 99 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 77725696 NEXT 4571136 PCTINCREASE 1 MINEXTENTS 1 MAXEXTENTS 121 FREELISTS 1 FREELIST GROUPS 1 ) CACHE; It has 3 indices: CREATE INDEX TRFROMTOTYPE ON TOPICRELS(FROMTID, TOTID, TRTYPE) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 151257088 NEXT 6160384 PCTINCREASE 0 ) ; CREATE INDEX TRFROMTYPESEQTOUNC ON TOPICRELS(FROMTID, TRTYPE, SEQ, TOTID, UNCERTAIN) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 108134400 NEXT 6160384 PCTINCREASE 0 ) ; CREATE INDEX TRTOTYPEFROM ON TOPICRELS(TOTID, TRTYPE, FROMTID) TABLESPACE INDX PCTFREE 1 STORAGE(INITIAL 138936320 NEXT 6160384 PCTINCREASE 0 ) ; System info: oracle environment: NLS_LANG=American_America.US7ASCII ORACLE_BASE=/usr/local/oracle/app/oracle ORACLE_DOC=/usr/local/oracle/app/oracle/product/8.1.6/doc ORACLE_HOME=/usr/local/oracle/app/oracle/product/8.1.6 ORACLE_SID=ALEG ORA_NLS33=/usr/local/oracle/app/oracle/product/8.1.6/ocommon/nls/admin/d ata PATH=/usr/local/oracle/app/oracle/product/8.1.6/bin:/etc:/usr/ccs/bin:/u sr/local/
Re: How to prevent oracle from committing a transaction?
Hi, If you set autocommit off it will rollback any uncommitted transactions by default when you exit SQL*Plus. regards, Mike Hately Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Row Chaining table fetch continued row
Hi all, I am checking Row-Chaining in one of Production Environment. But at the end I am not able to reconcile my results. I would appreciate if someone help me doing that.. After analyzing one table I see that it has 4202 Chained Rows. Then I run following SQL SQL select value 2 from v$sysstat 3 where name = 'table fetch continued row'; VALUE -- 951 SQL Select my.value 2 From v$mystat my, 3 V$sysstat sys 4 Where my.statistic# = sys.statistic# 5 And sys.name = 'table fetch continued row'; VALUE -- 0 Now I do SQL select * from prasanta.tdpsv ; After this I run following queries again, SQL Select my.value 2 From v$mystat my, 3 V$sysstat sys 4 Where my.statistic# = sys.statistic# 5 And sys.name = 'table fetch continued row' VALUE -- 0 SQL select value 2 from v$sysstat 3 where name = 'table fetch continued row' VALUE -- 960 Shouldn't the above two values be 4202 and 5153, as per description of 'table fetch continued row' ?? Am I missing something TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 add Composite Primary Key in a Table
a table CANNOT have more than one PK, drop the current and add a composite PK PRIMARY KEY (COL1,COL2...) -- From: Mudhalvan[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:01 PM To: LazyDBA.com Discussion Subject: How to add Composite Primary Key in a Table Hi DBAs Senario : I already created a Table without any primary key. Then i altered the table using alter table and added one primary key column. Question : Shall i add one more primary key to the same table ( Compsite primary key). If so then let me know the syntax Thanks Mudhalvan M.M Oracle DBA Maveric Systems _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Last Login
one way is to turn on the auditing, and check the logoff_time -- From: Johnv[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 9:55 AM To: LazyDBA.com Discussion Subject: Last Login Hi Guys/Gals Can anyone identify for me how I can tell the last time an user account was used ( time stamp)?? Thanks __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Adding Indexes on Materialized views
That restriction was lifted in Oracle8 since deferrable constraints were introduced. Referential integrity and unique constraints are allowed on snapshots as long as they are created as deferrable since, as Connor mentioned, the uniqueness cannot be guaranteed during the refresh. Non-unique indexes are also allowed. They are created the same way as on a normal table. In 8.0.x they're created on the SNAP$_ base table; in 8i the table name is identical to the snapshot/MV name. HTH, -- Anita --- Connor McDonald [EMAIL PROTECTED] wrote: You can but make sure they are non-unique, since Oracle does not give any guarantees of uniqueness during a refresh hth connor --- Vikas Kawatra [EMAIL PROTECTED] wrote: Has anyone created indexes on MV's ? Syntax? URLs ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ora-600
Thank you Deshpande, It's nice to hear good results. I genarally recommend search depth=1. Search depth=0 may return a lot of bugs and it may take time to find which one is yours. And, You may not see all bugs. It depends on your license and bug status. Many bugs are un-published(not only bugs, but also everythingl. This list has more internals than Metalink). If iOraBugFinder returns no hit, email Oracle support with HTML or URL returned by iOraBugFinder. Since Oracle support can see all bugs, That will reduce your support response time from Oracle support. I added new features on 1.0.1 version. It's now better to find bugs. If you have any recommendations, please feel free to contact me. "Deshpande, Kirti" wrote: Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Can you tell me how to prevent oracle from committing a transaction unless unless I explicitly commit it. To do what you are asking, exit sql*plus with the command: exit rollback This will exit you from sql*plus and it will prevent Oracle from committing a transaction unless you have already explicitly committed it. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Last Login
Not sure if it was mentioned or not but I just came back from a few days of and had to delete the hundreds of messages. LISTENER.LOG file can tell you who logged on when Jack Rahul rahul@ratelin To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] do.co.idcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Last Login [EMAIL PROTECTED] om 05-06-2001 11:58 Please respond to ORACLE-L one way is to turn on the auditing, and check the logoff_time -- From: Johnv[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 9:55 AM To: LazyDBA.com Discussion Subject: Last Login Hi Guys/Gals Can anyone identify for me how I can tell the last time an user account was used ( time stamp)?? Thanks __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and
RE: WAY OT. Graham Crackers
Lee, www.madeinamerica.co.uk Go to the online catalogue section, and then the choose the Sweets Drinks area. Regards Mark (Another fan of all things American Sweet) -Original Message- lerobe Sent: Tuesday, June 05, 2001 09:26 To: Multiple recipients of list ORACLE-L Anyone in the UK tell me if I can get Graham Crackers over here or the equivalent if they are rebadged as something else. Answers off list please. [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction - Solved
Hi DBA Gurus, The following soultion worked for me: Exit Rollback. My special thanks to Marco Rooy van and Ray O'Brien for providing the solution. Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ora-600
Kevin, ORA-600's and ORA-7445's are very similar in some respects in that they are related to the death of a process. ORA-600's are essentially exception handlers so there are literally thousands of different ORA-600's. Some errors are signaled in only one situation, others can occur in hundreds of cases. An ORA-7445 is merely the Oracle error assigned to the return code when the OS terminates the process (bad process!). BTW, ORA-7445's are not signaled on NT, NetWare or Linux. Instead, the following errors are signaled: Dr. Watson errors (NT), abends (NetWare) or Errors in file... entries in the alert.log and trace files containing Exception signal... (Linux). With ORA-600's the first argument is very specific, so when searching on metalink include the first argument. Any additional arguments are specific to the environment (DBA's, object ID's, memory addresses, etc...) so they should not be searched on since they are unlikely to be the same. The arguments on ORA-7445 errors are usually irrelevant as they are frequently generic ([SIGSEGV], [SIGBUS], [Address not mapped to object], [Invalid address alignment] etc...). If you can identify the type of operation generating the error, then it helps to search on that along with the error. In some cases this will be in the trace file under the heading Current SQL statement for this session. These errors frequently indicate bugs, but can also occur due to other reasons such as hardware/OS problems, corruption, or incorrect environment settings. For example, a corrupt block can signal an ORA-600 error because the information in the header of the block is out of sync. The best way to determine the cause of these errors is to log a tar with support as much of the information in the bugs is viewable only to support. They will need the alert.log (preferably going back to the last startup, but at least the last 3-10 days) along with the trace files generated (upload the whole file, don't just cut and paste portions of it). In the case of multiple errors in the alert.log, supply the trace files from the first couple of errors as often the first error can cause cascading errors. If a trace file is not generated by an ORA-7445, then you should try to extract a stack trace from the core file (see notes 1812.1 and 1007808.6). This needs to be done using the executables that generated the core file, so don't bother sending the core file to support. I'm developing this into a presentation that I hope to present at OpenWorld (ORA-3113's, 600's, and 7445's Oh My!) so please feel free to send me questions or topics I should cover. HTH, -- Anita --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject:ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Deshpande, Kirti INET:
Re: Size, what is it?
One of the guys that used to work for me in Premium Services, Martin Berg, once had this idea that you could measure the number of logical IO's (LIO's) per CPU per hour on a system. Scanning V$SQL and measuring the % of cpu time being used at the same time could give you an idea. At least this will provide a unit of work that can be related to an Oracle database, although the idea has more buts and ifs than Denmark has rainy days. Whether you're doing OLTP or batch jobs, your unit would still be LIO's... Steve Sapovits wrote: Sort of related, you might be interested in http://www.tpc.org Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Dave Morgan [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: Re: Size, what is it? Hi Mogens I agree with all your statements. What I am trying to figure out is what is it that streches the machine. I was quite surprised to see an E450 doing 10GB of transaction logs per day. Pure OLTP using stored procs. I was hoping to get descriptions of the types and amounts of work a large or busy database does along with the description of the hardware that is being used. This would allow a baseline to be developed for estimating. For example how much OLTP work can a Linux 2 CPU machine with lots of memory do? How many DSS users can a similar machine support? I would also like to ask similar questions about other UNIX configurations? VAX/VMS would also be interesting. NT, someone else can do the work if they want :) SUN is also now offering hardware RAID 3 in their RSM2000 array. As I mentioned the Baydel array beats RAID 5 easily, and is substantially cheaper than an equivalent RAID 10 (1+0) array which is my preference. (and everyone elses :) Thanks for your input. Dave Mogens wrote ... My dear friend Cary Millsap once came up with a definition for a VLDB: It's any database that stretches its hardware. I cannot see any relationship between SGA and database sizes. None. RAID-3: Bit-level striping. Incredible it still exists (in my opinion) :). -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Steve Sapovits INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Wow, you're right. Let this be a warning to you all; this is what happens to your brain when you mess with DB2. Just say no kids. = ) Thanks, Mike Hi Mike, I was also thinking so. But it doesn't do so. Setting autocommit off will implicitly commit all your transactions for that session. For doing this I tried exit rollback as suggested by Marco, one of the list members. Thanks and Regards, Ranganath *** Phone: (01670) 593900 Fax: (01670) 593909 Web Site: http://www.etech-uk.com E-MAIL DISCLAIMER The information in this email is confidential and may be legally privileged.It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. All information provided, including but not limited to, quotations, system specifications and suggestions concerning hardware/software (and services) configurations are strictly subject to our standard terms and conditions of business, copies of which are available on request. *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
If Quest and TUSC are attracting a number of high-profile people, they will probably survive the recession. : ) TUSC says they recently expanded, they used to be only in Chicago I think. They opened an office in Atlanta, and they have another one somewhere. I don't know as much about Quest. So what does this mean for O'Reilly Publishers, if all these good authors now fall under the wing of database consulting firms? Quest through O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish via O'Reilly. 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] mailto:[EMAIL PROTECTED] -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: ora-600
I worked with RDBMS support in Oracle Denmark for far too many years, and I'm not that scared of 600's anymore. To provoke a bit, I find that they are in general harmless, and then in some cases indicate serious stuff. When looking at Oracle source code, you will (if you ever get the chance :) ) see this kind of thing: If then signal ORA-942 (or rather OERR(00942)) if something unforeseen happens, signal 600 with specific arguments (OERI(17112)) Else... signal ORA-1000 (OERR(01000)) Of course I'm making up these numbers, but the two functions called are OERR for normal errors and OERI for Oracle ERror Internal. So the ora-00600 [17112] is because the normal error codes couldn't handle the situation. So the first argument for an ora-600 error is the error code and is indeed specific for a certain part of the Oracle code. Support/Development can easily look up where in the code this is signalled, but it can be very difficult to find out why it was signalled (I'm saying this, because I rarely could figure it out - of course all the smart types could, but I couldn't). In the case of ORA-00600 [17112], however, I do have some notes: Internal heap errors/corruptions: [17066] [17112] [17114] [17148] [17182] E.g. BAD MAGIC NUMBER in trace file So look in the trace file for BAD MAGIC NUMBER and you will know that a problem occurred in the heap. There can of course be a lot of reasons for this magic number to give errors when computed. Check the bug database or Support for specifics. But it's not fatal or anything. A. Bardeen wrote: Kevin, ORA-600's and ORA-7445's are very similar in some respects in that they are related to the death of a process. ORA-600's are essentially exception handlers so there are literally thousands of different ORA-600's. Some errors are signaled in only one situation, others can occur in hundreds of cases. An ORA-7445 is merely the Oracle error assigned to the return code when the OS terminates the process (bad process!). BTW, ORA-7445's are not signaled on NT, NetWare or Linux. Instead, the following errors are signaled: Dr. Watson errors (NT), abends (NetWare) or Errors in file... entries in the alert.log and trace files containing Exception signal... (Linux). With ORA-600's the first argument is very specific, so when searching on metalink include the first argument. Any additional arguments are specific to the environment (DBA's, object ID's, memory addresses, etc...) so they should not be searched on since they are unlikely to be the same. The arguments on ORA-7445 errors are usually irrelevant as they are frequently generic ([SIGSEGV], [SIGBUS], [Address not mapped to object], [Invalid address alignment] etc...). If you can identify the type of operation generating the error, then it helps to search on that along with the error. In some cases this will be in the trace file under the heading Current SQL statement for this session. These errors frequently indicate bugs, but can also occur due to other reasons such as hardware/OS problems, corruption, or incorrect environment settings. For example, a corrupt block can signal an ORA-600 error because the information in the header of the block is out of sync. The best way to determine the cause of these errors is to log a tar with support as much of the information in the bugs is viewable only to support. They will need the alert.log (preferably going back to the last startup, but at least the last 3-10 days) along with the trace files generated (upload the whole file, don't just cut and paste portions of it). In the case of multiple errors in the alert.log, supply the trace files from the first couple of errors as often the first error can cause cascading errors. If a trace file is not generated by an ORA-7445, then you should try to extract a stack trace from the core file (see notes 1812.1 and 1007808.6). This needs to be done using the executables that generated the core file, so don't bother sending the core file to support. I'm developing this into a presentation that I hope to present at OpenWorld (ORA-3113's, 600's, and 7445's Oh My!) so please feel free to send me questions or topics I should cover. HTH, -- Anita --- Kevin Kostyszyn [EMAIL PROTECTED] wrote: Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords name does that mean? I looked on Metasuck and I haven't seen anything. Is the only answer to call support, or just hammer away until he figures it out? Anyone seen this before. And yes I know, it 8.1.5 on NT.. Kev -Original Message- Kirti Sent: Monday, June 04, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Hi, It
OT survival of mankind without DSL
Because in the past, well-written software used to fit on one or two 320K diskettes. None of that bloated-code API, object-oriented nonsense that just lets people come out with new versions every six months. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 6:47 PM To: Multiple recipients of list ORACLE-L Subject:RE: 9i download I believe that a cable modem or a DSL are the best download accelerators on the market. Doing that with a 56k modem is a suicide. From this perspective, I cannot comprehend how did the mankind survive before the advent of DSL. -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
contents of SGA
One of my co-worker came with this ques. In the init.ora file he had set the shared_pool_size to 10M and db_block_buffers=1024 and redolog buffer to 32768. but when he did sho sga in the sql*plus prompt he got the following output Total System Global Area 41297948 bytes Fixed Size75804 bytes Variable Size 32755712 bytes Database Buffers8388608 bytes Redo Buffers 77824 bytes Doing a select on V$SGA also gave the same result. My shared pool size is only 10M, why it is showing nearly 40M. From where did oracle derive the extra MB's? I ran throu the oracle manual and got only answer for database buffers. Can any one tell from where these extra MB's come to Oracle from the OS. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Messing with DB2
mess with DB2 The common question used to be, Oracle?, or Informix or Sybase? Now mentions of DB2 keep popping up. Hmmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Row Chaining table fetch continued row
v$tables will report what the system or session has encountered since instance startup. Analyze or similar will report the actual number in the table. If an instance has been running for several days and the ...fetch continued row... is low, why bother? Rajesh Dayal wrote: Hi all, I am checking Row-Chaining in one of Production Environment. But at the end I am not able to reconcile my results. I would appreciate if someone help me doing that.. After analyzing one table I see that it has 4202 Chained Rows. Then I run following SQL SQL select value 2 from v$sysstat 3 where name = 'table fetch continued row'; VALUE -- 951 SQL Select my.value 2 From v$mystat my, 3 V$sysstat sys 4 Where my.statistic# = sys.statistic# 5 And sys.name = 'table fetch continued row'; VALUE -- 0 Now I do SQL select * from prasanta.tdpsv ; After this I run following queries again, SQL Select my.value 2 From v$mystat my, 3 V$sysstat sys 4 Where my.statistic# = sys.statistic# 5 And sys.name = 'table fetch continued row' VALUE -- 0 SQL select value 2 from v$sysstat 3 where name = 'table fetch continued row' VALUE -- 960 Shouldn't the above two values be 4202 and 5153, as per description of 'table fetch continued row' ?? Am I missing something TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Last Login
And then of course you have the wonderful 8i feature of logoff triggers. We use them to catch various session waits (v$session_Event) right before they log out. [EMAIL PROTECTED] wrote: Not sure if it was mentioned or not but I just came back from a few days of and had to delete the hundreds of messages. LISTENER.LOG file can tell you who logged on when Jack Rahul rahul@ratelin To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] do.co.idcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Last Login [EMAIL PROTECTED] om 05-06-2001 11:58 Please respond to ORACLE-L one way is to turn on the auditing, and check the logoff_time -- From: Johnv[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 9:55 AM To: LazyDBA.com Discussion Subject: Last Login Hi Guys/Gals Can anyone identify for me how I can tell the last time an user account was used ( time stamp)?? Thanks __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
OT -- Oracle in trouble? muses the ERP newsletter
I received this as part of an ERP newsletter: Street Fight: Oracle http://www.erpcentral.com http://www.erpcentral.com Forbes.com, June 4, 2001 With sagging earnings and lack of guidance for its soon-to-be-announced fourth quarter, Oracle has been slapped with no less than nine analyst downgrades since early March. Shares of the database software provider have dropped 67% from their 52-week high, giving the stock a latest 12-month price-to-earnings ratio of just 14. Is it time to buy America's second-largest independent software concern? The fight is on. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Messing with DB2
I'm having my first brush with it and it's a bit of a shift. Seeing as IBM now own Informix I'd expect them to rip off its features and incorporate them into DB2. First impressions are that it's easy to set up a default database but not as tunable as Oracle but having said that I'm at no great depth yet. It has some handy features but its core architecture doesn't seem as good as Oracle's. Anyway, it looks like it may be a contender in years to come. The latest version, 7.2 was scheduled for release this week. Given that the previous version is available for Linux and IBM are forging closer links with the Linux community I'll be amazed if Oracle don't release 9i for Linux fairly quickly. I'd have it next on the release schedule if I were in charge. Hopefully, I'll manage some sort of comparison paper of the 2 products when I get time and a little more production exposure to DB2. Regards, Mike Hately Oracle ( and DB2! ) DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Steps for removing jobs
There's a note on Metalink that outlines it and states that it's not supported, not documented in the Oracle manuals and that the 'supported' method of manipulating jobs is as the jobs owner. Seems strange to me, but Ours is not to reason why... Simon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Last Login
Mogens, What a brilliant idea! I'll definitely add this to my bag of tricks. -- Anita --- Mogens Nørgaard [EMAIL PROTECTED] wrote: And then of course you have the wonderful 8i feature of logoff triggers. We use them to catch various session waits (v$session_Event) right before they log out. [EMAIL PROTECTED] wrote: Not sure if it was mentioned or not but I just came back from a few days of and had to delete the hundreds of messages. LISTENER.LOG file can tell you who logged on when Jack Rahul rahul@ratelin To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] do.co.idcc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Last Login [EMAIL PROTECTED] om 05-06-2001 11:58 Please respond to ORACLE-L one way is to turn on the auditing, and check the logoff_time -- From: Johnv[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 9:55 AM To: LazyDBA.com Discussion Subject: Last Login Hi Guys/Gals Can anyone identify for me how I can tell the last time an user account was used ( time stamp)?? Thanks __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge.
RE: Shared Pool info - V$sqlarea.
Thanks Chris. The problem I am facing is 100% CPU usage and memory paging out at times. I tought the starting point is v$sqlarea. Purchasing of Precise SQL or SQL Vision can not happen here immediately. The RAM size is 512MB and SGA is 210MB. The buffer cache hit ratio is 99%. I was just wondering is there any way to find out the cause of this problem? TIA Cheers Raj -Original Message- Sent: 01 June 2001 19:51 To: Multiple recipients of list ORACLE-L Oracle has no guarentee how long statistics and plans will be available for statements, depending on the activity of the database they may be there for 2 seconds they may be there for 2 weeks. Products like Precise SQL and SQL Vision Lab help in that manor where they capture transactions and activity continuously in a non-intrusive manor. This is the only guarenteed way to get 99.999% of the transactions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 12:16 PM To: Multiple recipients of list ORACLE-L DBAs The statistics in v$sqlarea is getting flushed very often. In the morning I found the a query which has more than 10,000 disk reads as the top one. But now the top most query with disk reads has not more than 100 disk reads. I have not bouncd the DB or flushed the shared pool. The overall library cache hit ratio is 97%.where us SQLAREA hit ratio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
they aren't broken down quite like that -- Gaja works for Quest but is published by Oracle Press, Mike Ault is published by neither... From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 03:45:24 -0800 If Quest and TUSC are attracting a number of high-profile people, they will probably survive the recession. : ) TUSC says they recently expanded, they used to be only in Chicago I think. They opened an office in Atlanta, and they have another one somewhere. I don't know as much about Quest. So what does this mean for O'Reilly Publishers, if all these good authors now fall under the wing of database consulting firms? Quest through O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish via O'Reilly. 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] mailto:[EMAIL PROTECTED] -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 notify the firing a database trigger to the java appli
Openworld 2000 had a paper on using dbms_alerts to notify java client. In the trigger you could raise a dbms_alert and capture that in your java application. HTH 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 ! *4 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. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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:Spotlite question
I think you are confusing the Server and the Client information. The client that runs the Spotlite has to be Windows 95/98/2000/NT. I have Spotlite monitoring a Novell server. I worked with the spotlite development team for release 2.c that limited the trace file naming convention to 8 char. It works great. From my pc Win 98 I can monitor the production database and development database (Novell) and a test server (Linux) ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 10:15PM Nick, Does spotlight support an Oracle server running on NT? The requirements page says: Server Oracle versions from 7.3.3 and above Solaris (2.5, 2.6, 2.7) HP-UX (10.20, 11.00/32 bit, 11.00/64 bit) AIX (4.2, 4.3) Digital (v4.0d, v4.0f) which seems to me to say the Oracle server must be running on Unix and not NT. but then the PDF data sheet says Spotlight requires Windows 95/98/2000/NT and a SQL*Net connection to any Oracle server (7.3.3 or greater) Which is correct? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, 5 June 2001 11:20 you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/ there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but it will tell you everything you need to know about your instance... and what init.ora parameters you can change to improve it. Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
On Mon, 4 Jun 2001,Ari D Kaplan scribbled on the wall in glitter crayon: -At TUSC, there are more authors than Rich Niemiec, Mike Ault, and Kevin -Loney. There are also Brad Brown, Joe Trezzo, Tony Catalano. - --Ari well, damn there goes any hope of me getting in with TUSC.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Fig Newton: The force required to accelerate a fig 39.37 inches/sec. -- J. Hart -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 run procedure containig REF CURSOR as datatype
Tom, I used ur suggestion but i am still getting the same error. I am running the procedure from sqlplus Do i have to modify something to run from sqlplus.. ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -Original Message- Sent: Tuesday, June 05, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Harvinder, change your script like this: declare io_cursor getrateschedules_pkg.t_cursor; == change the reference to the cursor declared in the package body. begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / we do this all the time for ref cursors used by VB. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, June 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Hi, What value to pass as io_cursor in the following procedureHow to run the procedures containing REF CURSOR.. create or replace package GetRateSchedules_pkg as TYPE t_cursor is REF CURSOR; procedure GetRateSchedules( temp_id_acc int,acc_cycle_id int,default_pl int,RecordDate date,temp_id_pi_type int,io_cursor in out t_cursor); end; i am getting error when i run the following code: declare TYPE t_cursor is REF CURSOR; io_cursor t_cursor; begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT: TUSC and Kevin Loney
What about Steve Adams, does somebody know whether he joined some big company also? -Oorspronkelijk bericht- Van: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 juni 2001 15:31 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: TUSC and Kevin Loney they aren't broken down quite like that -- Gaja works for Quest but is published by Oracle Press, Mike Ault is published by neither... From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 03:45:24 -0800 If Quest and TUSC are attracting a number of high-profile people, they will probably survive the recession. : ) TUSC says they recently expanded, they used to be only in Chicago I think. They opened an office in Atlanta, and they have another one somewhere. I don't know as much about Quest. So what does this mean for O'Reilly Publishers, if all these good authors now fall under the wing of database consulting firms? Quest through O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish via O'Reilly. 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] mailto:[EMAIL PROTECTED] -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
Re: connecting problems: ORA-12154: Could not resolve servicename
Mikael, Did you set up the tnsnames.ora on the server? You need that in order to use the @mtipdb_tcp when you connect. If you can connect to the database without the @ clause, then I'd check the tnsnames.ora. Mikael Granhed wrote: Hi! I have just installed Oracle8.06 on SUN/Solaris server. The installation of the database was successfull. But when I´m checking the connection with the listener with the command sqlplus system/manager@mtipdb_tcp. I got the following error: ORA-12154: Could not resolve servicename. I have also tried to connect to the server from a NT-client and that works fine. It seems to be some problem with the internal connection on the server. Maybe it is a parameter that is not set correctly? Does anybody know what the problem can be? Thanks in advance! Best regards Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: connecting problems: ORA-12154: Could not resolve servicenam
Title: RE: connecting problems: ORA-12154: Could not resolve servicename Mikael, Do you have tnsnames.ora set up on your unix host? Any time you do '@' in your connect string it is connecting via a listener. That's why you can (most likely) connect by setting your ORACLE_SID in your environment on the local host and typing sqlplus system/manager and not sqlplus system/manager@SIDNAME. Put the correct entry in your tnsnames.ora in the $TNS_ADMIN directory ($ORACLE_HOME/network/admin) and it should work. HTH Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Mikael Granhed [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: connecting problems: ORA-12154: Could not resolve servicename Hi! I have just installed Oracle8.06 on SUN/Solaris server. The installation of the database was successfull. But when I´m checking the connection with the listener with the command sqlplus system/manager@mtipdb_tcp. I got the following error: ORA-12154: Could not resolve servicename. I have also tried to connect to the server from a NT-client and that works fine. It seems to be some problem with the internal connection on the server. Maybe it is a parameter that is not set correctly? Does anybody know what the problem can be? Thanks in advance! Best regards Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Keep in mind that if at any point you issue any DDL command, a commit is automatically performed. For example, if you open a SQL*Plus session, insert a few records, then do an alter table ..., those records will be committed. Just a thought... Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Difference in speed of sorting using index and non-index column in the order by
Dear list, Someone ask me when Oracle is doing a sort, will it make a difference if we use indexed column and non-indexes column in the order by clause, my initial thinking was index only speed up the retrieval of data from disk, Oracle probably using other algorithm in sorting records, so indexing is not relevant in that case. Can someone shed light on this question. KC
RE: 9i download
Title: RE: 9i download Paul and all others interested. Ebay seems to be a great source for used sun boxes, I've also noticed at sun's site they have a new workstation for $999. Now of course you'd probably need more ram but this setup looks like it can handle and run 9i, etc for testing purposes at home. Hardware guys out there could you determine if this is enough? Thanks. Ivan Rivera http://store.sun.com/catalog/doc/BrowsePage.jhtml?cid=60357=Desktops
dbms_java and file permissions
8.1.7.1 on Solaris 7 I created a small java procedure to be able to call O/S commands from within the database (using Ask Tom's example). Works a little too well because I can't seem to restrict access to the oracle directories which is obviously a major concern. Here are the list of privileges I granted/restricted to the owner of the java procedure. KIND GRANTE TYPE_ TYPE_NAME NAME ACTION -- - -- -- - GRANT TISSD SYS java.io.FilePermission /export/home/oracle/bsw/scripts/java read RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/ read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/- read,writ! ! e,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/test* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/testjunk.file read,write,execute,delete GRANT TISSD SYS java.io.FilePermission /usr/bin/* execute GRANT TISSD SYS java.lang.RuntimePermission * writeFileDescriptor 9 rows selected. As you can see I tried numerous ways to restrict access to /u20/app/oracle files and had very limited luck. Each time I added a new restriction I logged out of the tissd account and back in. On the flip side I had to grant access to /export/home/oracle/bsw/scripts/java to allow files to be read there. I don't understand why unlimited access is being allowed to the files which should be the most restricted. The tissd user was NOT granted DBA privs nor the JAVASYSPRIV or JAVAUSERPRIV roles.I've read the 8.1.7 Java Developers Guide Chapter 5 on security and haven't found the answer there either. This worked, which I didn't think it should. SQL exec rc('/usr/bin/ls /u20/app/oracle');adminjreoraInventoryoradataouiproducttestfile.junkReturn code is 0 And this failed. SQL exec rc('/usr/bin/ls /u20/app/oracle/*');Return code is 2 Doing an ls on the file failed SQL exec rc('/usr/bin/ls /u20/app/oracle/testjunk.file');Return code is 2 But moving it worked fine. AAUUUGGGHHH!!! SQL exec rc('/usr/bin/mv /u20/app/oracle/testjunk.file /u20/app/oracle/testfile.junk');Return code is 0 Just your regular ol' IDIOT asking for HELP. Thanks - Brian Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Oracle Enterprise Manager
I am a little confused. Is the Oracle Enterprise Manager part of Oracle 8i (8.1.7) Standard Edition or do I have to pay extra for it? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
iAS installation update
FYI, I logged a TAR with Oracle last week or so because one Metalink tech had said in passing that Forms and Reports had to go into its own, separate oracle_home. This follows from a previous TAR I had logged with them, simply asking which products work best together. I had read the installation manual for iAS and had earlier found this: Note: Be sure not to install Oracle9i Application Server in an Oracle_home containing other Oracle products, including the database. Such an installation could overwrite shared components, causing the products to malfunction. (on p. 3-5, 4-5, 5-5). Now, in Oracle Reports Developer Getting Started - Release 6i for Windows, it says: Reports Developer 6i must reside in the default oracle_home. Reports Developer 6i and the Oracle8 or Oracle8i server must reside in separate oracle_Homes, although they can reside on the same physical machine. Similarly, in a web application deployment, Report Server and Oracle Application Server must reside in separate oracle_homes, although they can reside on the same physical machine. (p.1-16) Forms and Reports 6i happen to require an Oracle 8.0.6. oracle_home. This posed a dilemma: how can I install iAS in the default home, when many of its components require access to an origin database. I do not plan to use iAS with 8.0.6., I plan to use it with 8.1.7.. I thought I would have to install Forms and Reports 6i first, remove the tidbits that the Oracle Universal Installer installs by default, then install 8.1.7., and then install the iSuite components. Of course by the end of this tortuous process there were errors. I had a different Metalink technician this time, who told me to ignore what the first technician had said, and to just install iAS based on the installation manual, never mind the other worries that I had. So, I am ignoring the Oracle Reports Developer Getting Started manual, and I am installing based on the iAS installation manual. Hopefully that will work. /begin rant I still wish the Oracle techs could have told me which versions of the various products are concurrent, they just keep insisting that all their products are certified to work together. All I wanted to know was which oracle_home type do the various products use? Forms and Reports 6i requires an 8.0.6. home, Developer6 used an 8.0.5 home, etc. the Metalink techs do not appear to have a list, they didn't understand my question. When I logged a TAR on this I received three e-mails telling me that my TAR had been passed to different people, in the end the last tech told me that products sometimes are released together, but that it is not all that important, because everything is certified to work together. I can't shake the feeling that iAS is a bundle of things that were just slapped together. Seeing the old installer pop up during the installation doesn't help remove that impression. Hopefully when the next release comes out it will install in something other than an (old) Oracle 8.0.6. oracle_home. Since it's called Oracle9i iAS, maybe the Forms and Reports Servers will go into a 9i oracle_home (?). /end rant (this is my impression, not my employer's etc. etc.) Sorry if this comes across as a little harsh. 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] mailto:[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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Thanks everyone - tru64
Title: Thanks everyone - tru64 I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.
Re: RE: How to prevent oracle from committing a transaction?
Yeah, that's what I was going to suggest. QUIT used to do an exit without a commit, but now it commits it just like EXIT does. I wonder why they changed that? Now they are just synonyms of one another. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] sfaroult@orio le.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Fax to: com Subject: Re: RE: How to prevent oracle from committing a transaction? 06/05/2001 05:40 AM Please respond to ORACLE-L Alternatively, you can also use QUIT. Stephane Faroult What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: OT: TUSC and Kevin Loney
as far as I know, Steve still works for Ixora, which is his own company From: Jeroen van Sluisdam [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 06:35:30 -0800 What about Steve Adams, does somebody know whether he joined some big company also? -Oorspronkelijk bericht- Van: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 juni 2001 15:31 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: TUSC and Kevin Loney they aren't broken down quite like that -- Gaja works for Quest but is published by Oracle Press, Mike Ault is published by neither... From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 03:45:24 -0800 If Quest and TUSC are attracting a number of high-profile people, they will probably survive the recession. : ) TUSC says they recently expanded, they used to be only in Chicago I think. They opened an office in Atlanta, and they have another one somewhere. I don't know as much about Quest. So what does this mean for O'Reilly Publishers, if all these good authors now fall under the wing of database consulting firms? Quest through O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish via O'Reilly. 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] mailto:[EMAIL PROTECTED] -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Difference in speed of sorting using index and non-index colu
KC: In some cases, Oracle can use an index to read the data in sorted order, thereby eliminating the need for the SORT operation. Check your EXPLAIN PLANs. If there is a SORT step listed, then Oracle is doing a sort, if not (and there is a ORDER BY clause on your query) then Oracle is using the index to read the data in sorted order. Kevin -Original Message- Sent: Tuesday, June 05, 2001 10:21 AM To: Multiple recipients of list ORACLE-L the order by Dear list, Someone ask me when Oracle is doing a sort, will it make a difference if we use indexed column and non-indexes column in the order by clause, my initial thinking was index only speed up the retrieval of data from disk, Oracle probably using other algorithm in sorting records, so indexing is not relevant in that case. Can someone shed light on this question. KC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
How to drop a system event trigger - endless loop?
Hi Gurus ! I created a trigger on logon event. The trigger seems to be falling into an endless loop, so I can't login. How colud I drop this trigger. I created this trigger with ON DATABASE clause. Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Oracle 9iAS
I thought I had heard that the Oracle Enterprise Manager Tuning Pack is/was included as part of the Oracle 9iApplication Server bundle. Out of the two dozen+ CDs I have not yet been able to find any EOM packs. If any OEM packs are included, on which CD can it be found? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Perl is great. It lets you turn line noise into useful code. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Cannot start Oracle Management Server on Windows NT
Hi folks, I've just finished creating a Release 2.2 OMS repository on an 8.1.6 database on a Windows NT server machine. Following the Configuration Guide I then tried to start the Managament Server service, and in the text window I got the message: ... c:\orant\admin\orb\resources.ora is not found! VXA-3008 : Starting OMS Services, Wait. The OMS is now started and ready. A bit worried by the not found message, I opened another DOS window and tried typing oemctrl status oms, and got the same message about the resources.ora being not found. Now, looking at my directory structure, there IS a file whose full path is: c:\orant\orb\admin\resources.ora but there is no c:\orant\orb directory. Anybody got any ideas what is screwed up here? Or does anyone have any references for technical notes at Oracle's tech support sites about this problem? I've tried looking, but can't seem to formulate a search that yields any results! Hope you can help! Paul Paul Vincent Database Administrator, University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
Hi All, No, I'm waiting for Henry to announce the details of the commercial DBA union! The pre-announcement is at http://www.lazydba.com/xcomment.pl?discussions:6 @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ PS. This is a joke for the benefit of those who have been following the LazyDBA issues. -Original Message- Sent: Wednesday, 6 June 2001 0:35 To: Multiple recipients of list ORACLE-L What about Steve Adams, does somebody know whether he joined some big company also? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 download
I guess I was thinking of IAS 9I. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
Title: RE: TUSC and Kevin Loney So is Rachel, but last I heard she wasn't taking them too seriously. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -Original Message- From: Mike Killough [mailto:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L Subject: Re: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. 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] mailto:[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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: OT RE: Database writer
So... no winner Ross? Do we get the answer?? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 4:25 PM Yea, NT blows. Blows like a fresh wind against the empire. (1st one to name that song lyric reference and i buy you a beer. NT bigots and their families summarily excused from this offer.:) || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 2:16 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Database writer || || || Doubt, didnt' see NT, boy NT blows. || || I hate how it doesn't list out the processes. || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Monday, June 04, 2001 1:18 PM || To: [EMAIL PROTECTED]; Christopher Spence || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || Look under ps. || || Really? On NT? || || Jared || || || Walking on water and developing software from a || specification are easy if || both are frozen. || || Christopher R. Spence || Oracle DBA || Fuelspot || || || || -Original Message- || Sent: Monday, June 04, 2001 11:56 AM || To: Multiple recipients of list ORACLE-L || || || Hi all, || I added db writer processes last week to try and || improve performance || of one || of my 8.1.7 db's on NT. Does anyone know if there is a || way to see if || Oracle actually started the additional db writer || processes? I added || db_writer_processes to the init file, the instance started so I am || assuming || that the db writer processes are working. But we all know || what happens || when we assume something. Any ideas would be appreciated. || || Sincerely, || Kevin Kostyszyn || DBA || Dulcian, Inc || www.dulcian.com || [EMAIL PROTECTED] || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Christopher Spence || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jerry C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT RE: TUSC and Kevin Loney
Fine. Rachel works for CattleButt || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 10:15 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT RE: TUSC and Kevin Loney || || || the heck you say! Good chocolate or none at all... Callebrut || || || || From: Mohan, Ross [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: OT RE: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 13:27:38 -0800 || || And Rachel works for Godiva. || || || -Original Message- || || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || || Sent: Monday, June 04, 2001 4:37 PM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: TUSC and Kevin Loney || || || || || || and Steven Feuerstein works for Quest || || || || || || From: Ron Rogers [EMAIL PROTECTED] || || Reply-To: [EMAIL PROTECTED] || || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || || Subject: Re: TUSC and Kevin Loney || || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || || || I just had a meeting with the TUSC organization in Atlanta || || GA. and Mike || || Ault now works for TUSC also. || || Ron Rogers || || ROR mª¿ªm || || || || [EMAIL PROTECTED] 06/04/01 02:51PM || || I guess I am the last to discover this, but Kevin now works || || for TUSC. || || || || || || 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] || mailto:[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 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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: Mohan, Ross ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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 download
Title: RE: 9i download Very suitable, it is a great machine, just don't plan on getting any upgrades cheap. Memory and DVD are astronomical priced. 256Mb would be better, but I believe you can run 9i on 128Mb. The blade is a nice machine, really nice for a workstation as it has USB and some newer features, but considerably smaller L1,L2 cache which makes it a bit slower for server type apps than say a U10. But it is still a great machine for the money, no questions there. Perfect for that task you mentioned. But i would recommend getting 128Mb additional. "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 05, 2001 10:16 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i download Paul and all others interested. Ebay seems to be a great source for used sun boxes, I've also noticed at sun's site they have a new workstation for $999. Now of course you'd probably need more ram but this setup looks like it can handle and run 9i, etc for testing purposes at home. Hardware guys out there could you determine if this is enough? Thanks. Ivan Rivera http://store.sun.com/catalog/doc/BrowsePage.jhtml?cid=60357catfocus=Desktops
RE: Difference in speed of sorting using index and non-index colu
An index on order by and group by columns speeds up your query. Prakash -Original Message- Sent: Tuesday, June 05, 2001 10:21 AM To: Multiple recipients of list ORACLE-L the order by Dear list, Someone ask me when Oracle is doing a sort, will it make a difference if we use indexed column and non-indexes column in the order by clause, my initial thinking was index only speed up the retrieval of data from disk, Oracle probably using other algorithm in sorting records, so indexing is not relevant in that case. Can someone shed light on this question. KC -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT: TUSC and Kevin Loney
...and, unless TUSC wants to open an office in Australia...or Steve wants to move to the States... but why are WE talking about Steve's career decisions?? -Original Message- Sent: Tuesday, June 05, 2001 11:00 AM To: Multiple recipients of list ORACLE-L as far as I know, Steve still works for Ixora, which is his own company From: Jeroen van Sluisdam [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 06:35:30 -0800 What about Steve Adams, does somebody know whether he joined some big company also? -Oorspronkelijk bericht- Van: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Verzonden: dinsdag 5 juni 2001 15:31 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: TUSC and Kevin Loney they aren't broken down quite like that -- Gaja works for Quest but is published by Oracle Press, Mike Ault is published by neither... From: Boivin, Patrice J [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: TUSC and Kevin Loney Date: Tue, 05 Jun 2001 03:45:24 -0800 If Quest and TUSC are attracting a number of high-profile people, they will probably survive the recession. : ) TUSC says they recently expanded, they used to be only in Chicago I think. They opened an office in Atlanta, and they have another one somewhere. I don't know as much about Quest. So what does this mean for O'Reilly Publishers, if all these good authors now fall under the wing of database consulting firms? Quest through O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish via O'Reilly. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systemes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Region des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 9:16 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' fame), Steven Feuerstein (of PL/SQL fame), And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike Ault, ... So is this coalition a viable alternative to the all-knowing Oracle Support Services? John Kanagaraj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
O'Reilly, was Re[2]: TUSC and Kevin Loney
Tuesday, June 05, 2001, 7:45:23 AM, Patrice Boivin wrote: BPJ So what does this mean for O'Reilly Publishers, if all these good authors BPJ now fall under the wing of database consulting firms? Quest through BPJ O'Reilly, and TUSC through Oracle Press? Steven Feuerstein used to publish BPJ via O'Reilly. I work for O'Reilly Associates now, so I can speak to this question somewhat. I honestly don't see that all this means much of anything to us. Most authors with a good publisher relationship will continue to write for their current publisher. Steven, for example, is currently working on some projects with us. I wouldn't expect to see Kevin Looney or Guy Harrison or any other author change publishers just because they went to work for a different consulting company. It's interesting though, that companies such as TUSC and Quest seem to have targeted high-profile Oracle authors. Aside from the fact that Kevin Looney and others are very good at what they do, I expect there's a significant marketing advantage to having an author or two on staff. Back when I worked for KPMG, I was once sent to create and manage a database for a troubled project. The fact that I had written a book went over very well with the client, and generally seemed to smooth my road. For example, non-technical client managers paid attention to me, and I was able to cut through the beaurocracy and get things done. Was I really any better than any other competent DBA? Probably not. My books just gave me instant credibility with management. I don't think Kevin Looney will spend all his time in the backroom wrestling with the software. He'll be out in front, dealing directly with clients, and selling his firm. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Wait a minute here. Why would oracle do a commit on your transaction just because it needs to do a checkpoint, logfile switch, or shutdown? What if errors occur during validation? Do you think Oracle will commit the data anyways? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: NT script question ???
Yeah, directly from the pharaoh Larry Wall the Magnificent. -Original Message- Sent: Monday, June 04, 2001 10:30 PM To: Multiple recipients of list ORACLE-L cripting tools? Mladen, is that some new Egyptian software? From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: NT script question ??? Date: Mon, 04 Jun 2001 16:20:49 -0800 Go to http://www.activestate.com, get perl, DBI DBD::Oracle and you'll have all the cripting tools that you'll ever need. Associative arrays, state of the art reuglar expressions, functions, format commands and well documented ways of accessing the oracle database from within a script (O'Reilly book). That version of perl supports Andy Duncan's Orac_DBA and Adam von Nieda's Oracletool (http://www.oracletool.com), two excellent DBA utilities with the unbeatable price. -Original Message- Sent: Saturday, June 02, 2001 7:15 PM To: Multiple recipients of list ORACLE-L Hi, I have couple of questions about bat file in NT 4.0 for Oracle 8.1.5. 1. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like backup_06022001121314 Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
OT RE: TUSC and Kevin Loney
Steve Adams works for Barnes and Noble partnering with Quest and TUSC? What about Rachel? || -Original Message- || From: Mike Killough [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 6:27 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || And tusc has a partnership w/ quest. Weird. tusc does a lot of their || recruiting at Barnes and Noble. I think Steve Adams is on || the hit list. || || || From: Rachel Carmichael [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:36:50 -0800 || || and Steven Feuerstein works for Quest || || || From: Ron Rogers [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || I just had a meeting with the TUSC organization in Atlanta || GA. and Mike || Ault now works for TUSC also. || Ron Rogers || ROR mª¿ªm || || [EMAIL PROTECTED] 06/04/01 02:51PM || I guess I am the last to discover this, but Kevin now || works for TUSC. || || || 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] || mailto:[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 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || --- || - || 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 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || --- || - || 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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 your FREE download of MSN Explorer at http://explorer.msn.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Mike Killough || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: how to run procedure containig REF CURSOR as datatype
Tom, Is REF CURSOR only available in Version 8? I can not get REF CURSOR to compile in Version 7. David -Original Message- Sent: Tuesday, June 05, 2001 7:01 AM To: Multiple recipients of list ORACLE-L Harvinder, change your script like this: declare io_cursor getrateschedules_pkg.t_cursor; == change the reference to the cursor declared in the package body. begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / we do this all the time for ref cursors used by VB. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, June 04, 2001 7:36 PM To: Multiple recipients of list ORACLE-L Hi, What value to pass as io_cursor in the following procedureHow to run the procedures containing REF CURSOR.. create or replace package GetRateSchedules_pkg as TYPE t_cursor is REF CURSOR; procedure GetRateSchedules( temp_id_acc int,acc_cycle_id int,default_pl int,RecordDate date,temp_id_pi_type int,io_cursor in out t_cursor); end; i am getting error when i run the following code: declare TYPE t_cursor is REF CURSOR; io_cursor t_cursor; begin getrateschedules_pkg.getrateschedules(1,2,3,sysdate,4,io_cursor); end; / ORA-01790: expression must have same datatype as corresponding expression. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 drop a system event trigger - endless loop?
go in through svrmgrl or connect via sqlplus using / as sysdba this will log you in without executing the trigger and you can then drop it From: Andor, Gyula [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to drop a system event trigger - endless loop? Date: Tue, 05 Jun 2001 07:20:38 -0800 Hi Gurus ! I created a trigger on logon event. The trigger seems to be falling into an endless loop, so I can't login. How colud I drop this trigger. I created this trigger with ON DATABASE clause. Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle Enterprise Manager
Standard OEM is free with all Oracle databases as far as I'm aware, you have to pay for the extra modules such as Performance Pack Diagnostics.. Mark -Original Message- Stubbs Sent: Tuesday, June 05, 2001 03:16 To: Multiple recipients of list ORACLE-L I am a little confused. Is the Oracle Enterprise Manager part of Oracle 8i (8.1.7) Standard Edition or do I have to pay extra for it? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
I usually read books that have different material than Oracle Documentation. -Original Message- Sent: Monday, June 04, 2001 9:40 PM To: Multiple recipients of list ORACLE-L Oracle8/8i DBA Handbook Author visit www.kevinloney.com He is pretty good in Oracle . - SathishB - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 7:35 PM Who is Kevin Loney? -Original Message- Sent: Monday, June 04, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 6:27 PM To: Multiple recipients of list ORACLE-L And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. From: Rachel Carmichael [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:36:50 -0800 and Steven Feuerstein works for Quest From: Ron Rogers [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 12:02:09 -0800 I just had a meeting with the TUSC organization in Atlanta GA. and Mike Ault now works for TUSC also. Ron Rogers ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 02:51PM I guess I am the last to discover this, but Kevin now works for TUSC. 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] mailto:[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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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:
RE: OT RE: Database writer
No winner! I drink the freaking beer all by myself. I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa! (Jefferson Starship) || -Original Message- || From: Jerry C [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, June 05, 2001 11:32 AM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT RE: Database writer || || || So... no winner Ross? || || Do we get the answer?? || || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 04, 2001 4:25 PM || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || (1st one to name that song lyric reference and i buy you a beer. || NT bigots and their families summarily excused from this offer.:) || || || -Original Message- || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || Sent: Monday, June 04, 2001 2:16 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: Database writer || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || I hate how it doesn't list out the processes. || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 1:18 PM || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || Look under ps. || || || || Really? On NT? || || || || Jared || || || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 11:56 AM || || To: Multiple recipients of list ORACLE-L || || || || || || Hi all, || || I added db writer processes last week to try and || || improve performance || || of one || || of my 8.1.7 db's on NT. Does anyone know if there is a || || way to see if || || Oracle actually started the additional db writer || || processes? I added || || db_writer_processes to the init file, the instance || started so I am || || assuming || || that the db writer processes are working. But we all know || || what happens || || when we assume something. Any ideas would be appreciated. || || || || Sincerely, || || Kevin Kostyszyn || || DBA || || Dulcian, Inc || || www.dulcian.com || || [EMAIL PROTECTED] || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Christopher Spence || || INET: [EMAIL PROTECTED] || || || || Fat City Network Services-- (858) 538-5051 FAX: || (858) 538-5051 || || San Diego, California-- Public Internet access / || || Mailing Lists || || || || || 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: Mohan, Ross ||INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || || 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!? || Get your free @yahoo.com address at http://mail.yahoo.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jerry C || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || 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: Thanks everyone - tru64
Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT RE: TUSC and Kevin Loney
Title: RE: OT RE: TUSC and Kevin Loney Come on, Ross. The real question is who do YOU work for. Are you an idiot? Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Subject: OT RE: TUSC and Kevin Loney Steve Adams works for Barnes and Noble partnering with Quest and TUSC? What about Rachel? || -Original Message- || From: Mike Killough [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 6:27 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || And tusc has a partnership w/ quest. Weird. tusc does a lot of their || recruiting at Barnes and Noble. I think Steve Adams is on || the hit list. || || || From: Rachel Carmichael [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:36:50 -0800 || || and Steven Feuerstein works for Quest || || || From: Ron Rogers [EMAIL PROTECTED] || Reply-To: [EMAIL PROTECTED] || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Subject: Re: TUSC and Kevin Loney || Date: Mon, 04 Jun 2001 12:02:09 -0800 || || I just had a meeting with the TUSC organization in Atlanta || GA. and Mike || Ault now works for TUSC also. || Ron Rogers || ROR mª¿ªm || || [EMAIL PROTECTED] 06/04/01 02:51PM || I guess I am the last to discover this, but Kevin now || works for TUSC. || || || 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] || mailto:[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 FAX: (858) 538-5051 || San Diego, California -- Public Internet access / || Mailing Lists || --- || - || 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 FAX: (858) 538-5051 || San Diego, California -- Public Internet access / || Mailing Lists || --- || - || 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 your FREE download of MSN Explorer at http://explorer.msn.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 FAX: (858) 538-5051 || San Diego, California -- Public Internet access / || Mailing Lists || || 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
Re: How to drop a system event trigger - endless loop?
Yeah, another one ;) Before several months already somebody in this list faced this problem ;) If there is an error in a LOGON Trigger, nobody (not even SYS) may connect to the database. Connect with INTERNAL and drop the trigger may help in this situation. Gints Plivna Andor, Gyula To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] gy.andor@eurcc: omacc.huSubject: How to drop a system event trigger - endless loop? Sent by: root@fatcity. com 01.06.05 18:20 Please respond to ORACLE-L Hi Gurus ! I created a trigger on logon event. The trigger seems to be falling into an endless loop, so I can't login. How colud I drop this trigger. I created this trigger with ON DATABASE clause. Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Remedy Action Request System
Anyone know of a db monitoring tool that can integrate with Remedy AR? Thanks. === 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: iAS installation update
Patrice, I've installed 9iAS successfully, what I've done is just run the installer from the CD and on a new machine (virgin OS install) I selected all the defaults, and guess what everything work. In turn 9iAS created an ORACLE home in which there is a 806 and an iSuites directory, apparently when they say the 806 home what they refer to is that directory, the 806 directory seems to be where the tool set (Forms/ Reports) are housed and the iSuites where the Apache server and that stuff is. On a machine with a whole bunch of other ORACLE products, such as DEV 1.6 (FORMS 4.5 / Reports2.5), Designer 2000, Developer 6i and Personal Oracle 8.1.7, I've chosen a different home for each product and everything works fine. Of course a bunch of stuff is duplicated, but who cares Hard drive is cheap, the main thing is that everything works as advertised. When I tried installing everything on default Oracle homes nothing worked and it was a nightmare. My experience from the installs. Good luck Tavo Boivin, Patrice J wrote: FYI, I logged a TAR with Oracle last week or so because one Metalink tech had said in passing that Forms and Reports had to go into its own, separate oracle_home. This follows from a previous TAR I had logged with them, simply asking which products work best together. I had read the installation manual for iAS and had earlier found this: Note: Be sure not to install Oracle9i Application Server in an Oracle_home containing other Oracle products, including the database. Such an installation could overwrite shared components, causing the products to malfunction. (on p. 3-5, 4-5, 5-5). Now, in Oracle Reports Developer Getting Started - Release 6i for Windows, it says: Reports Developer 6i must reside in the default oracle_home. Reports Developer 6i and the Oracle8 or Oracle8i server must reside in separate oracle_Homes, although they can reside on the same physical machine. Similarly, in a web application deployment, Report Server and Oracle Application Server must reside in separate oracle_homes, although they can reside on the same physical machine. (p.1-16) Forms and Reports 6i happen to require an Oracle 8.0.6. oracle_home. This posed a dilemma: how can I install iAS in the default home, when many of its components require access to an origin database. I do not plan to use iAS with 8.0.6., I plan to use it with 8.1.7.. I thought I would have to install Forms and Reports 6i first, remove the tidbits that the Oracle Universal Installer installs by default, then install 8.1.7., and then install the iSuite components. Of course by the end of this tortuous process there were errors. I had a different Metalink technician this time, who told me to ignore what the first technician had said, and to just install iAS based on the installation manual, never mind the other worries that I had. So, I am ignoring the Oracle Reports Developer Getting Started manual, and I am installing based on the iAS installation manual. Hopefully that will work. /begin rant I still wish the Oracle techs could have told me which versions of the various products are concurrent, they just keep insisting that all their products are certified to work together. All I wanted to know was which oracle_home type do the various products use? Forms and Reports 6i requires an 8.0.6. home, Developer6 used an 8.0.5 home, etc. the Metalink techs do not appear to have a list, they didn't understand my question. When I logged a TAR on this I received three e-mails telling me that my TAR had been passed to different people, in the end the last tech told me that products sometimes are released together, but that it is not all that important, because everything is certified to work together. I can't shake the feeling that iAS is a bundle of things that were just slapped together. Seeing the old installer pop up during the installation doesn't help remove that impression. Hopefully when the next release comes out it will install in something other than an (old) Oracle 8.0.6. oracle_home. Since it's called Oracle9i iAS, maybe the Forms and Reports Servers will go into a 9i oracle_home (?). /end rant (this is my impression, not my employer's etc. etc.) Sorry if this comes across as a little harsh. 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] mailto:[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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
(Fwd) ERPcentral Journal Vol.4, No.23
--- Forwarded Message Follows --- ERPcentral - http://www.erpcentral.com Oracle slashes prices in Japan. Global cuts next? http://www.erpcentral.com cw360.com June 4, 2001 Oracle could be on the verge of announcing significant price cuts around the world after its Japanese operation slashed database prices this week. The company is refusing to comment on speculation, saying chief executive officer Larry Ellison will be making a major pricing announcement to coincide with the launch of the 9i database at Oracle OpenWorld later this month. Oracle confronts pricing, user issues http://www.erpcentral.com Computerworld June 4, 2001 Cuts pricing in Japan Dan Verton, Computerworld Oracle Corp.'s Japanese unit last week slashed prices for the company's database software by 25 percent and increased volume discounts to 35 percent, raising hopes among U.S. users that the cuts herald lower prices here. Street Fight: Oracle http://www.erpcentral.com Forbes.com, June 4, 2001 With sagging earnings and lack of guidance for its soon-to-be-announced fourth quarter, Oracle has been slapped with no less than nine analyst downgrades since early March. Shares of the database software provider have dropped 67% from their 52-week high, giving the stock a latest 12-month price-to-earnings ratio of just 14. Is it time to buy America's second-largest independent software concern? --- If you enjoy reading ERPCentral's Newsletter, please tell a friend or colleague about it. Anyone can sign up for a free subscription on our Web site at http://www.erpcentral.com (c) Copyright 2000 Idem Est Technologies Ltd. All rights reserved. All product names contained herein are the trademarks of their respective holders. __ To unsubscribe, write to [EMAIL PROTECTED] --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 drop a system event trigger - endless loop?
Couldn't you just start svrmgrl and "connect internal"? --Michael -Original Message- Sent: Tuesday, June 05, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hi Gurus ! I created a trigger on logon event. The trigger seems to be falling into an endless loop, so I can't login. How colud I drop this trigger. I created this trigger with ON DATABASE clause. Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenkins, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
Quite interesting, can I join as well? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 05, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hi All, No, I'm waiting for Henry to announce the details of the commercial DBA union! The pre-announcement is at http://www.lazydba.com/xcomment.pl?discussions:6 @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ PS. This is a joke for the benefit of those who have been following the LazyDBA issues. -Original Message- Sent: Wednesday, 6 June 2001 0:35 To: Multiple recipients of list ORACLE-L What about Steve Adams, does somebody know whether he joined some big company also? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: UTL_FILE pkg related issue
The term of NUMBER OF ROWS is not quite appliable in case of binary file. Anyway wc -l yourfilename (i suggest you are in unix shell , otherwise you can compile the '\n' counter like this -- #include stdio.h main() { int counter=0,c; while((c=getchar())!=EOF) if(c=='\n') counter++; printf(%d\n,counter); } - ) HTH Maxim Demenko Database Specialist LOYALTY PARTNER GmbH Landshuter Allee 12-14 80637 München Tel: +49(0)89-99741-628 Fax: +49(0)89-99741-629 email: [EMAIL PROTECTED] www.loyaltypartner.com www.payback.de -Ursprüngliche Nachricht- Von: Vikas Kawatra [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 4. Juni 2001 21:32 An: Multiple recipients of list ORACLE-L Betreff: UTL_FILE pkg related issue I use the UTL_FILE pkg to read a bin file and load the data into our database tables (insert or update) . The program works fine - but since we do updates too- we would like to protect out table - by checking the no of rows in the input file - The file has a Header and Tail - CAn someone suggest - how I can scan the binary file - and count the no of rows - before - processing the file ? thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Maxim Demenko INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Re: RE: How to prevent oracle from committing a transaction?
Bastards. You are totally right. I have tested and RTFM'd but the later doesn't specify when the change occurred. Should read release notes more often. Anybody has an idea about when it happened? 6.0.32 ? Please comfort me : exiting from a Pro*C program without calling EXEC SQL COMMIT|ROLLBACK WORK RELEASE (I hope it's not obsolete syntax, I have not used Proc*C for years) still does a rollback, does it ? Stephane Faroult Oriole Corporation Yeah, that's what I was going to suggest. QUIT used to do an exit without a commit, but now it commits it just like EXIT does. I wonder why they changed that? Now they are just synonyms of one another. Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] sfaroult@orio le.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Fax to: com Subject: Re: RE: How to prevent oracle from committing a transaction? 06/05/2001 05:40 AM Please respond to ORACLE-L Alternatively, you can also use QUIT. Stephane Faroult What you're seeing is an implicit commit !To prevent it - before exiting the session , issue ROLLBACK; then EXIT vikas -Original Message- Sent: Tuesday, June 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12
OPS and Veritas Cluster Server
Has anyone used Veritas Cluster Server software for Oracle? Can OPS be implemented using this or is best to use OS supplied clustering. Thanks mkb __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mohammed bhatti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
Commit will take place after any DDL statement. Besides that, Oracle Complete Reference by George Koch and Kevin Loney states that commit will occur after you execute the following commands: exit, quit, and even connect. If you are worried about unmanaged commits after the sudden instance crash then don't worry it won't happen. Oracle will roll everything back after the instance comes back up. As to commits occurring due to the 'exit' command it seems it is not possible to stop. But you have control in that situation. Just before typing 'exit' type 'rollback' and no changes will take place. Hope this helps, and please correct me if I am wrong. -Original Message- Sent: Tuesday, June 05, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Wait a minute here. Why would oracle do a commit on your transaction just because it needs to do a checkpoint, logfile switch, or shutdown? What if errors occur during validation? Do you think Oracle will commit the data anyways? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 prevent oracle from committing a transaction?
I did not try it but what if we have a trigger on logoff which will raise application error. Alex Hillman -Original Message- Sent: Tuesday, June 05, 2001 5:05 AM To: Multiple recipients of list ORACLE-L Ranganath, AFAIK, this can't be done. A normal exit has an implied commit. Perhaps someone else can suggest a way to do this programmatically. HTH, -- Anita --- Ranganath K [EMAIL PROTECTED] wrote: Dear DBA Gurus, Can you tell me how to prevent oracle from committing a transaction unless I explicitly commit it. I have observed that when I insert a record into a table and type exit from the sql prompt without commiting the transaction and again open a new sqlplus session and select from that particular table the record is inserted. How do I prevent oracle from inserting into a table unless I explicitly specify commit? Please note that I have set my sqlplus session as autocommit off. I tried with alter table tablename nologging but it didn't do what I wanted. Can anybody help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Oracle Enterprise Manager
I had problems getting the OEM to function properly. I was using OEM 2.2 r3 with an 8.1.6 database. I removed the OEM 2.2 r3 and installed OEM 2.1 and it worked great. I remember reading a versions grid on OTN that had OEM 2.1 with 8.1.6 and OEM 2.2 with 8.1.7. It could be you have a version miss-match also. ROR mª¿ªm [EMAIL PROTECTED] 06/05/01 11:36AM Standard OEM is free with all Oracle databases as far as I'm aware, you have to pay for the extra modules such as Performance Pack Diagnostics.. Mark -Original Message- Stubbs Sent: Tuesday, June 05, 2001 03:16 To: Multiple recipients of list ORACLE-L I am a little confused. Is the Oracle Enterprise Manager part of Oracle 8i (8.1.7) Standard Edition or do I have to pay extra for it? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Stubbs INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: OT RE: TUSC and Kevin Loney
On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -Fine. - -Rachel works for CattleButt ZOT ;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You might have mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: TUSC and Kevin Loney
Do we get a bumper sticker? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 1:21 PM To: Multiple recipients of list ORACLE-L Subject:RE: TUSC and Kevin Loney Quite interesting, can I join as well? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 05, 2001 11:21 AM To: Multiple recipients of list ORACLE-L Hi All, No, I'm waiting for Henry to announce the details of the commercial DBA union! The pre-announcement is at http://www.lazydba.com/xcomment.pl?discussions:6 @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ PS. This is a joke for the benefit of those who have been following the LazyDBA issues. -Original Message- Sent: Wednesday, 6 June 2001 0:35 To: Multiple recipients of list ORACLE-L What about Steve Adams, does somebody know whether he joined some big company also? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).