Mo' question on 9.2
We are being told that we are going to be required to upgrade to 9.2. I have read the other thread about 8i being contrasted against 9.2 with 9.2 being found wanting in the stability area, so, is 9.2 not a engine to upgrade to? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9972 DSN 651-9972 -- Please note change -- 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).
RE: what is a materilized view ?
ROFLMAO ... What a kidder ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: what is a materilized view ? That would be a question for Madonna, not for this list. Read The Fine Manual. On 2003.09.10 07:04, Veeraraju_Mareddi wrote: Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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: 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).
RE: Offshore threat
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: Mercadante, Thomas F 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: 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).
RE: Offshore threat
can't come up at the end of it with a tangible and LARGE improvement in profitability (stuff the performance, profit is where it's at!), you are toast in the eyes of your boss. And with good reason: you are an expensive overhead and a pretentious git who thinks he's a Steve Adams. Sorry to be brutal. I warned I AM nasty, so there! :D Take it from someone who was a DBA-only 7 years ago, folks: change. Now. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: 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).
RE: Application DBA
Here we call them application administrators who typically take care of what we call 'file and table' maintenance of an application's look-up tables. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Application DBA Patrice, Stephane My 2 cents worth. I have seen differences between administering an Oracle database that is hosting an in-house developed application compared to administering and Oracle database that is hosting a third-party application. In one case you get to know the developers, negotiate with them, etc. In the other case you get to know how the application uses Oracle. I don't know if that is what is meant by application DBA. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 02, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Usually, the term used is devlopment DBA. Stephane Paquette?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Boivin, Patrice J Sent: Tuesday, September 02, 2003 3:54 PM To: Multiple recipients of list ORACLE-L Someone sent me this URL when I mentioned that there may be Application Administrators, but no Application DBAs. http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/St yleG uide/SECURITYANDACCESSPOLICY.htm http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/Sty leGu ide/SECURITYANDACCESSPOLICY.htm Patrice. -- 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: 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).
RE: Oracle not available???
You don't get any other message than a 'Not Available' message? I have one application that did that a lot, but that was because it's SGA was sized way to small. And, thankfully, the people on the this list help me over that bump in the road. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Oracle not available??? Hello Gurus I had a weird one to day, all access to Oracle on our oracle database was suddenly lost When you try to connect it says that Oracle is on available. However the DB has been up for more than 70 days. The other thing the service was running and the Oracle process and listener was running? No errors in the logs, nothing. Server: Win2k, Oracle 817. Has anyone experienced this before??? TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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: 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).
RE: Congratulations Arup (DBA of the Year)
So, this begs the question (still the newbie here), how many DBAs would you say there were? Oh, and when can you say, I'm a DBA? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 7:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Congratulations Arup (DBA of the Year) I think that it is Oracle Magazine that is actually awarding this, isn't it? That provides a clue to the source and methods... Does anyone pay for a subscription to Oracle Magazine? Probably not -- the price of subscription is generally to fill out a real or virtual subscription card, on which Job Title is queried. From that, they probably get their number of a quarter-million DBAs worldwide. Just my guess. Either that, or they do what I do and just pull the numbers out of my...er...thin air... I believe that Arup was awarded this honor and distinction for activities that have come to the attention of Oracle Magazine, namely articles written and published, work performed for Open World, IOUG-A, and SELECT magazine, local Oracle Users Groups, and (possibly?) exposure on this list from the excellent advice and explanations he's provided... ...and possibly from review of TARs opened, processed, and closed... :-) Of course it seems unlikely that #1 DBA can be chosen by any scientific method, but however they did it I think they made an excellent choice regardless! I've always appreciated Arup's contributions to this list and had the pleasure of seeing his presentation at NYOUG last December. --- And congratulations to Mogens for being named Educator of the Year! The leader of the junta which runs the Oak Table Forum has probably forgotten (or drowned?) more information than the rest of us have ever learned, but he's quite generous with the information he has resident. I've always learned something whenever he says anything! In fact, just recently he related the method of milking a nanny goat who has mastitis (yes, carefully and gently for starters, watch the horns...) :-) on 8/28/03 2:34 PM, Pete Sharman at [EMAIL PROTECTED] wrote: And did you really think we DON'T monitor tars raised??? :) 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- Hallas, John, Tech Dev Sent: Friday, August 29, 2003 2:00 AM To: Multiple recipients of list ORACLE-L Not being a party pooper but what does DBA of the Year actually mean. What criteria was used. How can Oracle know about a quarter of a million DBA's unless it monitors tars raised. John -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 August 2003 15:54 To: Multiple recipients of list ORACLE-L Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as DBA of the Year. Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, Arup Nanda, Chosen as DBA of the Year Oracle has chosen our very own CTOUG board member, Arup Nanda, as the DBA of the Year, out of some quarter million DBAs worldwide. There will be a felicitation ceremony at OracleWorld and the award recipients will be featured in Nov-Dec issue of Oracle Magazine. Thought you would like to know, as a part of the CTOUG community. In his interview, he has mentioned CTOUG, so watch for it. Arup is President of Proligence (http://www.proligence.com/). Thanks. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: 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
OT: More on Uday Qusay
Now that Uday and Qusay have been eliminated, a lot of the lesser-known family members are coming to the attention of American authorities. Among the brothers: Sooflay ..the restaurateur Guday... the half-Australian brother Huray the sports fanatic Bejay..the gay brother Kuntay and Kintay.the twins from the African mother Sayhaythe baseball player Ojaythe stalker / murderer Gulay..the singer / entertainer Ebay...the internet czar Biliray..the country music star Ecksray...the radiologist Puray...the blender factory owner Regay..the half-Jamaican brother Tupay..the one with bad hair: Among the sisters: Pusay...the 'loose' 22 yr old Lattaythe coffee shop owner Bufay.the 300 pound sister Dushay..the clean sister Phayray.the zoo worker in the gorilla house: Sapheway..the grocery store owner: Ollay..the half-mexican sister: Gudlaythe prostitute: More will no doubt be discovered 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).
A real newbie DBA question on setting up a 9i client
When I configure an 8i client to attach to an Oracle database, I always have the The service name which has always been the database/instance name -- I assume these don't necessarily have to be the same, but it appears to be that way for single database applications. I also have the host name which has always been the NetBIOS name of the hosting W2K server. So here is the question, is that all I need to configure the client if I know I'm going to connect using TCP for a 9i client? 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).
OT: Anybody want a job in Tampa FL
Title: Message I'm losing my DBA/Developer who is a SAIC contract employee. Basic Skill set qualifications are: 1. Experienced Oracle 9i DBA with development experience using VB/ASP and or VFP/ASP FEs on IIS 5. 2. Experienced MSSQL 2000 DBA with development experience using VB/ASP and or VFP/ASP FEs on IIS 5. Candidate must be able to clear a Secret security clearance check and be familiar with C2 system security maintenance requirements. It is an immediate fill. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
Question on views
I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that detection is going 'stale'. I admit that most my SQL design experience is in MSSQL's T-SQL although I'm starting to come up to speed on SQL*Plus, anyway, the above explanation provided to be from the TriCare guy seems bogus. Simply put there are four or five good Lab Chemistry parameters one could use in a SQL select statement to determine if a patient is diabetic or a diabetic candidate without having specific ICD9 diagnosis coding that declares the patient diabetic. A select statement returns a cursor of data that meets the selection criteria and on MSSQL is a static snapshot of what is in the database at the time the query was executed. Thus, if a patient had parameters that met diabetic conditions stored in the database over the past year, how can a view go 'stale'? Is this just a Oracle peculiarity or am I getting a smoke screen as I suspect? 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).
RE: Question on views
you mixed a lot of functional information in your question, so its difficult to follow the exact 'oracle' question you are asking. Sorry, but I'm still learning. if you are using a 'materialized view' you will need to refresh the snapshot? this is used if you have calculations(like sums, etc...) that you want to pre-compute to speed things up and its easy to refresh. Yes the contractor is using a 'materialized view', I have never heard of that kind of view, is like a parameterized view with computed columns or what? Is the term 'materialized' an Oracle specific term? see my embedded comments below... and you may want to question the 'consultant' about his level of experience. I've never heard of anyone using the term 'stale'. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/08/12 Tue AM 09:39:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Question on views I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that detection is going 'stale'. has your logic changed? No, the view should return columns (existing and computed) of static data residing across three tables. I admit that most my SQL design experience is in MSSQL's T-SQL although I'm starting to come up to speed on SQL*Plus, anyway, the above explanation provided to be from the TriCare guy seems bogus. Simply put there are four or five good Lab Chemistry parameters one could use in a SQL select statement to determine if a patient is diabetic or a diabetic candidate without having specific ICD9 diagnosis coding that declares the patient diabetic. A select statement returns a cursor of data that meets the selection criteria and on MSSQL is a static snapshot of what is in the database at the time the query was executed. Thus, if a patient had parameters that same thing happens in Oracle. Oracle uses rollbacks to achieve this, SQL Server locks the rows. Has the same effect in answering the question Understood. met diabetic conditions stored in the database over the past year, how can a view go 'stale'? Is this just a Oracle peculiarity or am I getting a smoke screen as I suspect? In oracle a standard view is a select statement. what is the background of this 'consultant'. Is he a vendor specific guy or is he an oracle guy? what does he mean by 'stale'? Its hard to judge what your asking. There is too much functional information in your question. Since Im not familiar with your system its hard for me to follow. I have never heard of the term 'stale' either ... I think they are just trying to buy time to fix the problem and I keep bugging them with the 'how' type of questions. Thanks, your response has been helpful. 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).
RE: Question on views
Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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: 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: 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). -- 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).
RE: Question on views
It is confirmed it is a materialized view. How can they go stale? What is the difference in them and a traditional view? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Hately, Mike (LogicaCMG) [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Question on views Stephen, Traditional views don't go stale though they can be made invalid if the underlying objects change. This shouldn't really be happening on a regular basis unless the schema is changing rapidly. He may be using a materialized view. These can go stale. Before going any further ask him which of these is the cause and get the name of the view. I'd have thought that if a materialized view was created by his application then it's his responsibility. Cheers, Mike Hately, Consultant DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: 12 August 2003 13:40 To: Multiple recipients of list ORACLE-L I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that detection is going 'stale'. I admit that most my SQL design experience is in MSSQL's T-SQL although I'm starting to come up to speed on SQL*Plus, anyway, the above explanation provided to be from the TriCare guy seems bogus. Simply put there are four or five good Lab Chemistry parameters one could use in a SQL select statement to determine if a patient is diabetic or a diabetic candidate without having specific ICD9 diagnosis coding that declares the patient diabetic. A select statement returns a cursor of data that meets the selection criteria and on MSSQL is a static snapshot of what is in the database at the time the query was executed. Thus, if a patient had parameters that met diabetic conditions stored in the database over the past year, how can a view go 'stale'? Is this just a Oracle peculiarity or am I getting a smoke screen as I suspect? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 ** ** E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 ** ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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: 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).
RE: OT -- Boston Globe job listings
You preachin' to the choir here ... g v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Craig Healey [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT -- Boston Globe job listings -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI be an overall benefit to the economy, too. However, the financial argument of should I pay 75K - 120K a year for US based DBAs or pay 45K - 80K for offshore talent is hard to beat. The money ranges I gave are contract employee/job shop type of quotes, IOW, a 75K US position would be for a junior DBA that is actually getting 35K-40K and so on up the skill range. But don't forget the hidden costs. You need an experienced person at your end, with good communications skills, to manage the outsourcing. Plus, you have to take into account the time difference if any in-hours work is to be done. Plus, once you've outsourced and fired your in-house staff, you may get tied to the outsourcing company as they are the only ones who know your data. Using outsourcing purely to save money in the short term is just poor management. But they won't be told :-) Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) ** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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: 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).
RE: OT -- Boston Globe job listings
inline But now I keep seeing articles about how much development work is being sent overseas. Has anyone seen that affect Oracle DBA work yet? Huge discussions going on here at work about that very subject. So far, no one has come up with a reasonable argument for keeping the jobs in-house. At the gut level it 'feels' like we should keep the jobs in-house and that would be an overall benefit to the economy, too. However, the financial argument of should I pay 75K - 120K a year for US based DBAs or pay 45K - 80K for offshore talent is hard to beat. The money ranges I gave are contract employee/job shop type of quotes, IOW, a 75K US position would be for a junior DBA that is actually getting 35K-40K and so on up the skill range. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Thursday, August 14, 2003 9:14 AM To: Multiple recipients of list ORACLE-L I don't think it has as much to do with no available positions (although that is part of the answer) as most medium to large companies don't use newspaper ads anymore. They are using the internet (especially for technical jobs) and are signed up with Monster, BrassRing, etc. to do their recruiting for them from their own company web sites. I've seen 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: 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: 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: 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: 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
RE: what is BAARF?
Title: Message Interesting discussion. this is the first time I have seen objections to RAID technology. My cohort in crime, my senior developer (Lee Achorn), and I discussed this at length yesterday and without knowing the compelling arguments came to the conclusion that at least for a database system that maintains transaction logs (are these Redo logs for Oracle?) on off-server real estate and a good back up regimen is in place then why would one need RAID 5? We are running RAID 5 here at MacDill and we have had 4 single disk failures in the last 14 months. The rebuild time has essentially been 45 minutes to 90 minutes with degraded server operations. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message-From: Bob Lofstrand [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 6:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: what is BAARF? It is good to see Oracle and Informix DBAs agree on something once in a while. Art Kagel and many others from the Informix list have been fighting the good fight for a long time. http://www.smooth1.demon.co.uk/ifaq06.htm#6.58 I sent this baarf link to a former co-worker still in the Informix world. I got this response: Bob, That is impeccable timing. I was in Dallas last week with Victor and James looking at SAN systems from Hitachi and IBM. Both vendors were heavily pushing RAID-5 and treated me like a leper when I objected. Troy. My question is what to do from a practical point of view. How have others approached convincing management that RAID 5 is the devil. I guess what I want is a list of the most effective questions and facts that will make these vendors look like idiots when they refuse to give up on RAID 5. -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Monday, August 04, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: what is BAARF? See www.baarf.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Monday, August 04, 2003 1:20 PM To: Multiple recipients of list ORACLE-L I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Cary Millsap 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
RE: Oracle to MSSQL conversion?
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).
RE: Oracle to MSSQL conversion?
Thanks, I didn't have much to do over the weekend anyway. g v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? Stephen, I suggest reading the concepts manual... (for 9i Release 2, see http://download-west.oracle.com/docs/cd/B10501_01/server.920/a 96524/toc.htm in .pdf format http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96524.pdf ) If you're going to work with Oracle you will have to read through one of these anyway, might as well do it now to get it over with... 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: 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).
RE: Oracle to MSSQL conversion?
: UNSUB ORACLE-L (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: 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).
RE: Oracle to MSSQL conversion?
I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Grant Allen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? 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: 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).
RE: Oracle to MSSQL conversion?
Yes, MSSQL is running as an instance and you can multiple instances on the same server (that is W2K or 2003 server), each instance is SQL server consuming it's predefined resources. Each instance of MSSQL can be servicing different databases. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: 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: 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).
RE: Oracle to MSSQL conversion?
Thanks. v/r means Very Respectfully v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? An Oracle instance does not correlate to a SQL Server database. An Oracle instance is a running Oracle server, i.e., a set of background processes and a System Global Area in memory. It is what permits applications to _access_ the database. The database is on disk, the instance in memory. An Oracle _schema_ is analogous to a SQL Server database. (BTW, what does v/r mean?) --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5). At my installation I have 5 SQL-2000 database machines and recently acquired three Oracle 9i machines. The limit is essentially a function of your storage area and the amount of real memory available to the processor or processor array. I'm trying to draw similarities between the RDBM concepts now as I learn Oracle's idea of a database. 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. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 7:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? Patrice. -Original Message- Sent: Thursday, July 31, 2003 7:34 AM To: Multiple recipients of list ORACLE-L I know Microsoft is offering a new course called 'Microsoft SQL Server 2000 for Experienced Database Professionals'. It is aimed at DBAs with experience with Oracle, DB2, Sybase etc. who want to know more about SQL Server. You can read more about this course at http://www.microsoft.com/traincert/syllabi/2723afinal.asp. Gudmundur Hello, There is alot of talk about multi-skilling/reskilling going on here at my company. We use Oracle and MSSQL dbs. I have been wondering if anyone is aware of a resource that shows the oracle programming technique and what the corresponding MSSQL programming technique is. ie Oracle defines variable : MSSQL defines variable Oracle cursor looks like this : MSSQL cursor looks like this. Oracle uses rollbacks: MSSQL uses MSSQL rollbacks etc Hope you all understand what I mean. TIA Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! __ ___ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com __ ___ ## ### 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. TFMC 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services
RE: Oracle to MSSQL conversion?
SNIP What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? No point that I can think of, I just know it can be done. 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).
RE: Is it Veritas or is it smoke and mirrors? again
Title: Message Hmmm, sounds like me and what will be my next issue, except I'll be using Veritas to backup to a SAN. I'll watch this thread closely. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message-From: Michael Kline [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:29 AMTo: Multiple recipients of list ORACLE-LSubject: Is it Veritas or is it smoke and mirrors? again There seems to be some big confusion if Veritas is working or not... Based on Previous discussions this customer has the Oracle Veritas agent running, and they do nightly backups. How ever, I find absolutely NONE of the RMAN tables updated so they are not using RMAN. I also find that the alert log has no references what so ever to "alter tablespace xyz begin backup" and the "... end backup"... While the agent is there and working, I sure see no signs that anything is happening as far as a REAL backup. It's Oracle 9i, but even that, I would think is going to leave some "hints" that all the hooks are working and backup is occurring. Recovery has NEVER been tested. Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com
RE: optimizer parameters in Oracle 9.2
For the ignorant, what is 10G? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 12:30 PM To: Multiple recipients of list ORACLE-L Subject: Re: optimizer parameters in Oracle 9.2 Please be aware that the paper and presentation were written in the 8i timeframe. I swear I'll get it updated for 9i, but already 10G is looming and it's summer and the weather is nicesigh... on 7/30/03 8:24 AM, Gurelei at [EMAIL PROTECTED] wrote: Rich, thanks a lot. I just finished reading Tim's paper and it is truly enjoyable reading. I'm going to test his advices in a few moments. Gene --- Jesse, Rich [EMAIL PROTECTED] wrote: Paging Mr. GormanMr. Tim Gorman... I had wonderful luck with Tim's paper The Search for Intelligent Life in the Cost-Based Optimizer from: http://www.evdbt.com/papers.htm Enjoy! (And thanks again, Tim!) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Gurelei [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 9:04 AM To: Multiple recipients of list ORACLE-L Subject: optimizer parameters in Oracle 9.2 Hi all: I have been reading on the optimizer_ parameters for Oracle 9i - optimizer_max_permutation, optimizer_index_caching and optimizer_index_cost_adj. I have also been playing whith them and I can see that they affect the explain plans for some queries quite dramatically. Is there any guidelines for what they should be set to for optimum performance (some kind of range and may be relationship between the values) or is this mostly a trial and error kind of thing? I have seen a few discussion on the Oracle Metalink, but mostly they are very specific - try this value or try that value. Does anyone have a link to a document with something more systematic than that? thank you Gene -- 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: 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 look at this imp command
imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. 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).
RE: Please look at this imp command
I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. 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: 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).
RE: Please look at this imp command
INLINE snip Two things to check immediately: (1) Is the Oracle service defined as started automatically in the services? Yes (2) If yes, is there any error reported in alert log of the database? Compared line-by-line the last three starts and they seem identical, nothing unusual in the last start. Anyway here is today's entries: Tue Jul 29 03:44:39 2003 Thread 1 advanced to log sequence 73 Current log# 1 seq# 73 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Tue Jul 29 03:45:00 2003 Thread 1 advanced to log sequence 74 Current log# 2 seq# 74 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Tue Jul 29 03:45:31 2003 Thread 1 advanced to log sequence 75 Current log# 3 seq# 75 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Dump file D:\oracle\admin\tpocs\bdump\tpocsALRT.LOG Tue Jul 29 05:31:23 2003 ORACLE V9.0.1.1.1 - Production vsnsta=0 vsnsql=10 vsnxtr=3 Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Starting up ORACLE RDBMS Version: 9.0.1.1.1. System parameters with non-default values: processes= 150 timed_statistics = TRUE shared_pool_size = 50331648 java_pool_size = 33554432 control_files= D:\oracle\oradata\tpocs\control01.ctl, D:\oracle\oradata\tpocs\control02.ctl, D:\oracle\oradata\tpocs\control03.ctl db_block_size= 4096 db_cache_size= 33554432 compatible = 9.0.0 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS remote_login_passwordfile= EXCLUSIVE db_domain= instance_name= tpocs background_dump_dest = D:\oracle\admin\tpocs\bdump user_dump_dest = D:\oracle\admin\tpocs\udump core_dump_dest = D:\oracle\admin\tpocs\cdump sort_area_size = 524288 db_name = tpocs open_cursors = 300 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Tue Jul 29 05:31:26 2003 /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 Successful mount of redo thread 1, with mount id 1877649006. Tue Jul 29 05:31:31 2003 Database mounted in Exclusive Mode. Completed: /* OracleOEM */ ALTER DATABASE MOUNT Tue Jul 29 05:31:31 2003 /* OracleOEM */ ALTER DATABASE OPEN Tue Jul 29 05:31:32 2003 Beginning crash recovery of 1 threads Tue Jul 29 05:31:33 2003 Started first pass scan Tue Jul 29 05:31:33 2003 Completed first pass scan Tue Jul 29 05:31:38 2003 Started recovery at Thread 1: logseq 74, block 202409, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 2 Seq 74 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO02.LOG Recovery of Online Redo Log: Thread 1 Group 3 Seq 75 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\TPOCS\REDO03.LOG Tue Jul 29 05:31:39 2003 Ended recovery at Thread 1: logseq 75, block 18467, scn 0.2938502 3305 data blocks read, 3305 data blocks written, 20858 redo blocks read Crash recovery completed successfully Tue Jul 29 05:31:40 2003 Thread 1 advanced to log sequence 76 Thread 1 opened at log sequence 76 Current log# 1 seq# 76 mem# 0: D:\ORACLE\ORADATA\TPOCS\REDO01.LOG Successful open of redo thread 1. Tue Jul 29 05:31:40 2003 SMON: enabling cache recovery Tue Jul 29 05:31:41 2003 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Tue Jul 29 05:31:41 2003 SMON: enabling tx recovery Tue Jul 29 05:31:43 2003 replication_dependency_tracking turned off (no async multimaster replication found) Completed: /* OracleOEM */ ALTER DATABASE OPEN Import does not shut the database down. I didn't think so. I'm just wondering why when I rebooted the server the TPOCS instance did start, it is like It didn't grab the InitTpocs.ora ...perplexed (but understandable when you are in the constant learn mode. 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).
RE: Please look at this imp command
I'm embarrassed ... Shutdown immediate via SQL*Plus after verifying all users have disconnected. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Tuesday, July 29, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Please look at this imp command I'm starting to gather that -- that the reboot did it. Entertainingly enough I had enough presence of mind to use EM As SYSDBA and open the database using the InitTPOCS.ora. The users have been using the application for the last four hours without any issues, so, what is the graceful way of shutting down the database, via, EM and do a close? v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Daniel Fink [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Please look at this imp command Stephen, From your email, here are the steps as I understand them: 1) run imp command 2) reboot the server (NT/Win2k?) 3) check database and find it is not open The reboot closed the database (and probably not gracefully). When the server restarted, the service may have started, but the database was not opened. I know there are registry settings to control this, but I don't know them off the top of my head. I am sure someone on the list can provide them. The bottom line...imp did not close the database, the server reboot did. Daniel Fink Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: imp tpocs/[EMAIL PROTECTED] file=c:\Latest_Reference_Files\pharm_jul_2003.dmp log= c:\Latest_Reference_Files\pharm_jul_2003.log fromuser=tpocs touser=tpocs tables=arc_ndc commit=y ignore=y buffer=8388608 Scenario: I ran this command (as instructed by the tier III tech), got a couple of warnings but it did import 28K plus rows into arc_ndc. Before I ran the command at the command NT command level, I truncated arc_ndc via SQL*Plus. After the command completed I rebooted the server, there was no direction to do this, I just did it for good measure figuring I would get a clean oracle instance going. When the server finished the reboot, oracle wasn't up -- or I should say the database wasn't opened. I had to open the database as SYSDBA. Did the imp command close the database? I don't see any directive to do so, but being new maybe there is something I don't understand. Thanks for your help and patience. 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: 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: 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).
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Cool, but it also begs the question as to why SQL*Plus doesn't have line editing capability? Even in 9i, unless I don't know the keystrokes to do the line editing ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED] Sent: Saturday, July 26, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Emacs on SQLPlus, er uh... SQLPlus on emacs. I use SQL*Plus running under emacs shell every day. It is my preferred way of: - Recording my sqlplus sessions so I can go back and search to see what I did - having an up-arrow comand history capability - Having line editing capability - editing SQL scripts in the same window where I am running - everything else I came to prefer emacs because it has capabilities far in excess of vi or any other unix editor. Because it is open source software, many people have contributed over the years, making the package extremely powerful. Also, I started on Vax/VMS edt and eve/tpu, which are more like emacs than vi. There is an emacs OracleSQL mode, but I don't use it. I just start emacs, META-X shell, then sqlplus... -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 25 Jul 2003, Orr, Steve wrote: I agree with the developer vs. sysadmin generalization but this was not meant to be a post about favorite editors... It's about whether anyone has used or seen a SQLPlus shell running under emacs. Has anyone witnessed SQLPlus running under a well-configured emacs session and have impressions to share? The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I wonder what the breakdown is for Linux admins? Since emacs is easy to implement I could see it gaining ground on Linux but sometimes old dinosaur type SysAdmins are slow to evolve. :-) -- 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: 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).
RE: Oracle 9i refuses to allow client connection -- I need
v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.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
RE: RE: Oracle 9i refuses to allow client connection -- I need
Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information
RE: RE: Oracle 9i refuses to allow client connection -- I need
Thanks! I'll start perusing the sites right away. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Subject: RE: RE: Oracle 9i refuses to allow client connection -- I need Stephen. OTN is the abbreviation for Oracle Technology Network http://otn.oracle.com/. It is a source and startup point for documentation, software , news, and other Oracle related stuff. I would surf the site to see what is available for the Oracle applications you have and to locate the documentation that you might need. I would also suggest that you get a MetaLink account http://metalink.oracle.com. Metalink is the Oracle site where an Oracle answered forums exist, patches reside, certifications is listed, ITAR's are created, etc. If you have an Oracle support contract you should have access to the MetaLink site without any problems. Ron [EMAIL PROTECTED] 07/28/03 10:09AM Please excuse the ignorance but what is an otn document? I have three Oracle based applications here and each one was delivered without any documentation. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Oracle 9i refuses to allow client connection -- I need the otn document for administering oracle on windows is pretty solid. the book includes most of that stuff plus some fo the gui tools. From: Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] Date: 2003/07/28 Mon AM 08:11:32 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 9i refuses to allow client connection -- I need v/r Thanks for the encouragement and yes I would like to know some of the good Oracle 101 under a windows environment books. I'm pretty certain that my approved training will be funded with year-end money, but that means the earliest I'll get to class is in late October or early November. Hope you don't mind me bugging you all a while until I get squared away. Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Ron Rogers [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i refuses to allow client connection -- I need Stephen, I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding. I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the Oracle 101 books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to. I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date. Again, Welcome. Ron mª¿ªm [EMAIL PROTECTED] 07/25/03 08:59AM there are a number of logs that could help: first, does the application itself generate a log? If so, does that log reflect the actual error returned? It might look something like ORA-nn Second, on the Windows Box itself, look for a file name alertsid.log (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused. If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so. if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals). and welcome! It's always nice to see a new face here, especially one who is willing to LEARN --- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED] wrote: I'm an Oracle administrator-To-Be, I'm
Oracle 9i refuses to allow client connection -- I need some help.
Title: Message I'm an Oracle administrator-To-Be, I'm awaiting funding for the basic Oracle DBA courses, the training has been approved, just hasn't been funded. Anyway, the only things I do are add, modify, and reset application users' password via EM and run patching scripts via SQL-Plus. The application I have running on this particular 9i server is TPOCS, Third Party Outpatient Collection System -- a billing system for the DoD's Military Health System (MHS). Oracle 9i is running on a Windows 2000 server. Anyway, the TPOCS client is a PowerBuilder client and connects via SQL-Net -- I'm still learning about that mechanism. Here's my problem. Occasionally, Oracle refuses to let any client connect to it -- it does this about every 7 to 8 days. It use to do it every 2 days, but the Tier 3 TPOCS helpdesk recommended we increase the ram on the server from 512MB to 1GB. Then the problem started occurring every 7 to 8 days. To make the problem go away I reboot the server -- it only takes 10 minutes, however, I feel this a very poor work-around. Which logs could I look in that would give you guys more information (like an error code) on why Oracle refuses client connections and then how would we make this problem go away. it is becoming a PITA. v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
snip Of course, there are those who use notepad + ftp That's me. ggg 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).
RE: Do Not Call
Title: Message snip http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov Well, if it were unix then it couldn't be SQLserver. It is Windows, therefore I assume its SQLserver, but it could be Oracle. But who runs Oracle on Windows anyway *hahahaha* ... We do ... groan-- Steve Wolfe [EMAIL PROTECTED] 07/01/03 02:29PM Paradox for DOS -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: Do Not Call There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- 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).
RE: Oracle Clinical
Now that makes sense to me ... g v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Clinical On Tue, 24 Jun 2003, Wolfe Stephen S GS-11 6 MDSS/SGSI wrote: What's a DAB? Among the Hmong, a dab is an evil spirit thet makes mad things happen. For instance, a dab might hang out at a particular intersection and make fender-benders happen. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- From: [EMAIL PROTECTED] what is Oracle Clinical. I saw some job advertisement Oracle Clinical DAB or programmer. -- 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: 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).
RE: Shite of the day
I agree with you Lisa ... g, I don't understand the PR ... v/r Stephen S. Wolfe, GS-11, DAFC Data Services Manager [EMAIL PROTECTED] (813) 827-9974 DSN 651-9974 -Original Message- From: Koivu, Lisa [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 10:40 AM To: Multiple recipients of list ORACLE-L Subject: FW: Shite of the day Oh-My-Gosh. Worry free? I just upgraded another 8.1.7.4 database to 9.2. When I set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make sense) I get really messy errors: ORA-00402: database changes by release 9.0.1.3.0 cannot be used by release 135294976 ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0 So then I tried to set it back to 8.1.7, or comment out COMPATIBLE altogether, and I get the same type of error. It won't open at all. I tried initiating recovery. This database is in noarc mode. It starts looking for arclogs that *do not* exist. I also tried to drop the redo log groups and recreate them. Still, no dice. Again, unbreakable my FUNDAMENT. So has anyone seen this before? I opened a tar yesterday and promptly confused support. Lisa -Original Message- Sent: Wednesday, June 04, 2003 7:45 AM To: Multiple recipients of list ORACLE-L Trade SQL Server for Oracle9i Database and get up to 100% license credit and peace of mind. Tired of applying patches? Frustrated with managing mulitple database servers? In the time it takes you to apply all Microsoft's patches to your servers, you can successfully migrate your database to Oracle9i Database and be worry-free. From http://www.oracle.com/start/linuxsqlserver/intro.html?src=1764 462Act=16 I don't understand PR of Oracle. The RDBMS has so much properties which are much more better implemented in Oracle than in MS SQL and they choose 'patching' which *** on both servers. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner 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: Koivu, Lisa 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: 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).