RE: Bye...
drop list ORACLE-[EMAIL PROTECTED] \rm r FATCITY bye -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, January 30, 2004 5:24 PM To: Multiple recipients of list ORACLE-L Subject: Bye... bye...
RE: ** field names of a ref cursor
Thats what XML is for :P -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A Joshi Sent: Sunday, January 25, 2004 10:19 PM To: Multiple recipients of list ORACLE-L Subject: ** field names of a ref cursor Hi, I am calling a Oracle stored procedure which has a ref cursor as a out param. I get the values. Is there a way for me to know the field names and type of the fields being passed in the ref cursor. Basically when the procedure sends back the ref cursor what information do I get apart from the data. Do I get any metadata (field names types etc). This is basically to write a calling program which I do not have to change when the ref curor /record changes in the stored procedure. Thanks in advance. Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it!
RE: internet secure solutions
Something important to take into account when talking about security, is the problem with if you don't know it's happening you can't stop it... .. Remember to read/analyze logs for unusual stuff (Oracle or FW logs)... preferably with an IDS, as it makes the job of finding out whether you have a security breach a whole lot easier. -Original Message- Pete Finnigan Sent: Saturday, January 10, 2004 2:59 PM To: Multiple recipients of list ORACLE-L Hi Paula, Paul and Steve have given some good ideas on this but also you should lock down the database as hard as you can. Even if the database is only accessed via the application server its data is still available from the internet. Issues such as SQL Injection and cross site scripting can come into play. use least privilege principles and remove all excess privileges. There are many papers on Oracle security on my site http://www.petefinnigan.com/orasec.htm including some very good checklists. You will find the SANS S.C.O.R.E. and cisecurity benchmarks linked in the checklist section of this page. Both follow the SANS step- by-step quite closely. Also if the server the application server is on is breached then the database is in much bigger trouble from the DMZ than it would normally be from the net. You need therefore to ensure that the application server is also hardened. Have a look at the cisecurity OS benchmarks as well as a start for hardening the OS. Encrypting the data between the application server and database is admirable and an extra expense but there are other issues to look at as well. As Steve said firewalls are needed. If your application allows it data wise / operationally then it can sometimes be better to not expose the database at all to the net but expose a subset of data that is needed by your net based users. Do this by replicating the relevant data to a second database and expose that to the application server. two way replication could be needed depending on what your application does. anyway have a look at some of the Oracle security info on my site http://www.petefinnigan.com/orasec.htm including SQL injection papers, and checklists etc - it might help you. hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - RE: Re: Who are certified Oracle Masters?
Woooh . waiting for ROTK here too ;) The execs finally let Peter Jackson show the full version in the Cinema . See.. even in the Movie Biz, damagement rears its ugly head .. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Drake Sent: Monday, December 15, 2003 4:25 PM To: Multiple recipients of list ORACLE-L Subject: OT - RE: Re: Who are certified Oracle Masters? how scary would it be to arrive at the exam, and the inquisitioner is dressed as Gandalf. Right after he hands out the exam he slams his staff to the floor and screams NONE SHALL PASS. I'm looking forward to the midnight showing of LOTR - ROTK tomorrow night. The movie is 3 hours, 42 minutes - hope the previews are short. Hope there aren't any emergencies on Wednesday morning as I doubt that I'll be in before noon. Pd Pete Sharman [EMAIL PROTECTED] wrote: http://www.oracle.com/education/certification/index.html?dba9i_ocm.html Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Akshay Kumar Sent: Tuesday, December 16, 2003 7:44 AM To: Multiple recipients of list ORACLE-L What were you expected to do in the final exam ? - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent: Friday, December 12, 2003 8:59 AM how many people are actually OCMs? and those of you that are, has it helped you in getting work? From: Richard Foote <[EMAIL PROTECTED]> Date: 2003/12/12 Fri AM 07:54:26 EST To: Multiple r! ecipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Who are certified Oracle Masters? Hi Robert, That's all very interesting. The various press releases at the time (e.g. http://www.dulcian.com/PRESS%20RELEASE_OCM.htm) all suggest that the 6 best Oracle experts in the world were handed these prestigious awards. Even the TUSC website only makes mention of these awards being handed to Mr Niemiec. If he indeed actually took and passed the practical exam in person, and if obtaining OCM status is as prestigious as the marketing makes it out to be, then I would recommend Mr Niemiec perhaps promote his hands-on involvement a little more (rather than the handed hands-off bit) as this I'm sure all comes as news to many. g! t; It's actually a very brave thing to have done when you think about it. It's a little bit like being given a brand new car as a present and saying oh no no, I want to prove I can drive it first. It's all great if you pass the driving test but if you were to fail, boy, would you look silly holding those car keys ;) Did he have any such reservations ? Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 8:29 AM As I recall Rich talking about it, he did indeed take the exam. It was not just handed to him. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/11/2003 3:59 PM you mean niemic didnt actually have to take the test? It was just handed to him? who is jeremiah wilton? - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, December 11, 2003 4:09 PM IIRC, Tanel did the OCM as well, but I suspect most of the others on your list aren't prepared to waste their time attending OCP exams and courses just so they can get the OCM. :) There were some honorary OCM's announced when the program first started (OOW2002?). From memory, Rich Niemic and Jeremiah! Wilton are the only names that spring to mind from that group. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mladen Gogala Sent: Friday, December 12, 2003 7:54 AM To: Multiple recipients of list ORACLE-L I know only of Pete Sharman. Who are other Oracle Certified Masters on this group? I suspect Tanel to be one, as well as Steve Adams, Cary Millsap, Mogens Norgaard, Anjo Kolk, Wolfgang Breitling, Gaja V. and Kirti Deshpande. Am I correct? Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
RE: Problem with Null Valuies (grin!)
He won a British award for that one ;) It beat the Schwarzenegger quote I think that gay marriages should be between Men and Women ... interesting point of view. (I live in California by the way :S) -Original Message- Robson, Peter Sent: Thursday, December 04, 2003 2:39 AM To: Multiple recipients of list ORACLE-L It is not only database designers who have these problems - check out this extraordinary verbatim quote from a certain well known international politician... Reports that say that something hasn't happened are always interesting to me, because as we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns - the ones we don't know we don't know. Who? None other than US Defence Secretary Donald Rumsfeld. peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl / MySQL
I agree ... the lack of SP in mysql (soon to be released in the new version) is really not acceptable ... this is going to really help !! Not that I use mysql or anything ... really ... honest ... :) (oh smeg!!) -Original Message- DENNIS WILLIAMS Sent: Tuesday, December 02, 2003 8:00 PM To: Multiple recipients of list ORACLE-L Now we know MySQL is really ready to give Oracle some competition: Perl Interface to MySQL by Russell J.T. Dyer http://click.unixreview.email-publisher.com/maabITzaa2A6Ea2sdufb/ In the December installment in his MySQL series, Russell reviews the basics of building a MySQL interface with Perl. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XML Sctructure
That works fine I don't know what the problem is .. as long as you have a unique root element, then there should be no problem. -Original Message- Sami Sent: Sunday, November 30, 2003 6:19 AM To: Multiple recipients of list ORACLE-L More than one line of what? Do you want to try something like below? ?xml version=1.0? !-- Exemplo de XML Endereco-- !DOCTYPE lista_endereco SYSTEM lista_endereco.dtd lista_endereco endereco titulo rodolfo do Carmo Andrietta/titulo primeironomeEriovaldo/primeironome ultimonomeAndrietta/ultimonome logradouroR Um/logradouro cidadeSao Paulo/cidade estadoSP/estado cep01680-000/cep /endereco endereco titulo rodolfo do Carmo Andrietta/titulo primeironomeEriovaldo/primeironome ultimonomeAndrietta/ultimonome logradouroR Um/logradouro cidadeSao Paulo/cidade estadoSP/estado cep01680-000/cep /endereco /lista_endereco -Original Message- ecaforum Sent: Sunday, November 30, 2003 3:39 AM To: Multiple recipients of list ORACLE-L Hi friend, HI know that this forum is about Oracle, but i have a doubt and i think thay someone can help me . I have the xml sctructure below. XML : ?xml version=1.0? !-- Exemplo de XML Endereco-- !DOCTYPE lista_endereco SYSTEM lista_endereco.dtd lista_endereco endereco titulo rodolfo do Carmo Andrietta/titulo primeironomeEriovaldo/primeironome ultimonomeAndrietta/ultimonome logradouroR Um/logradouro cidadeSao Paulo/cidade estadoSP/estado cep01680-000/cep /endereco /lista_endereco DTD !-- lista_endereco.dtd -- !ELEMENT lista_endereco (endereco) !ELEMENT endereco (titulo, primeironome, ultimonome, logradouro, cidade, estado, cep) !ELEMENT titulo (#PCDATA) !ELEMENT primeironome (#PCDATA) !ELEMENT ultimonome (#PCDATA) !ELEMENT logradouro (#PCDATA) !ELEMENT cidade (#PCDATA) !ELEMENT estado (#PCDATA) !ELEMENT cep (#PCDATA) My question is : How can i do for use DTD and put more than 1 line in XML ? Because like that, if i put one more line in xml it says that file is invalid. Any clue ? Thanks. Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: ecaforum INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sami INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: .NET, connection pooling and security .
Well ... in general it's the apps that manage the system security, and the DB users are there to prevent the app users from doing damage, but in general these two work in unison. I have not seen any decent ways of having the DB administer users without there being a serious overhead, in terms of administration duties, for the DBA (which is what Jared mentioned). I say that, given the information you provide, sticking with the two types of roles (owner and user) is the most adequate way. Why would you want to change this anyway? My 3.14159 pence worth. -Original Message- Jared Still Sent: Saturday, November 29, 2003 9:15 PM To: Multiple recipients of list ORACLE-L Steve, I'm not a web developer either, but I do know that this is a very common method of handling the database connections. Many 2 tier apps work this way as well. SAP for example. Unless you have influence on the architecture and can present a convincing argument, you best learn how to work with it. You don't give any details about the app either. Are users required to authenticate? If not, what would be the point of requiring db accounts for them? The number of users is important as well. Imagine a web app that services 250k users. Do you really want that many users in the data dictionary? Would you want the DDL overhead of creating/administering that many users? I'm considering some extremes, because there were no details provided. HTH Jared On Sat, 2003-11-29 at 19:49, Steve Perry wrote: I hope somebody on the list can help me out with this. All of our 3-tier apps are architected with a schema owner (owns all objects used by an application) and application user (no create privs, but it does have full dml privs to the schema owner objects). On the web side, connection pooling is setup with 10 connections logged in (all as the application user). When users connect, the application reads some active directory keys that tell if the user is a reader, dml user or admin user (all privs). I don't feel the application should be managing security and I'd like to take that responsibility away. The 10 identical connections logged into the database bothers me too. I'd like to make it work similar to our 2-tier apps where we use roles, assign them to a user and they connect individually. We don't have OID setup and I imagine that would solve this. Short of that, is there any other way to work around having the 10 identical connections logging in and having the application maintaining security? Is there another way of assigning the security? I don't have any web development experience and I thought I'd check here first to see how others deal with this. I hope somebody else has worked this out at their shop. I'm not sure if the answers will change, but it's an all M$ shop, except for Oracle. Any help would be appreciated. Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve Perry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send messages to other users
Isn't the wall utility used to send a message to everyone in Unix/Linux? i.e wall This Database will Self Destruct in 5 seconds (although the utility has been removed from some systems due to some security problems a.k.a root exploit) p.d : What's Outlook Express??? ;) -Original Message- Mladen Gogala Sent: Tuesday, November 25, 2003 6:39 PM To: Multiple recipients of list ORACLE-L BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in advance and put the maintenance times on your internal web page. The chosen times should be offpeak so that the normal business can continue. When you inform everybody and schedule downtime in advance, then you simply shut the database down, say, on Saturday, 18:00 hours. In other words, your problem is organizational, not technical. If you need to shut the database down immediately for whatever reason there is a gadget called a telephone. It works like this: every company has a person called CIO (stands for Career Is Over). When you need to shut down a database that is critical for business during the working hours then you tell your boss to call the CIO, and if he's not around, you tell your boss/director to page him (they usually cary beepers). He will then either inform his peers in the business process or schedule a conference call to pass the good news to the business. You are probably going to be on that conference call so better be prepared to argue why is shutting down the database critical or you will be in a very bad predicament. After that, no further information is necessary. You just do what needs to be done. In other words, shutting down an important database is not a DBA decision but a decision made by people who manage the normal business process. Those people are sometimes referred to as management. They are the ones who make decisions and define schedule. On 2003.11.25 20:49, [EMAIL PROTECTED] wrote: hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Version 8 as read only
Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was 8i. Does anybody have any pointers on how I could accomplish this. Thanks Darren. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send messages to other users
I think that you're going to have to take Mladen's advice and send an Email to everyone -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 5:14 PM To: Multiple recipients of list ORACLE-L i can't use net send since not all users in the same local network. i can't also wall since all users are using win98. do u know any 3rd party software like winpop(forlocal network) that can send messages across the network? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: nelson flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i installation
Or in scripts wherever you see a jre.exe, you add a nojit to the command. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yechiel Adar Sent: Monday, November 24, 2003 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 8i installation There is a problem installing oracle 8i on P4 machines. Copy the installation CD to the hard disk. Search for file named symcjit.DLL and rename to symcjit.old. Run the installation from the hard disk. Yechiel Adar Mehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Monday, November 24, 2003 1:59 PM Subject: Re: Oracle 8i installation what do you mean by JIT file?? how can i solve my problem? - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Monday, November 24, 2003 12:14 PM Subject: Re: Oracle 8i installation OOPs - It is JIT file. Yechiel Adar Mehish - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 5:49 PM Subject: Re: Oracle 8i installation First I second Mladen recommendation to install 9.2. IIRC there is one KIT file on the installation disk that you need to rename for the installation to succeed. Also you can use lsnrctl to install the listener service. do: lsnrctl start listener and it will install the service for you (if the service does not exist, at least in 9i). Yechiel Adar Mehish - Original Message - From: Mohamed Kamal To: Multiple recipients of list ORACLE-L Sent: Sunday, November 23, 2003 10:44 AM Subject: Oracle 8i installation Hi Group, I'm trying to install Oracle 8i in my computer(Windows 2000),after installtion it gives me this error jrew.exe has generated errors and will be close by woindows java.exe has generated errors and will be close by woindows and i can't found listener service in services so i can't conect to the database can you help me ? thanks M.Kamal
RE: Grid news
It's kind of like the SETI project... for those of you that don't know what this is, it's a project where NASA has images that need to be analyzed, but don't have the computing power to do it all in a reasonable time. So they created a system where they distribute the processing of the images over n workstations, each running a separate part of the process. The main problem with this (which I noticed at my university where every single unix workstation had the SETI app running), was the fact that it slowed the machine down (they didn't use the nice command to only use idle time). The question related to all these Grid apps is how they are going to distribute the priorities for the jobs being done. If a general manager needs something ASAP, then do all we lesser mortals have to suffer? Oh well ... food for thought. -Original Message- DENNIS WILLIAMS Sent: Thursday, November 13, 2003 8:50 AM To: Multiple recipients of list ORACLE-L Oracle has announced 10 will be 10g for grid. Many of us have been baffled by what grid is, will it be useful in the real world, etc. Here is a short article on a practical grid application (non Oracle) http://zdnet.com.com/2100-1104_2-5106230.html Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Can I execute an exe from a stored Procedure
LOL ;) -Mensaje original- De: Mladen Gogala [mailto:[EMAIL PROTECTED] Enviado el: martes, 07 de octubre de 2003 9:59 Para: Multiple recipients of list ORACLE-L Asunto: Re: Can I execute an exe from a stored Procedure No problem! Just open any email entitled Latest security patch from MIcrosoft and you'll execute an .exe file. On Mon, 2003-10-06 at 18:34, Jake Johnson wrote: Hello, Is it possible to execute an exe from a stored procedure? If so can you please provide an exmple? Thanks Jake -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to give permission
If you can't do a chmod 755 XXX, then you can´t do this ... you don't have enough privileges... Do a su root (if you can), or ask the owner of the files to do the chmod ... BTW, Chmod 755 isn't enough, I think you need a 777 ... (my chmod numbers are a little hazy) (is this an oracle related question???) Also, for further reading Man chmod Man RTM Man man ;) -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviado el: viernes, 12 de septiembre de 2003 10:04 Para: Multiple recipients of list ORACLE-L Asunto: How to give permission Hallo, anyone whom could help me with a unix command how to give permission to delete files from a special directory? I am trying to use chmod command but it doesnt work with chmod 755 It says permission denied then. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: asp page errors, odbc drivers for Oracle
Do you have any more info?? If it's a variable problem, then try tracing (response.write) the global variable locally, if it shows nothing, then that's the problem (IIS acting childish again!!), if it does then check the connectivity by testing ODBC... I've had no problems with either Microsoft or Oracle drivers... so I'm guessing it's got something to do with ASP... If all else fails then you could use ODBCSPY (I think it's owned by a company called Intercept now), which is an ODBC sniffer. With this you can see if your DB calls are going through correctly. HTH. -Mensaje original- De: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Enviado el: jueves, 11 de septiembre de 2003 9:39 Para: Multiple recipients of list ORACLE-L Asunto: asp page errors, odbc drivers for Oracle I have been struggling with an asp-based IIS web application one server, it is tarting to look like a global asp variable is not being passed down to a local asp variable. Has anyone ever seen this type of thing before? I have had a number of problems with this system, I am starting to wonder how compatible IIS asp and ODBC are with Oracle 8i. The Microsoft tech pages on ole_DB for Oracle, ODBC driver for Oracle, are not as up to date as I would like, looks like the last time they tested anything against Oracle was at versions 7.3, 8.0, and 8.1.7.0.0.. Oracle already mentioned to me that I should be using Oracle ODBC drivers, but the 3rd party vendor is telling me to use the MS Driver for Oracle because that is the best driver for IIS. Do you know of any web pages or links that would provide more info on how to configure / troubleshoot IIS and asp when connecting to Oracle? Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: RE: DB2 has a foot in the door
, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT -- Boston Globe job listings
this definite shift here in the Minneapolis / St. Paul, MN area over the past couple of years. Most of these companies also provide e-mail service that sends you an email when a job is posted that meets your specs. So, why waste your time on newspaper ads that only appear every Sunday? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 6:34 AM I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two years ago it wasn't uncommon to see eight or more per week, now I tend to see one or two, or none. For a while they also announced big IT job fairs, I don't know if they still do that or how successful they now are. The market has really shrunk in two years! There can't be a huge glut of DBAs out there looking for work... It must be a reduction in demand because companies are not making big infrastructure changes anymore. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PERL reference
O'reilly perl in a nutshell -Mensaje original- De: Bala Regupathy [mailto:[EMAIL PROTECTED] Enviado el: viernes, 08 de agosto de 2003 16:34 Para: Multiple recipients of list ORACLE-L Asunto: PERL reference Pardon me if you have already come across this, can anyone please suggest a good book on PERL for beginners. Thanks, Bala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bala Regupathy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [stupid] vi question
Two ways 1. :s/^M//g (where the ^M is CTRL-V M) 2. dos2unix inputfile outputfile -Mensaje original- De: Saira Somani-Mendelin [mailto:[EMAIL PROTECTED] Enviado el: miércoles, 06 de agosto de 2003 13:09 Para: Multiple recipients of list ORACLE-L Asunto: OT: [stupid] vi question Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i - Dynamic SGA - SGA_MAX_SIZE
must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jessica Mao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
And it takes longer to install ;) -Mensaje original- De: Igor Neyman [mailto:[EMAIL PROTECTED] Enviado el: lunes, 04 de agosto de 2003 11:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle to MSSQL conversion? For once, there are many more buttons to push when configuring/tuning Oracle instance/db (I'm not talking about GUI here -:). And, many more options when designing db. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Monday, August 04, 2003 7:15 AM To: Multiple recipients of list ORACLE-L SNIP Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Interesting, why is it more difficult to go from SQL Server to Oracle than the other way around? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfe Stephen S GS-11 6 MDSS/SGSI INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle to MSSQL conversion?
An SQL Server instance IS the Server... -Mensaje original- De: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Enviado el: jueves, 31 de julio de 2003 13:39 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle to MSSQL conversion? I haven't heard of an SQL Server instance before... do you mean a SQL Server server? (this is getting a bit confusing) Patrice. -Original Message- Sent: Thursday, July 31, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remote DBA
Chris, No i haven´t tried TightVNC... I'll go and check it out ... Also I forgot to mention that there is an excellent client SW that permits a Linux/unix box to connect to a Windows 2000 Terminal Server. If anyone is interested, go to http://www.rdesktop.org/.. Pretty impressed with it ... :) Nelson Flores Project Manager INTEC -Mensaje original- De: Jesse, Rich [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 03 de Abril de 2003 10:54 Para: Multiple recipients of list ORACLE-L Asunto: RE: Remote DBA Nelson, have you tried the free TightVNC from http://www.tightvnc.com ? It has a few performance features that seem to work slightly better than the standard VNC, especially over slower links like VPN over a 768Kb DSL. I've been about as happy as I can be with TightVNC for my setup. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, April 02, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Chris, VNC and OpenSSH are slow and VNC is still a little unstable (IMHO), I personally manage my windows 2000 Oracle DB with a VPN and then a Terminal server window direct to my desktop - from there I have all the tools that I usually have - notepad, mspaint, dir :). I hate to have to plug windows products, but if it were linux or unix, then it would be a different story, seeing as though it matters little where you are physically on a Linux/Unix box (SSH Telnet, or an XWindow Session with the display set to your own IP)... Anyone knows what Big Larry uses to connect to his Database? :) Nelson Flores Project Manager Intec -Mensaje original- De: Chris Berry [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 02 de Abril de 2003 19:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: Remote DBA I do both platforms, my recommendation is OpenSSH + VNC, they work great, they're free, and they're available for both platforms. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Remote DBA
Title: RE: Remote DBA -Mensaje original- De: Wolfgang Breitling [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 03 de Abril de 2003 19:24 Para: Multiple recipients of list ORACLE-L Asunto: RE: Remote DBA At 02:18 PM 4/3/2003 -0800, you wrote: From: Nelson Flores [EMAIL PROTECTED] VNC and OpenSSH are slow Anything cross platform isn't going to have the same kind of optimization as a single platform solution. I find them fast enough to be useable, but you're right terminal server on windows is faster for windows boxes. However, there are limitations for what you can do in a terminal server session. Those same limitations do not appply to VNC. Like what ??? and VNC is still a little unstable (IMHO), What kind of trouble did you have, mine has been rock solid. I personally manage my windows 2000 Oracle DB with a VPN and then a Terminal server window direct to my desktop - from there I have all the tools that I usually have - notepad, mspaint, dir :). That's a good solution, but costs money for those terminal server licenses. My department has little or no budget for non-critical purchases (and sometimes none for those either hehe) so I have to go with the free option, and besides, this lets me manage my linux stations from my win2k boxes and vice versa. Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications. Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement. Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.
RE: Remote DBA
Chris, VNC and OpenSSH are slow and VNC is still a little unstable (IMHO), I personally manage my windows 2000 Oracle DB with a VPN and then a Terminal server window direct to my desktop - from there I have all the tools that I usually have - notepad, mspaint, dir :). I hate to have to plug windows products, but if it were linux or unix, then it would be a different story, seeing as though it matters little where you are physically on a Linux/Unix box (SSH Telnet, or an XWindow Session with the display set to your own IP)... Anyone knows what Big Larry uses to connect to his Database? :) Nelson Flores Project Manager Intec -Mensaje original- De: Chris Berry [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 02 de Abril de 2003 19:09 Para: Multiple recipients of list ORACLE-L Asunto: RE: Remote DBA I do both platforms, my recommendation is OpenSSH + VNC, they work great, they're free, and they're available for both platforms. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dbshut script - shutdown or shutdown immediate
Oracle crash??? What's that :)??? Isn't that a bug in SQL Server only ? -Mensaje original- De: Rachel Carmichael [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 02 de Abril de 2003 22:34 Para: Multiple recipients of list ORACLE-L Asunto: RE: dbshut script - shutdown or shutdown immediate yeah so? are you suggesting that Oracle instance recovery can't handle a database crash? If so, better pray your server never crashes. --- Pardee, Roy E [EMAIL PROTECTED] wrote: Well... my official oracle instructor in dba larva school said that it's tantamount to crashing the db--or so I recall anyway. This isn't so? Peace, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Wednesday, April 02, 2003 2:09 PM To: Multiple recipients of list ORACLE-L On Wed, 2 Apr 2003, Chris Berry wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? What is drastic about shutdown abort? Never one to opt out of a shutdown abort thread, -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Uses shutdown abort exclusively - successful shutdowns/startups: over 10,000 - problems with shutdown abort: 0 - versions used: 7.3.2.3 - 10.0 (yes I have a pre-beta) - still employed! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problems installing Developer on XP
Had a similar problem myself, Try adding the -nojit option for JRE in the installation script. Hope this helps. Nelson Flores Project Manager INTEC Fono : 2428374 -Mensaje original- De: Babette Turner-Underwood [mailto:[EMAIL PROTECTED] Enviado el: Sábado, 22 de Marzo de 2003 18:14 Para: Multiple recipients of list ORACLE-L Asunto: Problems installing Developer on XP I am trying to install Developer 6i on a Pentium 4 Xeon The Oracle Universal Intaller has a problem and tries to send error report to Microsfot. I checked Metalink and the workaround was to search for symcjit.dll in the install directories and rename to symcjit.old ... did this. Also the solution was to replace JInitiator 1.1.7 with JInitiator 1.1.8. I checked and when I installed Oracle 9i on this machine the 1.1.8 was installed and I do not have the 1.1.7 under c:\programs\oracle\jre Any other ideas on what to do ??? Thanks - Babette -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson Flores INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Corp. move to India
does that mean 1.2 billion new DBA's ??? -Mensaje original- De: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 31 de Julio de 2002 16:16 Para: Multiple recipients of list ORACLE-L Asunto: RE: Oracle Corp. move to India Is Larry Ellison learning how to speak Hindi? -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 3:40 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Corp. move to India Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nelson Flores 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: SQLServer copy table from 1 db to another
EXPORT the database. -Mensaje original- De: Gene Sais [mailto:[EMAIL PROTECTED]] Enviado el: Viernes, 31 de Mayo de 2002 15:51 Para: Multiple recipients of list ORACLE-L Asunto: SQLServer copy table from 1 db to another Is there a way to copy a table in 1 sqlserver db to another, similar to Oracle's exp/imp, or create tablle as select.., etc. It appears the only way you can do it is thru DTS packages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Nelson Flores 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).
schedule Oracle stored procedure
Title: schedule Oracle stored procedure
i've got the answer, for all those wanting to know, it's :
dbms_job.submit (:jobnumber,'myproc(' 'proc_parameter' '); ',
SYSDATE,'NEXT_DATE(TRUNC(SYSDATE), ' 'friday' ') + 17/24') ;
(executes a SP every friday at 5pm)
if anyone has a better solution, please let me know ...
Atte.
Nelson Flores P.
Ingeniero Jefe de Proyectos
[EMAIL PROTECTED]
Fono (56-2) 2428374
---
Centro de tecnologías de Información http://cti.intec.cl
Corporación de investigación Tecnológica - Intec http://www.intec.cl
---
Avda el condor 844 Ciudad Empresarial Huechuraba Santiago - Chile
RE: EXTENTS?
Title: RE: EXTENTS? it´s the other way around... how many db blocks in an extent. an extent is a number of contiguous data blocks ... -Mensaje original- De: Seema Singh [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 04 de Marzo de 2002 15:19 Para: Multiple recipients of list ORACLE-L Asunto: EXTENTS? Hi If DB block size is 8k then how many extents in one db block? Thanks -Seema _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema 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).
RE: Manager decrees his data warehouse design. Help!
Title: RE: Manager decrees his data warehouse design. Help! wow .. now my place of work seems oh so normal !! kinda boring really ... Nelson Flores Project Manager [EMAIL PROTECTED] - Information Technology Center http://cti.intec.cl Corporación de investigación Tecnológica - Intec http://cti.intec.cl - Avda el condor 844 Ciudad Empresarial Huechuraba Santiago - Chile -Mensaje original- De: Bellows, Bambi [mailto:[EMAIL PROTECTED]] Enviado el: Miércoles, 27 de Febrero de 2002 15:29 Para: Multiple recipients of list ORACLE-L Asunto: RE: Manager decrees his data warehouse design. Help! Both. I was a consultant to this pharmaceutical company at the time and I honestly liked the job that I was doing, so I stuck it out. After I got over the initial shock of having an insane boss, I found the whole thing amusing. Seems he didn't trust the data center with cables for some weird reason, and after the company relieved him of his post (OH so gently), his garage had something like $30K worth of cables in it. They didn't press charges. But, MAN, there were some stories. -Original Message- Sent: Wednesday, February 27, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Bambi, I once had a manager who was a paranoid schizophrenic. BEEN THERE! A former boss from hell got very angry (there's a reason they call it mad) because he tried to fire me and found out he couldn't. Even so, he liked having me around because he needed me. I hung in there because the company was paying for my masters degree at the time. Later, after I got the degree, I left for greener pastures within the company. In the exit interview my former boss accused me of abandonning him, congratulated me on my move, and literally wept at my departure. He confessed he had been trying to get my goat because he was a 20 year military man who managed by intimidation. But he respected me because I was never intimidated, always stood my ground, behaved as a gentleman, and served him faithfully (his words). Two years later I saw my former boss from hell on the 6 o'clock news being put into a police squad car and with yellow crime scene ribbons around his house. Turns out that while he was being laid off he said things which were interpreted as threats on the lives of certain managers. This was taken seriously and the police confiscated all his guns. I guess the lesson is that eventually the truth will come out. The decision remains with us as to whether to put up with the insanity or move on. Do you have a high insanity tolerance level or are you just a masochist? Steve Orr -Original Message- Sent: Wednesday, February 27, 2002 9:23 AM To: Multiple recipients of list ORACLE-L I once had a manager who was a paranoid schizophrenic. Very exciting, let me tell you. But, one thing he told me in a rather roundabout paranoid way is that the way you deal with crazy bosses who were out to get you is to make friends with other people at your boss' level in the organization, hopefully who report to the same person your boss does, and let them know in a laughing kind of way what your boss wants you to do. Never be confrontational or speak ill of your boss, because, of course, that will wind up biting you in the ass, too. But, that way, when your boss starts badmouthing you and blaming you for everything that goes wrong that was his fault, you'll be insulated from having anything bad happen to you as your friends will close ranks around you and stop your boss from making your life a living hell. And then he threw his coffee cup across the room, turned bright red and started shrieking about how the VP of RD had always hated him. God, I loved that job. Many, *MANY* wonderful stories came out of that place. Anyway, I never thought to follow this advice, let alone share it, but, it sounds like, in this case, you have a crazy boss, and if you stick around, you're going to need a little safety. Of course, posting your resume isn't a bad approach either. HTH, Bambi. -Original Message- Sent: Tuesday, February 26, 2002 11:48 PM To: Multiple recipients of list ORACLE-L I've lost patience, my temper, and I'm about to quit a job because the IT manager has decreed that we will have his data warehouse running within 24 hours, and we will use his design. 1 - We are NOT to use any kind of views, not even materailzed views. 2 - we are not to do any computations, summaries or rollups 3 - we are to have everything in one table 4 - the table name and column names will be meaningful to any clerk 5 - we are not to start or snowflake designs. That's just a bunch of high power talk. 6 - all users will be trained to use MS Access to get at their data. (These are users that were just converted off from green screen teminals within the last 45-days, to Windows 98 with 64k
