Career Advice
As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Sadly, I do agree with you, but its a silly world out there. You cant get a job working with these packages without experience, and you cant get experience if you dont work with these packages. So my alternatives are few to none. Indeed, the Tecsys applications are comparable to many complex applications in the market so I think that really works in my favour. But hiring managers want to see the big names on your resume it wont matter that Tecsys is just as complex. I guess the next step would be find a position where one of these other applications is actually used. Perhaps just getting familiar with one of these would help me get my foot in the door. Thanks Jared. Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: December 17, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Wow... as talented and knowledgeable as you are, you are one really bored DBA. You must work alone, or be self-employed. Or maybe you are trying to tell me to read between the lines... In any case, I won't get into a silly argument with you. Thanks for your advice, Saira -Original Message- Mladen Gogala Sent: December 17, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Have you ever considered a career in country music? Try getting Stand By your man just right and the rest will come. You have to learn both kinds of music, country and western. May Jake and Elwood be with you. On 12/17/2003 12:44:28 PM, Saira Somani-Mendelin wrote: As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Hi Allan, Please call me Saira :) All you are saying is true. I find that in my present role, I don't have access to the applications source code so I have to look at the database for performance tuning (which should be the case anyway to start). On the other hand, I'm the only one at this job so I have a lot of flexibility about how much I know about the application - luckily, I own all of it so I am able to experiment at my leisure. Thank you for taking out the time to write all your thoughts. You've given me much to think about. Saira -Original Message- Nelson, Allan Sent: December 17, 2003 1:59 PM To: Multiple recipients of list ORACLE-L Hi Somani, This is, of course, just one opinion. YMMV. I would recommend that you go deep enough on the Oracle server until you would be willing to take the junior off your title. The reason for this recommendation is that the server is an intricate piece of software that rewards study and experimentatation. If you were to go for any of the large ERP's that are out there you will find that they each have a great deal of application specific administration that has little or nothing to do with the database directly. There is literraly 1000's of pages of documentation for the server and more 1000's of pages of documentation for the ERP's. Frequently, an ERP will have certain rigidities in the database configuration that will not permit you to gain knowledge about certain areas of the server technologies. Query tuning in an ERP environment is an order of magnitude more difficult because you don't own the sql. The query source is available but in general query tuning can turn into a cooperative effort with your ERP vendor or you will find upgrades to be significantly harder projects. When you control the source it is a lot easier to learn that particular area. Similarly, the ERP's all lag the server releases in terms of feature usage. In ERP's there is generally a division between functional folks who do the transaction and business related setup and problem resoultion. Technical people generally focus on the interface between the OS environment and the applications. For instance, on the tech side you might have responsibilities for the forms server (Oracle Finapps) and the web servers, where a functional person might setup GL and be responsible for transaction and data problems in that area. If you shop has an installation of much more than moderate size you will most likely have to specialize. Most ERP's will take 3 to 5 years to learn reasonably well. I know only a handful of people that are genuinely competent in more than one. Just some thoughts. That's a nice complicated question you asked Allan -Original Message- Saira Somani-Mendelin Sent: Wednesday, December 17, 2003 11:44 AM To: Multiple recipients of list ORACLE-L As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services
RE: Career Advice
Is it that difficult though? Just to get familiar with it if youve worked with other similar software before? I guess youd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no? Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eric king Sent: December 17, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 17, 2003 1:09 PM Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
That is an excellent guideline. I find myself as somewhere in the middle of those two spectrums, a little more towards the second one. My personal belief is that languages can be learnt - like Java or any other code - if you possess the skills. I can read and understand 4GL code without ever being exposed to it. I think learning the fundamentals, the inner workings, the internals is key to success. I'm being led towards a generalist type of role/career path and I'm starting to wonder if it's the right one. I live in Toronto, so maybe the employment market is different here from other metropolitan areas, but I'm finding a huge demand for applications specialists. But like anything in IT, I'm sure it will subside in a couple of years, by the time I'm up to speed :) If there is anything I have learnt from working with this particular software package from Tecsys, is not to trust their documentation or their advice even (as you point out). They ported their application from Informix to Oracle, so we are experiencing the pains they never had to in their pre-release days. But luckily, I am somewhat in control of how the applications are implemented and enhanced. I like the fact that I can adapt to the new without much effort. I think that's valuable - but try telling that to a recruiter or an HR person. You've given me great perspective on what is important. Thanks, Saira -Original Message- Odland, Brad Sent: December 17, 2003 2:54 PM To: Multiple recipients of list ORACLE-L There is no set formula now. But learning a fair amount of SQL, Oracle Database and Unix Administration can do you no wrong. IN my experience the companies or people that hire you because of big names on your resume are NOT the ones you want to work for. IT administration work has become more specialized of late. In particular DBA work has become more low level or hardware close at least from my perspective. As you become more familiar with the application running on the database you begin to drift more and more towards the business end user. The result if your technical understanding shifts from data reliability and security to how the data is used and perceived by the users. Your choice as a young IT professional if to determine where your particular natural talents are best utilized. Ask yourself these two questions and be honest with yourself: 1. Are you a people person with compassion and empathy for people's problems and do you have the ability to visualize data in format that business users can comprehend? 2. Are you a good technical troubleshooter with the ability track down solutions wherever they reside in the network, OS, database, middleware or client If you answered yes to the first and you find yourself helping user understand the data better then continuing in the business analyst support role would be the direction for you. If you find yourself as the support person for the analysts and work at the OS level with the system admins then the DBA route is problem better suited to you. As you choose where you are headed remember to celebrate the SKILLS and TALENTS you have on your resume. Skills you have like people skills, communication and troubleshooting rather than highlight anyone package or technology. Talents are ease of learning or a programming language like PL/SQL, SQL, perl or korn shell. The tools are all similar how you were able to learn to use them is better. Many times in down economies a new employee is brought into IT because the different perspective is desired. The successful IT professional has to have the ability to drift with the tide of technology and adapt to change rapidly and to help lead the way through unknown territory with confidence. You can't trust the vendors and you can't trust the documentation all the time but you can trust your own abilities to sift through the chaff to find direction. Looking at the IT world as a whole is the best place to start. Seeing the strata from the network to OS through the database, middleware, workstation and finally enduser is the view that will help you succeed. Knowing where you are and how to overlap the boundaries is the best way navigate an IT career. What we do is not rocket science but you can't do rocket science without us. Good luck in your future. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Little Caesars. $5 CDN (Seriously). -Original Message- Mladen Gogala Sent: December 17, 2003 3:29 PM To: Multiple recipients of list ORACLE-L Large pizza for $5 Where? On 12/17/2003 03:14:43 PM, Odland, Brad wrote: My career advice to you is: do whatever sells. Even if it is wearing a sandwich board that says, Hot Large Pizza Now $5.00 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Well, good, now that we have that cleared up. Don't get me wrong, I do like your keen sense of humour and sarcasm - when I know you're joking and at times its hard to tell. I've hesitated to learn Perl - don't know why, but now I find I have to know it to do my job better, esp when I'm working with Oracle. Shell programming is also getting lots of attention from me. I worked with PostgreSQL when it first came out and then I forgot about it. Thanks for the insight. Saira -Original Message- Mladen Gogala Sent: December 17, 2003 2:34 PM To: Multiple recipients of list ORACLE-L Or maybe you are trying to tell me to read between the lines... I'm not. I was just kidding. I don't know any of this stuff (SAP, Siebel, Oracle Apps) and I do make my living. Frankly, I don't like specialists, because they end up just like pandas: no bamboo shoots, and they starve. Black bears and racoons are more to my liking: they eat anything (one of my neighbors lost two cats when she moved from NYC to CT) and thrive. Being an oracle DBA looked like a safe proposition just two years ago. Now I'm doing lots of perl, some PHP, linux, samba, I started playing with PostgresSQL (cool stuff) and I made oracle database just one among my skills. I'm quickly honing skills of a standup comedian, too. Please, do not misunderestimate me. My career advice to you is: do whatever sells. -- 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Career Advice
Sounds like a fun time J no really Thanks for all the details. Right now I have one computer that is used by everyone. I have a spare laptop but I can always buy a couple of cheap computers to set up a mini lab. Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Odland, Brad Sent: December 17, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Career Advice If you need specifics for a home learning environment setting up Oracle 8.1.7.4 on a Gentoo linux box at home is a great learning exersize. (I've yet to do the Gentoo thing, RedHat right now) (You need at least two computers at home...List how many computers do you have at home.be honest...even the dead ones...) And to do so without useing the Database configuration assistant. Then go through upgrades to 9.2.0.4 Set up some locally managed tablespaces, enable archive logging, write some hotbackup and coldbackup scripts, alter datafiles, make new ones, load some bogus data, do exports, imports. Drop table and recover them from exports, break the database, recover from backupsset up procedures for adding new users of pretend application. Create roles for developers, users and analysts...write a PL/SQL program to generate gobs of fake test data. Hotbackups everynight, nightly processing jobs, trunc tables and move data around Fiddle with connection manager, OMS, OEM, the agent and Oracle Names. Run various DBA tools TOAD, dbVisualizer do some connections with JDBC and setup apache with PHP and write a few goofy pages to query the data dictionary and format output to your browser. Convert OraHoo0.5 from Oracle function to OCI functions (that's a fun exercise) All of that is free and downloadable with plenty of documentation. That experience alone will do a ton for you and keep you busy at home for months. pretty much all of the network, OS and database skills are covered. And you can say you've been exposed to performing these tasks and if you put all your scripts your write on a cd you can take it with you for a long time. We all have our pile o'scripts we take with from place to place. Have fun! Brad O. -Original Message- From: Saira Somani-Mendelin [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Career Advice Is it that difficult though? Just to get familiar with it if youve worked with other similar software before? I guess youd be looking at a lot of theory, and not nearly enough practice. But then, how do I get obtain these more attractive, marketable skills? I must start somewhere, no? Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eric king Sent: December 17, 2003 1:55 PM To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice That right, packaged software like SAP and PeopleSoftware should be learned in the real implementation or real usage case. By simply getting the software and use it yourself, it is very difficult to even grasp the basic idea about those business transactions. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 17, 2003 1:09 PM Subject: Re: Career Advice Your enthusiasm is admirable, but I think that it would be extremely difficult for you to learn any of these packages without actually being in an environment where they are used. It may be that Tecsys is a complex set of apps on the same level as SAP or Oracle Apps, and if so, then maybe that background would prepare you to tackle this on your own. Either way, it will be difficult without access to official support, which you won't have unless you're in a working environment that includes the app you are attempting to learn. You would also not have exposure to the people that are actually using the stuff, which is pretty important for software that is directly used by most of the user community, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands
RE: Career Advice
, unlike a database. HTH Jared Saira Somani-Mendelin [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Career Advice As an applications analyst/junior dba, I feel I need to learn more but I'm not sure of the direction I should take, so I'm asking for advice. Should I become interested in Oracle Apps? Or should I learn another suite like SAP or Siebel or PeopleSoft? The difficulty is that my company does not use any of these. We use a smaller package by Tecsys called Elite and they don't have as many customers - or should I say, as many customers with deep pockets. I know I can get my hands on a working copy of SAP, what about the others? I believe you can purchase an evaluation copy of Apps from the Oracle Store. Has anyone actually tried to train themselves on any of these products? Has anyone installed Apps at home for testing? Sorry if this question has been presented on the list before. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
bad SQL day...help please
List, Please excuse the content of this question. I haven't had a breakthrough yet so I'm hoping for some assistance... it may seem trivial to some but for some reason I am SQL-ly challenged today. I have a table which holds historical transaction records. Each PICK or RPCK record should have a corresponding SHIP record with a match on quantity, sku, and order_id. I have to create an exception report where if for any PICK/RPCK record there isn't a corresponding SHIP record, I should be shown the PICK/RPCK record. In other words, each sku has records in multiples of 2 - i.e. 1 PICK/RPCK, then 1 SHIP record; 2 PICK/RPCK records, then 2 SHIP records. I know what I want in English, but I'm having trouble designing the query in SQL. In the table below, you can see that SKU 117127 has a PICK record but no SHIP record, same case for SKU 701206. Is someone kind enough to offer me some SQL advice? Thanks in advance, Saira OB_OID SKU TRANSACTQTY 50340 115227 RPCK36 50340 115227 SHIP36 50340 115304 RPCK36 50340 115304 SHIP36 50340 174040 RPCK12 50340 174040 SHIP12 50340 177127 PICK36 50340 177144 PICK24 50340 177144 SHIP24 50340 177624 PICK24 50340 177624 SHIP24 50340 177634 PICK48 50340 177634 SHIP48 50340 19 PICK20 50340 19 SHIP20 50340 20020 RPCK6 50340 20020 SHIP6 50340 701079 PICK100 50340 701079 SHIP100 50340 701206 RPCK30 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira -Original Message- Sent: November 6, 2003 3:54 PM To: [EMAIL PROTECTED] Cc: Saira Somani-Mendelin Catch the error in an exception clause and ignore it. SQL set serveroutput on SQL run 1 declare 2 x number ; 3 begin 4 x := to_number ('123^') ; 5 exception 6 when value_error 7 then 8dbms_output.put_line ('Bad Number') ; 9 when others 10 then 11raise ; 12* end ; Bad Number Procedura PL/SQL completata correttamente. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
Hee hee... I am indeed a novice, but I make fairly sound judgments based on the name of a function :) -Original Message- Jamadagni, Rajendra Sent: November 7, 2003 9:30 AM To: Multiple recipients of list ORACLE-L Don't tell me you tried it g MG, another feather for your Cap ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 07, 2003 9:17 AM To: Multiple recipients of list ORACLE-L I like this solution. It works way better than the dbms_lock.sleep() suggestion ;) Thank you. Saira ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Plus errors... how to hide?
I'm sure there are many ways to perform complex validations a shell script. And I needed a simple solution so I opted for the easy way. Unfortunately, I'm not an expert shell programmer yet. Fortunately, I did receive many good suggestions from the list to help me progress in my quest to learn Korn Shell. Thanks, Saira -Original Message- Thater, William Sent: November 7, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: The sleeping beauty suggestion works extremely well, if you are patient. Patience, you know, is a virtue and my goal is to promote fair and balanced view to the database. me, i want my patience RIGHT NOW!;-) BTW, is there any chance of validating the input before it gets passed to the procedure? -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Before God we are all equally wise - and equally foolish. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Plus errors... how to hide?
List, I have a shell script that executes a sql*plus script (which executes a procedure) based on user input. But what if the user inputs an invalid datatype? The exception section handles the error and displays a user-friendly message but I still get an error stack. I want to hide this from the user. How can I do this? I have set feedback and echo options off. See output below: PO Reconciliation Batch Release Enter batch number to be released: yrugis You have entered an invalid number! Exiting program... **[I want to suppress the errors below]** BEGIN RELEASE_PO_B_H('yrugis'); END; * ERROR at line 1: ORA-01722: invalid number ORA-06512: at TRAIN65D.RELEASE_PO_B_H, line 16 ORA-06512: at line 1 Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL - can't accept user input - then how?
List, Please forgive the repetitious nature of this query, but I haven't yet found an answer that satisfied me. Environment: AIX 5.1 Oracle 8.1.7 Trying to create an SQL script which calls a procedure to update a record based on information provided by the user via a screen prompt. I know PL/SQL is not interactive by nature. I have tried the ACCEPT command in the .sql script before the procedure call, which is wrapped in a shell script but it doesn't wait for my input, just carries on executing the rest of the .sql script. I am now thoroughly confused about how to do this. And I doubt I am the only one. I do need the user to provide me with a parameter so I can locate the record for update. Don't hesitate to tell me to RTFM or book or website, just tell me WHICH ONE(S) to read :) Thanks much, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL - can't accept user input - then how?
Thank you all. Your suggestions have clarified A LOT of grey areas for me. I'm not an expert shell programmer but I can certainly get by on these suggestions! Thanks again. Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Third party application - how to begin performance tuning efforts?
Thanks for your suggestions. You have provided me with some excellent ideas. Saira -Original Message- Mladen Gogala Sent: September 26, 2003 1:05 AM To: Multiple recipients of list ORACLE-L efforts? Yes, that's a great idea for forcing plans. Thanks for thinking of that. Essentially (this part is for the original poster, Saira Somani), you create a small copy of your production database, by using exp rows=no, if necessary and then repeat the query in that small database, where you can tweak the parameters, the structure and the quantity of data. That means that you can force full table scans, hash joins and alike, then, when you are reasonably satisfied with the execution plan, create an outline and trensplant it to your production database. Stephane, it's a great idea. I'll write it to my book of spells. On 2003.09.25 23:14, Stephane Faroult wrote: Outlines ? Mladen Gogala wrote: Saira, you can turn on tracing, you can analyze tables, create histograms and create indexes. The first thing to do would be to take 10046 trace, level 12 and analyze it with tkprof. Then, you should find the few most expensive SQL statements and see whether something quick and easy could be done, like index creation, for instance. If not, and the performance isn't satisfactory, then determine where is the problem and contact the vendor. No big science there and nothing more you can do. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Saira Somani-Mendelin Sent: Thursday, September 25, 2003 4:35 PM To: Multiple recipients of list ORACLE-L Subject: Third party application - how to begin performance tuning efforts? List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Third party application - perf tuning...etc.
Dennis, The ERP vendor started off using Informix and ported their application to Oracle. We are 1 of 2 Oracle installations and they do not have much Oracle expertise in their company - they don't provide any administrative type manuals for the SA or DBA with respect to their products. I wish they would write an Oracle chapter or at least release an internal document which would explain all this. I do think that with their new release, they will be providing some tips for tuning so maybe I can just hold off until then. The on-line forum is a great idea and there is one in which we actively participate. Thanks, Saira -Original Message- DENNIS WILLIAMS Sent: September 25, 2003 5:15 PM To: Multiple recipients of list ORACLE-L eff Saira Here is my tip. Every vendor must take an approach and if they support many databases there will be some compromises in their architecture. The vendor probably has a chapter in a manual about how they interface with Oracle. Read this, but don't skim it like most of us do because we have way too much to read. No, ponder each word and try online experiments to try and learn what every detail means. In a former life I worked for a vendor and I wrote that Oracle chapter. For some reason it is hard to write that sort of thing so everyone can understand it. Once you really understand the vendor's approach, you are miles ahead in understanding your tuning alternatives. Also if it is an ERP vendor, there is probably an online user forum somewhere and you can get a lot of specific advice there. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 25, 2003 3:35 PM To: Multiple recipients of list ORACLE-L efforts? List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Third party application - how to begin performance tuning efforts?
List, I begin with an apology for repeating something that has probably been asked before in different words. We use an integrated ERP/WMS/Query application provided by a vendor but we do not have the ability to change any code. How do I know that my Oracle database is running optimally (if there is such a thing)? Obviously I cannot rewrite queries in the application code (which is 4GL code BTW). So what other aspects of the database can I change/tune? I can definitely see some costly SQL statements when I feel curious and want to check what's happening on the database. But isn't cost all relative? Are there any recommendations for articles, white papers, books on how to tune the database for a third party application? Also, I will be attending the DBA/Developer Day in Toronto on Monday October 6. I am looking forward to the sessions by Tim Gorman, Tim Quinlan and Michael Abbey. Anyone else attending this conference? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reducing the number of databases
Title: Message Unfortunately, thats what we have! And yes, my resume is on-line Our database configuration and installation was outsourced and so was the installation of our ERP. So guess what happened? No consultation with the support analyst and now they want to split the schemas into multiple instances. Go figure J -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: September 19, 2003 2:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Additional money might be saved by having only one database which would assume the role of QA, development and production. That would mean that developers test in production and their own QA. You can save a bundle on oracle licenses that way. In addition to that, if you switch to noarchivelog mode, you can save a small fortune on the backup tapes. Smart thing to do in that situation would be to put your resume online before stuff hits the fan. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guang Mei Sent: Friday, September 19, 2003 2:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: Reducing the number of databases Here we have 3 environments formost applications (dev, QA andprod) and all Oracle version are the same (8173 now). It works fine. And to save Oracle license costs, we also consolidated some db servers byputting multiple instances onone server machine.No problem so far. Guang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AK Sent: Friday, September 19, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Subject: Re: Reducing the number of databases I have seen more requirement for individual development databases ( where ind schema is not possible ) due to complexity of application . Developers step on each other if they work of same database . A pl/sql developer is invalidating procedure while a java developer is trying to make his program work. -ak - Original Message - From: Stephane Paquette To: Multiple recipients of list ORACLE-L Sent: Friday, September 19, 2003 8:59 AM Subject: Reducing the number of databases Hi, We have around 120 databases. Most applications have 5 environments (dev, test, integrated test, acceptance, prod) some applications have more.The applications are a mix of home developped and bought application (peoplesoft, harvest, compass,...) New applications are coming in. New databases will appear soon with DB2UDB. All servers are unix/aix, there are15 production server and around 10 servers for the dev, test, integrated test and acceptance databases. All databases are at 8172 except 6-7 databases and planning to go to 9i in 2004. Off course we see the migration like a pain. We want to reduce the number of databases and instances. To obtain a significative gain I think we must reduced to around 60 databases. Anybody has done the task to consolidate on less servers and les databases ? One way to do it would be to go with 2 instances of dev 2 instances of test 2 instances of integrated test 2 instances of acceptance all prod instances are standalone. Food for thought backup Oracle version availability naming convention of objects security ... All feedback is welcome. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 poste 7470 et (514) 925-7187 [EMAIL PROTECTED] Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand 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.
RE: ORA-16014
Here is are the complete entries from the alert log: ARC0: Error 19510 closing archivelog file '/apps/oracle/archive_logs/current/archT0001S006362.ARC' ARC0: Archiving not possible: error count exceeded ARC0: Failed to archive log# 2 seq# 6362 ARCH: Archival stopped, error occurred. Will continue retrying Wed Sep 3 12:00:03 2003 ORACLE Instance THLI - Archival Error ARCH: Connecting to console port... Wed Sep 3 12:00:03 2003 ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ARCH: Connecting to console port... ARCH: ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ARC0: Beginning to archive log# 2 seq# 6362 ARC0: Completed archiving log# 2 seq# 6362 Archiver process freed from errors. No longer stopped. So it seems to be resolved? Please comment. Thanks, Saira -Original Message- Sent: September 3, 2003 12:11 PM To: '[EMAIL PROTECTED]' Received this alert minutes ago. There is no disk space shortage. What else can I check for? ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-16014
Received this alert minutes ago. There is no disk space shortage. What else can I check for? ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' ORA-16014: log 2 sequence# 6362 not archived, no available destinations ORA-00312: online log 2 thread 1: '/u03/oradata/THLI/redo_02a.log' ORA-00312: online log 2 thread 1: '/u04/oradata/THLI/redo_02b.log' Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to keep root out?
Title: Message Cant root user change any file on the system regardless of the file owner? If the SA doesnt know about this line of code or about oraenv, then it will work for a while. I think Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: August 28, 2003 1:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to keep root out? Put the following code snippet if [ $LOGNAME = root ]; then init 0 fi; in your oraenv. I guarantee you that the SA will no longer be connecting as SYSDBA. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter K Sent: Thursday, August 28, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: How to keep root out? Just for grins, I'll ask this question... Is there any way to keep the Unix root user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to help by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via connect internal. This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious,is there any way to prevent access via connect internal or / as sysdba? Thanks in advance. W
Re: GREAT SCOTT!! 1.21 GIGAWATTS!!
We had 45 minutes on our UPS which handles our routers, switches, firewall, phone system, 1 RS6000 (dual processor), and 5 Windows 2000 servers. We waited 10 minutes to find out what was going on, all the while shutting down non-essential servers. Then we proceeded to perform a graceful shutdown of all our systems. No backups were performed, unfortunately. Now power is back up but we have rotating blackout situations. So the production managers/CEO would like to bring up the essential servers, but I wouldn't risk that without fully charging the UPS power cells. Then at the end of production day (if we are still up), I will be shutting down the system, in case of blackouts during the night. I wouldn't expect things to be back to normal until Tuesday, or later. If anyone else has any suggestions about what I can do, please let me know. HTH, Saira As soon as lights went out --- Odland, Brad [EMAIL PROTECTED] wrote: Any listers (when you have time) who were effected the Great Blackout of 2003 please share your experiences. UPS, Y2K backup generators fired up, scramble to shutdown, communication issues etc... It would be good to hear how folks handled the situation for future reference. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [stupid] vi question
Well that would explain it, I suppose. Unfortunately, these files were ftp'd by our ERP vendor so I really can't reverse the ftp situation. Thank you all for your suggestions. I will give them a try. Saira -Original Message- Stephen Lee Sent: August 6, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Like mebbe you ftp'ed the file from the windows box in bin mode. FTP again, but in ascii mode this time. ftp box (user / password) ftp ascii 200 Type set to a ftp get the_file -Original Message- There's the :set list and :set nolist commands. But in your case, I think you got ahold of a MSDOS/Windows text file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Loader - append to a table while checking column against another table
List, I have been given a csv file to load into an Oracle table. This table has no referential integrity constraints (it is checked via the application) so I could end up inserting a bogus record. Is there any way for me to check for the existence of a record in another table while loading data using SQL*Loader? Here's the process I use right now: Load records into a temporary table. Query these records against the reference table. If record doesn't exist, spool it into a file, give it back to the BA, get them to fix it, then go through the whole process again until there are no bad records. Seems like a roundabout way to do things - it definitely works for me but I just wonder if there is an easier way. Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: [stupid] vi question
Suddenly my vi editor is showing ^M at the end of each line. How do I get rid of it? Thanks in advance, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: running 9i database and 11i apps on Linux - Good idea?
Yes I think so. I went the other way knew Linux well and moved over to AIX. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fedock, John (KAM.RHQ) Sent: July 30, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Subject: running 9i database and 11i apps on Linux - Good idea? I am looking for advice, links, white papers, etc.on the feasibility of upgrading our current old Oracle Financials system and upgrading the database (9i) and the new 11i app onto Linux servers. If I know Unix well, can I hit the ground running with Linux? TIA. John John Fedock K Line America, Inc. www.kline.com * [EMAIL PROTECTED]
RE: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1
Thank you. These are excellent suggestions and I will follow up on them. Our senior DBA has some analysis of his own and I do agree with #4 - we've had problems before with this application and its execution of SQL statements. Thanks again, Saira -Original Message- M Rafiq Sent: July 27, 2003 8:39 PM To: Multiple recipients of list ORACLE-L 1)for temp usage check v$sort_usage while application/job running. It is some code which may be resulting in cartesian join using hash join. 2) check for parallel degree in tables or indexes (dba_tables or dba_indexes) 'select table_name,degree from dba_tables where degree 1; or same for indexes. If degree is 1 then lot of temp segments are required for sorting. 3-Same may result due use of parallel in hint. 4) In short it is application/code related and that is to be fixed first. Beside for DW house application temp space may require big space for large sorts may be 6-8GB. HTH, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Sun, 27 Jul 2003 07:34:24 -0800 As suggested, we checked all the tablespaces. TEMP space was increased from 2GB to 4GB and then to 6GB. We ended up bouncing the Oracle instance each time TEMP filled up because we really had nothing to lose. After doing this 3 maybe 4 times, we ran the same scenario in the application and this time (and a few times after that to be sure), TEMP did not fill up - only used 0.5%. Then we decreased TEMP to 2GB and everything still seemed to work. We had opened a severity level 1 TAR with Oracle and have now reduced it to level 2 because we don't have a case to present to them now. We don't really understand why this was happening or how the problem got fixed. Since today is a production day, we'll probably find out if it happens again. I know we weren't imagining the entire thing! Thank you all for your suggestions. They were extremely helpful. Saira --- John Blake [EMAIL PROTECTED] wrote: May not necessarily mean TEMP tablespace... Check all of your tablespaces for available free space, that is contiguous freespace. -Original Message- Guido Konsolke Sent: Sunday, July 27, 2003 3:04 AM To: Multiple recipients of list ORACLE-L Hi Saira, maybe temp tablespace isn't large enough. did you try what the doctor suggests? Did you enlarge the temp seg? 8-)) hth, Guido [EMAIL PROTECTED] 27.07. 05.54 Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow! Thanks, Saira -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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: John Blake 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: Saira Somani 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). _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
RE: 8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1
As suggested, we checked all the tablespaces. TEMP space was increased from 2GB to 4GB and then to 6GB. We ended up bouncing the Oracle instance each time TEMP filled up because we really had nothing to lose. After doing this 3 maybe 4 times, we ran the same scenario in the application and this time (and a few times after that to be sure), TEMP did not fill up - only used 0.5%. Then we decreased TEMP to 2GB and everything still seemed to work. We had opened a severity level 1 TAR with Oracle and have now reduced it to level 2 because we don't have a case to present to them now. We don't really understand why this was happening or how the problem got fixed. Since today is a production day, we'll probably find out if it happens again. I know we weren't imagining the entire thing! Thank you all for your suggestions. They were extremely helpful. Saira --- John Blake [EMAIL PROTECTED] wrote: May not necessarily mean TEMP tablespace... Check all of your tablespaces for available free space, that is contiguous freespace. -Original Message- Guido Konsolke Sent: Sunday, July 27, 2003 3:04 AM To: Multiple recipients of list ORACLE-L Hi Saira, maybe temp tablespace isn't large enough. did you try what the doctor suggests? Did you enlarge the temp seg? 8-)) hth, Guido [EMAIL PROTECTED] 27.07. 05.54 Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow! Thanks, Saira -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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: John Blake 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: Saira Somani 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).
8i ORA-1652 after upgrading from AIX 4.3.3 to 5.1
Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow! Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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).
8.1.7 instance on upgraded AIX machine - ORA-1652 all the time
Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow 8AM! Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time
Exactly. However, less than 24 hours ago these queries (dynamically generated by the application) were working fine and our TEMP space looked healthy. So I did what you suggested; now TEMP is 4GB larger than it used to be, and I'm still running into the same error. I'm watching the TEMP space fill up and the query structure is not new and isn't retrieving that many rows. I'm thinking that it has to do with the AIX upgrade for starters and I feel that it has something to do with SORTING but I have no evidence yet. Thanks anyway. Saira PS I am learning the DBA role - not an expert by any means. --- Ganesh Raja [EMAIL PROTECTED] wrote: From the docs... ORA-01652 unable to extend temp segment by string in tablespace string Cause: Failed to allocate an extent for temporary segment in tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. So Check your Temp TBS. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Saira Somani Sent: Sunday, July 27, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow 8AM! Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Ganesh Raja 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: Saira Somani 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: 8.1.7 instance on upgraded AIX machine - ORA-1652 all the time
We are using 32-bit on 5L. I don't think Oracle 8.1.7 is compatible with 64-bit AIX kernel. --- Mladen Gogala [EMAIL PROTECTED] wrote: Your 1652 error means the following: 01652, 0, unable to extend temp segment by %s in tablespace %s // *Cause: Failed to allocate an extent for temp segment in tablespace. // *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more // files to the tablespace indicated. If everything else is the same, I would say that the new OS is using a different OS filesystem block size. That would mess up all your file sizes, allocations and alike. You are probably using 64 bit JFS on 5L, straight up from 32-bit 4.3.3? On 2003.07.27 00:39, Saira Somani wrote: Hi Gurus, After upgrading the OS from AIX 4.3.3 to 5.1, our Oracle 8i instance is dishing out plenty of ORA-1652 which means that our application cannot commit any transactions (or so I am finding in my tests). Help. The warehouse needs to be in production tomorrow 8AM! Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Saira Somani 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).
Oracle 9i Lite and cellular technology
I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i Lite and cellular technology
Thank you. As per your suggestion, I have been able to locate some pertinent information and terminology starting with CDPD. Thanks! Saira -Original Message- Goulet, Dick Sent: July 15, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Saira, If you have a Metalink Account do a search on CDPD. There is a forum discussion on what your asking. May create more questions than answers, but that's what the forums are for. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 15, 2003 3:44 PM To: Multiple recipients of list ORACLE-L I have been asked to explore the possibility of migrating our current mobile application on 9i Lite to cellular technology. I don't know where to begin. What are the hardware requirements (other than the handheld units)? I probably need a subscription to a provider that can facilitate this for us but who would that be? What about changes to the application? If anyone else has explored this possibility or has implemented it, sharing your experiences would be greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-01722 while using sqlldr
I'm hoping for expert assistance. I'm using SQL*Loader to load some 2200+ records (comma delimited) into a table and running into this problem for the modcnt field: The control file reads: modcnt DECIMAL EXTERNAL -- I'm sure this is where my problem is. I have tried almost every datatype that the control file will accept - some bleed into the next column which is a date field, messing up that column, etc with ORA-01841 (full) year must be between -4713 and +, and not be 0. The datatype in the table is: MODCNT NUMBER -- no precision defined The value in the file for this field is always 0. And when I start to load the file, I receive this error (I'm testing with a few random records from the 2200+ and each have the same error): Record 1: Rejected - Error on table LC_F, column MODCNT. ORA-01722: invalid number Any help is greatly appreciated. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Loader problem - constraint violation
After reading some archives on google, I came up with this solution: Drop the index. Use sqlldr to append to the table - for the id column, use: (lc_rid sequence (max,1) ...) Recreate the index. However, when I did this, I received an error message saying that I can't have duplicates in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Loader problem - constraint violation
Ok. I must be legally blind :) Can this happen to anyone or just me? I will try this again with my bifocals on. Thank you for pointing it out kindly!! Saira -Original Message- Sent: July 8, 2003 8:46 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Saira It looks like your index is being created on the LOC column, right? CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) So your change to the lc_rid column did not fix this problem. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, July 08, 2003 9:29 AM To: Multiple recipients of list ORACLE-L After reading some archives on google, I came up with this solution: Drop the index. Use sqlldr to append to the table - for the id column, use: (lc_rid sequence (max,1) ...) Recreate the index. However, when I did this, I received an error message saying that I can't have duplicates in the index (of course not because the index is to be unique). But I checked lc_rid for duplicates and didn't find any. So what am I missing here? Thanks, Saira -Original Message- Saira Somani-Mendelin Sent: July 7, 2003 3:59 PM To: Multiple recipients of list ORACLE-L I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*Loader problem - constraint violation
I'm new to sqlldr and here is my control file: LOAD DATA INFILE '/home/oracle/116.csv' BADFILE '/home/oracle/116.bad' DISCARDFILE '/home/oracle/116.rej' APPEND INTO TABLE LC_F FIELDS TERMINATED BY ',' TRAILING NULLCOLS (lc_rid,loc,loc_type,loc_size,sku,pkg,lot,uc1,uc2,uc3,zone,area,loc_stt, cycc_stat,size_load_cap,store_seq,cmd_seq,hgt,wid,dpth,wgt,pal_req,ck_di git,repl_batch_qty,repl_dynam_qty,repl_uom,trig_batch_qty,trig_dynam_qty ,trig_uom,eq_class,tag_track,cap_by_load,cycc_date,whse,route,carrier,ca rrier_grp,trailer,carrier_trailer,seal,pgmmod,usrmod,modcnt,dtimecre,dti memod,empty,linehaul_carrier,max_fp_cap,search,aisle_grp) lc_rid is a unique index primary key and I'm not sure how to handle that. Do I include it as a field in my INFILE? Do I define it as NEXTVAL somehow? Here is a snippet from the log file: Record 1: Rejected - Error on table LC_F. ORA-1: unique constraint (TEST65W.LCI_LOC) violated LCI_LOC looks like this: CREATE UNIQUE INDEX LCI_LOC ON LC_F(LOC) If anyone can help, it would be very appreciated. Thank you, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani-Mendelin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: uuencode and mail
Hi all, Platform: AIX 4.3.3 I realize this off topic but it is somewhat related. Each morning a cron job creates an SQL*Plus output in csv format which gets e-mailed out as an attachment: $ uuencode somefile.csv somefile.csv |mail -s Here is your file [EMAIL PROTECTED] I still want to continue receiving the attachment but I cannot figure out how to write an e-mail message in the body of that e-mail which gives an explanation of what the report is and contains a disclaimer type clause. If I do this: uuencode somefile.csv somefile.csv |mail -s TEST [EMAIL PROTECTED] testmsg I only receive what is in testmsg as the body of the e-mail and not the csv attachment. If anyone can contribute to a solution, I'd be grateful. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: uuencode and mail
Hey that worked. Thanks! Saira -Original Message- Matthew Zito Sent: June 11, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Just append the file to the bottom of the message you want to send. S...: echo This is my message about this report testmsg uuencode somefile.csv somefile.csv testmsg mail -s Candygram! [EMAIL PROTECTED] testmsg Something like that. Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Saira Somani Sent: Wednesday, June 11, 2003 12:55 PM To: Multiple recipients of list ORACLE-L Subject: OT: uuencode and mail Hi all, Platform: AIX 4.3.3 I realize this off topic but it is somewhat related. Each morning a cron job creates an SQL*Plus output in csv format which gets e-mailed out as an attachment: $ uuencode somefile.csv somefile.csv |mail -s Here is your file [EMAIL PROTECTED] I still want to continue receiving the attachment but I cannot figure out how to write an e-mail message in the body of that e-mail which gives an explanation of what the report is and contains a disclaimer type clause. If I do this: uuencode somefile.csv somefile.csv |mail -s TEST [EMAIL PROTECTED] testmsg I only receive what is in testmsg as the body of the e-mail and not the csv attachment. If anyone can contribute to a solution, I'd be grateful. Thanks, Saira -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Matthew Zito 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: Saira Somani 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: Good technical documents/references on tuning restores
Title: RE: Good technical documents/references on tuning restores Weve had this occur before. Check connections at the physical layer they might be loose. We changed the Ethernet cable and it seemed to work optimally after that. The cable should ideally be better (more insulated) than the generic store brand [I think] but I am not a network expert. Hope that helps. Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: June 5, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Good technical documents/references on tuning restores 10/100 Mb/sec ethernet. So, if it is slow any advice? Thanks, Paula -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 04, 2003 5:52 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Good technical documents/references on tuning restores Importance: High That's 2.5 MB per second, which ain't bad on what I assume is 10m ethernet. If it's on 100MB or 1G ethernet, then it's rather slow. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/03/2003 06:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Good technical documents/references on tuning restores Okay, almost 4 minutes for a datafile that was 78168 blocks - how do I know if this is reasonable? Also, seems to write these files out (restore sychron.) why can't it restore different datafiles in parallel? - stupid question huh? -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:46 PM To: Stankus, Paula G; '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores SELECT SID, SERIAL#, CONTEXT, ROUND(SOFAR/TOTALWORK*100,2) % complete, SUBSTR(TO_CHAR(SYSDATE,'HH24:MI:SS'),1,15) Time now FROM V$SESSION_LONGOPS WHERE OPNAME like '%restore%'; . showed all 100% complete but msglog from RMAN shows it is truly still running. -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:40 PM To: Stankus, Paula G; '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores Also found on monitoring performance of RMAN jobs: Note:144640.1 on Metalink -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:36 PM To: Stankus, Paula G; '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores Found this white paper: http://otn.oracle.com/deploy/availability/pdf/rman_performance_wp.pdf Anything better? -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:33 PM To: Stankus, Paula G; '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores This is what I have set on my target database: --- --- --- backup_tape_io_slaves boolean FALSE tape_asynch_io boolean TRUE Version 8.1.7.4 database and RMAN catalog - 32 bit Networker MML Using RAID 1+0 Solaris 2.8 -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:28 PM To: Stankus, Paula G; '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores Okay - from my reading you don't need to have multiple tape io slaves if you are using asynch. I/O. Again, best document for perf. tuning database restores using RMAN would make mucho difference. Read old note about someone doing an analyze on the RMAN catalog tables to improve performance of restore. I think it has something to do with how quickly it finds the file on tape and writes to disk. -Original Message- From: Stankus, Paula G Sent: Tuesday, June 03, 2003 8:25 PM To: '[EMAIL PROTECTED]' Subject: RE: Good technical documents/references on tuning restores Seems to be taking awfully long to read files from tape and write to disk. I allocate multiple tape channels like I do for the backup which only takes about 45 minutes. Does not seem to be spawning multiple sessions. Do I need to change parameters on my init.ora file to use multiple tape io slaves to see this. Anyway, would like notes/docs., references if you all have some. Thanks, Paula
SQL statement problem - outer join where?
Hi, I'm facing a bit of an struggle with this SQL statement. The one below results in the correct number of records (601). However, when I add the tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get fewer records (526). The reason is because there are item numbers which do not have an ITEM_C record which is perfectly acceptable. But for the purposes of this report, I need to show all 601 records even if there is no ITEM_C record for a particular item number. I know there is an outer join somewhere. And I'm also almost sure that this SQL statement has been written incorrectly. Of course it isn't tuned either. If anyone is able to assist me, I would be very grateful. Thanks in advance, Saira SELECT F.ORDER_DATE, B.SHIP_NUM, C.SORT_NAME, F.ORDER_NUM, B.PPS_NUM, A.ITEM_NUM, D.DESC_1, A.TO_ALLOC_QTY, A.SHIPPED_QTY, A.BO_QTY, E.UOM FROM SHIP_L A, SHIP B, CUST_SHP C, ITEM D, UOM E, ORD F WHERE A.SHIP_ID=B.SHIP_ID AND B.CUST_NUM=C.CUST_NUM AND B.SHIP_NUM=C.SHIP_NUM AND A.ITEM_NUM=D.ITEM_NUM AND D.STOCK_UOM_ID=E.UOM_ID AND B.ORD_ID=F.ORD_ID AND A.TO_ALLOC_QTY A.SHIPPED_QTY AND F.DIV_CODE='01' AND F.CANCELLED='N' AND A.WHSE_CODE='HL1' AND B.PPS_PRINTED='Y' AND F.DIV_CODE='01' AND F.CANCELLED='N' AND B.CUST_NUM='2' AND F.ORDER_DATE=SYSDATE-1 ORDER BY F.ORDER_DATE, C.SORT_NAME; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: uuencode adding characters
Thanks. I guess this would be a good time to learn Perl :) -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage return characters added everywhere (I have line feeds in the report for ease of readability). I think maybe the uuencode is messing it up(?) Users of this report will likely open it up in Notepad and get confused - or worse, complain. Anyone else have the same issues? No, but you could easily write a perl script to clean it up, take about 3 lines of code. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: uuencode adding characters
Chris, Can you give me a hint? So I use Perl to rid the file of these characters and then uuencode it and then use mail utility to send to people? Won't uuencode do the same thing again and add those characters back? Thanks! -Original Message- Berry Sent: March 27, 2003 4:39 PM To: Multiple recipients of list ORACLE-L From: Saira Somani [EMAIL PROTECTED] AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage return characters added everywhere (I have line feeds in the report for ease of readability). I think maybe the uuencode is messing it up(?) Users of this report will likely open it up in Notepad and get confused - or worse, complain. Anyone else have the same issues? No, but you could easily write a perl script to clean it up, take about 3 lines of code. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Berry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: uuencode adding characters
List, AIX 4.3.3 ORACLE 8.1.7.0.0 I have a spooled report from an SQL script which I am e-mailing, also from a script using the uuencode utility. The spooled report looks fine but once it is e-mailed, it looks funny with carriage return characters added everywhere (I have line feeds in the report for ease of readability). I think maybe the uuencode is messing it up(?) Users of this report will likely open it up in Notepad and get confused - or worse, complain. Anyone else have the same issues? Thanks in advance for your responses! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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).
DW reading for design and implementation
Listers, We are in our first year of production and our transactions are growing in volumes unforeseen. Our management team, our customers, and our clients are most interested in analyzing historical trends so they can better predict future trends. At the moment we use ad-hoc reporting at month/period end on our operational database which is the only database structure we have at the moment. Technology infrastructure Oracle 8.1.7.0.0 on RS/6000 Cognos BI Tools - Impromptu and PowerPlay I'm looking to plan for the future. What do I do? Am I to build a data warehouse? What are best practices? Is anyone able to recommend websites, articles, **books**, or share similar experiences to point me in the right direction? Thanks in advance for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Number of joins in the query
A joins B joins C Is the same as A joins C So I would think 2 joins is all you need - 3 would give you an unnecessary loop...but I could be wrong. -Original Message- Krishnaswamy, Ranganath Sent: February 27, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Dear List, I have a basic doubt about the number of joins I should have. Say, I have three tables by name station, station_restriction and stn_rstcn_to_frm with the following structure: StationStation_restriction stn_rstcn_to_frm -- - stn_key(PK) stn_rstcn_key(PK)stn_rstcn_key(FK) station_code stn_key(FK) stn_key(FK) station_namerestricted_position country If I have to select data from all the three tables should I have two joins or three joins? If I have two joins, I would have Station.stn_key=Station_restriction.stn_key and Station_restriction.stn_rstcn_key = stn_rstcn_to_frm.stn_rstcn_key. If I have three joins I would have Station.stn_key=Station_restriction.stn_key and Station_restriction.stn_rstcn_key = stn_rstcn_to_frm.stn_rstcn_key and Station.stn_key = stn_rstcn_to_frm.stn_key Can anybody let me know as to how many joins should I have so that I don't get any cartesian product in the result set? I am sorry if the question sounds trivial to someone but I got this basic doubt while writing a complex query for a multi-table join. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath 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: Saira Somani 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: SQL struggle - UPDATE too?
I'd prefer a procedure as it is likely that this will have to be run every week. FYI: I'm not looking for you to write the code for me, just give me some general direction as I am new to PL/SQL and now I've been asked by management to script this. This is what happens when your IT department is comprised of 1 person. Thank you kindly for all your help. Saira -Original Message- [EMAIL PROTECTED] Sent: February 25, 2003 11:14 PM To: Multiple recipients of list ORACLE-L Saira : how do u want to achive this ? using procedure or a single update stmt ? -Original Message- Somani Sent: Tuesday, February 25, 2003 3:27 PM To: Multiple recipients of list ORACLE-L I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COSTLAST_COST_REV - -- HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: [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
RE: SQL struggle - UPDATE too?
Thanks. But neither statements work. hl1_cost is never populated for any of the -OR items. whse_code and item_num are the primary keys. Thanks again for your help. Saira -Original Message- Sent: February 26, 2003 12:29 AM To: Multiple recipients of list ORACLE-L Do these SQL statements work ? SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu / UPDATE ( SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu WHERE whse_code 'HL1' ) SET last_cost = hl1_cost / Note: whse_code and item_num could be removed from the UPDATE statement. Also, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COST LAST_COST_REV - - - HL1 1112301.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 6503004.789 4.789 TWH-STAT 6503000 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chip 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
RE: SQL struggle - UPDATE too?
This worked: SELECT A.WHSE_CODE,A.ITEM_NUM,B.LAST_COST FROM ITEM_W A,(SELECT DISTINCT (LAST_COST),SUBSTR(ITEM_NUM,1,6) ITEM_NUM FROM ITEM_W WHERE LAST_COST0) B WHERE SUBSTR(A.ITEM_NUM,1,6) = B.ITEM_NUM AND RTRIM(A.WHSE_CODE) NOT LIKE ('CD%'); A suggestion from someone on the COGNOS mailing list. I created a view in Oracle and now I can easily access it from a report. Here are some additional thoughts: Thanks to all who helped but I have to say, just because most of you have been in the business for over a decade (or even half a decade) does not mean that all of us have, so when we do ask a question, it is usually because WE DON'T KNOW or CAN'T FIND THE ANSWER or some such dire constraint. Kindly do not assume that we have not done our homework and that we want you to do it for us. Give me maybe half a decade and I'll be able to answer my own questions and some of yours. There is such a thing as too much information and sometimes wading through it takes a lot of time when you are on a deadline and have people breathing down your back. I thought the list was for everyone requiring some assistance or to exchange ideas. I'm sure I'll be receiving hate mails from some of you out there ;) I already received snarly remarks when I posted the first message. Thanks again and I do learn something new from this list every day. Saira -Original Message- Sent: February 26, 2003 12:29 AM To: Multiple recipients of list ORACLE-L Do these SQL statements work ? SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu / UPDATE ( SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu WHERE whse_code 'HL1' ) SET last_cost = hl1_cost / Note: whse_code and item_num could be removed from the UPDATE statement. Also, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COST LAST_COST_REV - - - HL1 1112301.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0
RE: SQL struggle - UPDATE too?
Quote from one of the listers: With free advice, you get what you paid for it. If you bite the hand that feeds you, you may just go hungry the next time you ask for a handout. NOBODY owes you an answer; regardless of how dire a situation you find yourself. HAND! I will end this message thread here. Thanks all. I will retreat to my humble cubicle now. Saira -Original Message- Gorden-Ozgul, Patricia E Sent: February 26, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Always take what you need and leave the rest. ...and don't take any list comments personally. -Original Message- Sent: Wednesday, February 26, 2003 11:29 AM To: Multiple recipients of list ORACLE-L This worked: SELECT A.WHSE_CODE,A.ITEM_NUM,B.LAST_COST FROM ITEM_W A,(SELECT DISTINCT (LAST_COST),SUBSTR(ITEM_NUM,1,6) ITEM_NUM FROM ITEM_W WHERE LAST_COST0) B WHERE SUBSTR(A.ITEM_NUM,1,6) = B.ITEM_NUM AND RTRIM(A.WHSE_CODE) NOT LIKE ('CD%'); A suggestion from someone on the COGNOS mailing list. I created a view in Oracle and now I can easily access it from a report. Here are some additional thoughts: Thanks to all who helped but I have to say, just because most of you have been in the business for over a decade (or even half a decade) does not mean that all of us have, so when we do ask a question, it is usually because WE DON'T KNOW or CAN'T FIND THE ANSWER or some such dire constraint. Kindly do not assume that we have not done our homework and that we want you to do it for us. Give me maybe half a decade and I'll be able to answer my own questions and some of yours. There is such a thing as too much information and sometimes wading through it takes a lot of time when you are on a deadline and have people breathing down your back. I thought the list was for everyone requiring some assistance or to exchange ideas. I'm sure I'll be receiving hate mails from some of you out there ;) I already received snarly remarks when I posted the first message. Thanks again and I do learn something new from this list every day. Saira -Original Message- Sent: February 26, 2003 12:29 AM To: Multiple recipients of list ORACLE-L Do these SQL statements work ? SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu / UPDATE ( SELECT whse_code , item_num , last_cost , ( SELECT last_cost FROM item_whl1 WHERE whse_code = 'HL1' ANDREPLACE(u.item_num,'-OR') = hl1.item_num ) hl1_cost FROM item_wu WHERE whse_code 'HL1' ) SET last_cost = hl1_cost / Note: whse_code and item_num could be removed from the UPDATE statement. Also, added WHERE whse_code 'HL1' so the source last_cost is not updated to its current value (reduces redo log entries and rollback segment usage). Have Fun :) Saira Somani wrote: I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display
SQL struggle
List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COSTLAST_COST_REV - -- HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: SQL struggle
Title: RE: SQL struggle Thank you for your assistance it works - and I have one more question: How can I also get the SELECT to show me the original item number i.e with the -OR? Thanks, Saira -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED] Sent: February 25, 2003 1:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL struggle (see answer below) -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODE ITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR 0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODE ITEM_NUM LAST_COST LAST_COST_REV - - - HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Would this work? select a.whse_code, a.item_num, a.last_cost, b.last_cost as last_cost_rev from item_w a, item_w b where a.last_cost = 0 and replace (a.item_num, '-OR') = b.item_num and b.last_cost 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost 0 ;
RE: SQL struggle - UPDATE too?
I am very confused (and fairly new to SQL which would be my excuse to post such amateurish questions on this list). Now I've been asked to update LAST_COST on item_w so it looks like this: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR1.12 CPD-TGH 111230-OR1.12 HL1 50034 .91 MSH-CDS 50034 .91 CPD-TGH 50034-OR .91 HL1 650300 4.789 TWH-STAT 650300 4.789 CPD-TWH 650300-OR 4.789 CPD-TGH 650300-OR 4.789 -Original Message- Sent: February 25, 2003 12:55 PM To: '[EMAIL PROTECTED]' List Gurus, I need help and I won't be ashamed to ask :) Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODEITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODEITEM_NUM LAST_COSTLAST_COST_REV - -- HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Thanks in advance for your time, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: UPDATE...REPLACE...#39;...apostrophe...
Title: RE: SQL struggle SYNTAX for REPLACE is: REPLACE(col1,string_exp,exp1) If you want to replace with nothing, just do this: UPDATE tbl SET col = REPLACE (col, #39;,); And that should replace all instances of #39 with nothing. I hope thats what you were looking for. Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gorden-Ozgul, Patricia E Sent: February 25, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Subject: UPDATE...REPLACE...'...apostrophe... I'm running Oracle on Solaris 2.6. I successfully inserted data from a composite file byreplacing apostrophes with #39; by way of sed...s/'/\#39;/g...beforehand. Now I need to perform an UPDATE, REPLACE... UPDATE tbl SET col = REPLACE(col, '#39;', ...with what?) Please advise. Pat -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL struggle Thank you for your assistance - it works - and I have one more question: How can I also get the SELECT to show me the original item number - i.e with the '-OR'? Thanks, Saira -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED] Sent: February 25, 2003 1:57 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: RE: SQL struggle (see answer below) -Original Message- From: Saira Somani [mailto:[EMAIL PROTECTED]] Oracle 8.1.7 on AIX 4.3 Here is what my data looks like in a table called item_w: WHSE_CODE ITEM_NUM LAST_COST -- -- HL1 111230 1.12 CPD-TWH 111230-OR 0 CPD-TGH 111230-OR 0 HL1 50034 .91 MSH-CDS 50034 0 CPD-TGH 50034-OR 0 HL1 650300 4.789 TWH-STAT 650300 0 CPD-TWH 650300-OR 0 CPD-TGH 650300-OR 0 If you'll notice, only the items with WHSE_CODE='HL1' have a cost associated with them. What I need to is: Parse ITEM_NUM for those items which have a suffix of -OR in order to compare with an ITEM_NUM without -OR so that I can take the last cost from there and display it beside the one that has -OR. Also note, there are some $0 cost items that don't have a suffix of -OR; I would need to match those up with a cost as well. So in the end, I suppose, this is the result I'm looking for: WHSE_CODE ITEM_NUM LAST_COST LAST_COST_REV - - - HL1 111230 1.12 1.12 CPD-TWH 111230-OR 0 1.12 CPD-TGH 111230-OR 0 1.12 HL1 50034 0.91 0.91 MSH-CDS 50034 0 0.91 CPD-TGH 50034-OR 0 0.91 HL1 650300 4.789 4.789 TWH-STAT 650300 0 4.789 CPD-TWH 650300-OR 0 4.789 CPD-TGH 650300-OR 0 4.789 And if any of you out there use Cognos Impromptu, perhaps you could tell me how I can achieve these results in a report. Would this work? select a.whse_code, a.item_num, a.last_cost, b.last_cost as last_cost_rev from item_w a, item_w b where a.last_cost = 0 and replace (a.item_num, '-OR') = b.item_num and b.last_cost 0 union select c.whse_code, c.item_num, c.last_cost, c.last_cost as last_cost_rev from item_w c where c.last_cost 0 ;
RE: Oracle 9i Lite - any help please?
Mogens, We did exactly as indicated in the e-mail from Martin and were encountering the same problems as before. Any helpful hints from your colleagues would be much appreciated. Thanks, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mogens Nørgaard Sent: February 7, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle 9i Lite - any help please? Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messagesproduces a lot of work for us, which is whyyou might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues. It looks like data does not get applied to the Oracle Lite (PROCESSING)database. Client changes are sent to the Mobile Server(SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database. COMPOSING client data SENDING client data to the Mobile Server RECEIVING data from the server PROCESSING (apply) data to the client database The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions. 1. Drop the application from Control Center 2. Drop the client database(s) 3. Publish the applicationinto Mobile Server 4. Provision the application 5. Execute sync We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows). -- martin
RE: Oracle 9i Lite - any help please?
Oracle has recommended patchset 2697758 Oracle9i Lite 5.0.1.6.0 patch for base version 5.0.1.0.0 - perhaps that will help. I will keep you informed. Thanks again, Saira -Original Message- Somani Sent: February 17, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Mogens, We did exactly as indicated in the e-mail from Martin and were encountering the same problems as before. Any helpful hints from your colleagues would be much appreciated. Thanks, Saira -Original Message- Nørgaard Sent: February 7, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN, which makes it #3 of all Oracle Products. This outstanding number of messages produces a lot of work for us, which is why you might experience slower than expected turn around for certain postings. We apologize for the delay but you can rest assured that we do everything in our power to resolve your issues. It looks like data does not get applied to the Oracle Lite (PROCESSING) database. Client changes are sent to the Mobile Server (SENDING). The client also received data from the server (RECEIVING). It might be that replication never finishes (commits) the transaction (since it hangs), which is why MGP might not pick up the changes and apply them to the Oracle database. COMPOSING client data SENDING client data to the Mobile Server RECEIVING data from the server PROCESSING (apply) data to the client database The PK change in one of your application table might actually be the culprit. Please follow the procedure below and let me know if you have further questions. 1. Drop the application from Control Center 2. Drop the client database(s) 3. Publish the application into Mobile Server 4. Provision the application 5. Execute sync We recommend to use Oracle9i Lite 5.0.2 release with 5.0.2.3.0 Windows patch (the latest on Windows). -- martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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).
Oracle 9i Lite - any help please?
Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using this product :-) RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC - records to process yet PROCESSING does not occur We have changed records on the client in offline mode and now want to syncronize with the server. There are records to be processed - yet, in MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING. As a result, our records on the server are not updated. MGP is running, and when we retry, we allow for complete cycles to occur before our next attempt. After trying about 20 times (no kidding), the PROCCESSING bar on the MSYNC screen works. This is unacceptable and not to mention unreliable. Please help. Please also see my previous message on a related issue. Perhaps you can see a connection, I can't as yet. Thanks, Saira RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC sticks on PROCESSING bar Recently we made a change to a table in our repository in 8i - changed a primary key. After this, the application was republished in Oracle 9i Lite and all client databases (Pocket PC Strong ARM) were refreshed (i.e. database was removed from the client and sync'd 3 times before usage). We have noticed that now, after the change, during the MSYNC process, that status bar hangs on the PROCESSING phase of MSYNC. The only way to rid this is by warm booting the PDA and trying it multiple times until it is successful (which sometimes it is and sometimes isn't). However, even when the PROCESSING bar has not completed until the end, the data from the PDA is sent but this is unreliable as all the MSYNC processes are not complete. This is inefficient. Any suggestions? Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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 Lite - any help please?
Mogens, Thank you kindly for forwarding my questions to the head honcho. I would be extremely pleased if he responded but not offended if he didn't. Funny enough, we are currently using Lite with Intermec 700 handhelds (StrongARM chipset) running Pocket PC (Windows CE) in hospitals to manage supply carts. Interesting business. So since I have inherited administration of this software, I not an expert yet, but quickly finding out where documentation and logging is sparse. I find that it is quite difficult to figure out where a problem has occurred. Take for example the MSYNC process on the client which synchronizes with the repository on the 8i server. Every time the client syncs, the client tells me it is successful, even though it isn't. Secondly, there is processing that is performed on synchronization - I know for a fact that there is data to be processed, yet this client never fulfills that request to process the data and as a result, changes are not reflected in the repository. Then take migration. I wanted to upgrade from 5.0.1.X.0 to 5.0.2.X.0 - and I found out that I cannot even log into the administrative console. And that would be fine, if there was documentation that told me this is possible (maybe I missed that PDF, I don't know - too much information, too little time). And how about documentation on the tracing. Especially interpretation of the log/trace files - there is no guideline to explain to me what I can expect from the logging/tracing (again, maybe it's me for missing that PDF but I have searched for many months with little success). I think it is a good product with many bugs and I think it can be used very effectively if administered/configured optimally. I just think that there isn't enough expertise out there yet to assist those who have decided to go with this product. From an administrative standpoint, I find it difficult to grasp how and where errors are occurring. Even more difficult is trying to figure out a pattern to the errors. They are sporadic, inconsistent, and show no symptoms. Alerts for MGP failing are non-existent - don't know when it will go down and when it does, I can't explain why. Overall, I can see it having success in the right environment and with a stable release. Hope this helped but didn't offend any. Thanks again, Saira -Original Message- Nørgaard Sent: February 6, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Saira, I've forwarded your message to the CTO of Oracle Lite, my old friend Jacob Christfort, whom I know from our days at the National Hospital Dormitory in Copenhagen, where we had lots of fun, and where many nurses lived. Those were the days, but sadly we both ended up working with IT. If Jacob responds (he's a rather busy guy) I'll forward the responses to the list. Can I ask you what you think of Lite in general? I don't see many sites using it, but it looks like a cool thing for the right purpose... Best regards, Mogens Saira Somani wrote: Posted 2 messages in Oracle 9i Lite Forum on Metalink. No responses yet. I'm looking to this list for help on either of these issues. Thanks in advance for your time. Please e-mail me privately ([EMAIL PROTECTED]) if this is not the proper forum for these issues. Someone out there has to be using this product :-) --- - RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC - records to process yet PROCESSING does not occur We have changed records on the client in offline mode and now want to syncronize with the server. There are records to be processed - yet, in MSYNC, it goes through COMPOSING, SENDING, RECEIVING but no PROCESSING. As a result, our records on the server are not updated. MGP is running, and when we retry, we allow for complete cycles to occur before our next attempt. After trying about 20 times (no kidding), the PROCCESSING bar on the MSYNC screen works. This is unacceptable and not to mention unreliable. Please help. Please also see my previous message on a related issue. Perhaps you can see a connection, I can't as yet. Thanks, Saira --- - RDBMS Version: 8.1.7.0.0 Operating System and Version: Windows 2000 Server SP3 Error Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Oracle 9i Lite Product Version: 5.0.1.1 MSYNC sticks on PROCESSING bar Recently we made a change to a table in our repository in 8i - changed a primary key. After this, the application was republished in Oracle 9i Lite and all client databases (Pocket PC Strong ARM) were refreshed (i.e. database was removed from the client and sync'd 3 times before usage). We have noticed that now, after the change, during the MSYNC process, that status bar hangs on the PROCESSING
over-normalized?
Is there such thing as an over-normalized database design? What defines over-normalization? And what are its consequences? (Other than the obvious degraded database performance and lots of tuning) I hear rumblings that our ERP system is over-normalized. Just curious, Thanks! Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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).
ORA-2289 - anyone?
Let me try this one more time. We are running Oracle 8.1.7 and I received an ORA-2289 as indicated below. Does anyone out there think he/she might be able to help me? Or at least point me in the right direction. Thanks again. Saira -Original Message- Somani Sent: January 20, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi all, I'm new at this game and am running into this Oracle error in our training environment. I have searched on the web and the archives but I am not sure about a resolution to this issue. Any comments/insights would be appreciated. After investigating the issue, I found that there is a crash when trying to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other temporary tables. Here are the errors: biora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_item_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_load_err_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470 Error code = 2289. Here is the description of the 2289 error: // *Cause: The specified sequence does not exist, or the user does // not have the required privilege to perform this operation. // *Action: Make sure the sequence name is correct, and that you have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Saira Somani 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: ORA-2289 - anyone?
Thank you all for your suggestions. And kindly excuse my abruptness. I was feeling a bit ignored ;) I find this list EXTREMELY useful and as a newbie, I am grateful for its existence. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 7:19 AM Let me try this one more time. We are running Oracle 8.1.7 and I received an ORA-2289 as indicated below. Does anyone out there think he/she might be able to help me? Or at least point me in the right direction. Thanks again. Saira -Original Message- Somani Sent: January 20, 2003 9:44 AM To: Multiple recipients of list ORACLE-L Hi all, I'm new at this game and am running into this Oracle error in our training environment. I have searched on the web and the archives but I am not sure about a resolution to this issue. Any comments/insights would be appreciated. After investigating the issue, I found that there is a crash when trying to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other temporary tables. Here are the errors: biora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_item_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_load_err_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470 Error code = 2289. Here is the description of the 2289 error: // *Cause: The specified sequence does not exist, or the user does // not have the required privilege to perform this operation. // *Action: Make sure the sequence name is correct, and that you have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Saira Somani 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: 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: Saira Somani 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
ORA-2289
Hi all, I'm new at this game and am running into this Oracle error in our training environment. I have searched on the web and the archives but I am not sure about a resolution to this issue. Any comments/insights would be appreciated. After investigating the issue, I found that there is a crash when trying to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other temporary tables. Here are the errors: biora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_item_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_work_load_err_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470 Error code = 2289. dbiora8x.cpp 05469 Couldn't execute : drop sequence tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470 Error code = 2289. Here is the description of the 2289 error: // *Cause: The specified sequence does not exist, or the user does // not have the required privilege to perform this operation. // *Action: Make sure the sequence name is correct, and that you have // the right to perform the desired operation on this sequence. CUNAME:cu4 STATUS:-255 NATERR:-1 ERRMSG: PRGSQL:INSERT INTO tmp_asn_ship values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, Saira Somani IT Support/Analyst Hospital Logistics Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Orawomen
I have found that men are fascinated, not intimidated by techie girls. We can offer them fashion advice as well as hardware recommendations. Saira --- Farnsworth, Dave [EMAIL PROTECTED] wrote: I like geek girls!! Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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).
8i OCP DBA Exams
Hello Gurus, My company recently paid for the Oracle 8i DBA self-study courses to cover all 5 exams. Oracle sent me vouchers for the exams. The vouchers expire on July 31, 2003. Does that mean that the 8i DBA track is going to expire on that date and I really truly only have 6 months to write these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani 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: Happy Holidays!!
Rachel, I'm in that category too. Newest Oracle DBA/Sys Admin on board at a 3rd Party Logistics company - Hospital Logistics Inc. And I admit! I'm a lurker :-) Saira Somani Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Lite
No one uses 9i Lite? Gurus, help me out!!! Saira -Original Message- Somani Sent: November 25, 2002 10:49 AM To: Multiple recipients of list ORACLE-L I wonder if there are any mailing lists out there for Oracle 9i Lite. Or for that matter, if any of you have used in the past or are using it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 9i Lite
Yes. Here is how it works [in a nutshell]: PDA (Lite Client) -- Oracle Mobile Server -- Oracle Server Repository -Original Message- Sent: November 26, 2002 3:15 PM To: Multiple recipients of list ORACLE-L Hi Dennis, This is a completely separate product, it is designed for mobile devices like pda's etc. Regards, John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i Lite
I wonder if there are any mailing lists out there for Oracle 9i Lite. Or for that matter, if any of you have used in the past or are using it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than the Oracle forums on their website), I would appreciate it. Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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).
replicate schemas
Hello Listers, This might be a very newbie-type question but I would like to know how I can replicate a schema in the same instance under a different schema name, of course - same data, etc. Thanks for your help. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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).
ORA-01089
Hello Gurus, This morning our database locked us out with the error code ORA-01089. Circumstances surrounding this occurrence were that a cold backup by Tivoli is taken performed every night at 4AM. When I spoke with our senior DBA, he confirmed that the database never shutdown properly before the backup and sure enough, I could see the processes this morning from yesterday. This is the second occurrence in 5 days. So my first question is, why would this happen? And secondly, how do I deal with it? Further to my conversation with the senior DBA, I was informed that indeed a shutdown abort command was issued but only after it was confirmed that everything was ok. What does he mean by that statement? What is he checking for before issuing the abort command? Thanks in advance and I would like to apologize if this question has been posed earlier at some point in time. I did search the archives but didn't find a satisfactory explanation. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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 Excel
Title: Oracle to Excel I usually spool my queries to a .txt (ascii) file and import into Excel. Easiest way for me. Im sure there are other more sophisticated solutions out there. Regards, Saira -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Burton, Laura L. Sent: November 6, 2002 1:49 PM To: Multiple recipients of list ORACLE-L Subject: Oracle to Excel I think I have seen traffic concerning the extracting of data from Oracle into an Excel spreadsheet. We now have a need for this. Could anyone enlighten me? Thank you in advance. Laura
Oracle 8.1.7 R 3 for W2K Sever on P4 Xeon Processor - problems?
I wonder if anyone could provide me with some insight on a problem our Sr. DBA is facing. We are trying to install Oracle 8.1.7 SE Release 3 on Win2K Server but our DBA believes that the problem lies with the hardware - a P4 Xeon processor. Has anyone else faced similar issues? Thanks, Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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).
update statistics
What is the equivalent in Oracle of the Informix UPDATE STATISTICS? Thanks much. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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).
trace an SQL session
How would I find out the exact SQL statement? I can locate the SQL_ADDRESS from the v$session table but I do not know where to go from there. I am running a query via an OLAP tool (Cognos Impromptu) and it is taking an excessive amount of time. I suppose it would also be a good idea to find if the query is a resource hog. Is it possible to trace that as well? Running Oracle 8.1.7 on AIX 4.3.3! Thanks in advance. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saira Somani 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).