RE: Trigger
Title: RE: Trigger Hi if (col1,col2,col3) are forming primary key means, then how come you insert value for any one of primary key columns, if so it would not give error for NOTNULL nIRMAL, -Original Message- From: Mercadante, Thomas F [SMTP:[EMAIL PROTECTED]] Sent: 06 ÔæÇá, 1422 04:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: Trigger Hamid, Change your trigger as follows: Create or replace trigger cre_PK before insert declare loc_seq number; begin select seqname.nextval into loc_seq from dual; insert into tableA(col1) values(loc_seq) end / Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, December 20, 2001 12:55 PM To: Multiple recipients of list ORACLE-L List, I need some help for creating a trigger, here is my question? I have a table TABLEA(col1,col2,col3) col1 is Primary Key for this table and an application insert records into this table, but I want to write a trigger on this table to generate primary key with using nexval of a sequence I have tried but doesn't work , if any of you have some sample or some links I really appreciate, This is my trigger: Create or replace trigger cre_PK before insert insert into tableA(col1) values(seqname.nextval) end Thanks in Advance Hamid Alavi Office 818 737-0526 Cell 818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - DBA interview questions I faced
Dear Ramesh D Papnoi, Thanks for the info. I will buy it. Regards. Dharan. --- [EMAIL PROTECTED] wrote: > Dear Ravi > DBA 101 book - BY Gaja and kirti is available in > India (indian edition). I > already have one. Excelent book!! > > Regards, > Ramesh D Papnoi > Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., > Mumbai, India > (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & > Developer) > http://www22.Brinkster.com/rpapnoi > > -- Original Text -- > > To: internet["Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]>] > > Dear Rachel, > > Thanks for your reply and guidance. Also thanks to > Kirti Deshpande and Jenny Jacobson for their > replies. > In India Oracle DBA 101 book is not yet released. > Once it is released I will defently purchase the > book. > > > Regarding Question No.1, I told that Server Process > is > the background process and sysauth or objauth view > is > used to check for username and password. The > employer told me that I am wrong. Could you pl > clarify. > > > 1) When you enter 'sqlplus scott/tiger' which > background process checks for authentication ? From > which table/view it checks for authentication ? If > password is wrong from where oracle throws the msg ? > > > Regards. > Dharan. > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Dharani Ravi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Change PCTINCREAE for SYSTEM Tablespace
Title: RE: RE: Change PCTINCREAE for SYSTEM Tablespace Hi Tom, Can you review my views in changing pctincrease value: If i'm creating database manualy without dbassistant, The steps are, 1) CONNECT INTERNAL 2) CREATE DATABASE ( LOGFILES, A SINGLE DATAFILE FOR SYSTEM TABLESPACE AND other infos) 3) CREATING SYSTEM TABLESPACE 4) OTHER STEPS. GOING ON... Now why not i can change the PCTINCREASE at the step3?... In what way it'd affect the DB? And why we need to change sql.bsq instead? Hope that i didn't say anything incorrect. Let me know ur valuable reply... Nirmal., -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: 03 ÔæÇá, 1422 04:50 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Change PCTINCREAE for SYSTEM Tablespace Tom, I agree and disagree with you, respectfully. Oracle does allow some changes to be made to sql.bsq and they always leave the option open to make changes after database creation and I don't see this request as all that odd. But for the most part if you do as recommended and leave the system tablespace to sys only you should not have a problem. That is until migration time!! Dick Goulet Reply Separator Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 12/18/2001 5:30 AM Kimberly, I would agree with you if an experienced DBA makes the decision to change the storage parameters, and they absolutely know what the benfits would be. Generally speaking though, I think changing anything in the SYSTEM tablespace is bad practice. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 17, 2001 8:45 PM To: Multiple recipients of list ORACLE-L Actually, I would not ignore the storage parameters of the SYSTEM tablespace. There are legit reasons to change the pctincrease to 0. If you leave it at 50 then SMON (or PMON can't remember at the moment) will try to coalesce the tablespace every time it wakes up. Its work it has to do that it really does not need to do. Better off scheduling to happen at your time schedule. -Original Message- Thomas F Sent: Monday, December 17, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Ken, Do yourself a favor. Ignore the SYSTEM tablespace storage params. The ONLY thing you should concern yourself in regard with the SYSTEM tablespace is if the file needs to extend itself because it is too full. All other storage parameters are created by Oracle at database create time and should not be changed. For other tablespaces, you can change this parameter anytime after the tablespace has been created. It will not, however, change existing extents, but will be used when new extents are allocated. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 17, 2001 10:16 AM To: Multiple recipients of list ORACLE-L Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace without recreating the DB? For some reason the person who created the DB I am working on set PCTINCREASE to 50 (or didn't did not include this parameter). I am using this DB for a data conversion so there is no software connected to it and in turn no users on it. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -
Oracle Client Installation.
Hi, I develop applications with Delphi 5 Client/Server suit. I used Oracle Database. (with BDE connection) I have a problem with client side. To run my program on some client machine , I install oracle client for this machine. Is there any way to run my program on client without installing oracle client. BECAUSE , when client number increase , my job become difficult , every time I take oracle client CD and install one machine then install other machine ...( I do not give oracle cd to clients beacause client do not know configuration) is there simple way to make setup disk with including my application file plus oracle client files to install client side ? I hope you will understand my question. Thank You.
Regarding report configuration
i wrote some reports in informix(.ace files). but recently we r shifting to oracle database. anybody having idea how to configure .ace files ?? any tool in oracle which we can use without much effort from our side to configure .ace files ? i hope i am clear. if not, please revert back to me. regards, santosh
Re: Help - DBA interview questions I faced
you can get the documentation online. read it. according to the publishers, DBA 101 has been released in India. and it is available on the internet at any of the online book stores --- Dharani Ravi <[EMAIL PROTECTED]> wrote: > Dear Rachel, > > Thanks for your reply and guidance. Also thanks to > Kirti Deshpande and Jenny Jacobson for their replies. > In India Oracle DBA 101 book is not yet released. > Once it is released I will defently purchase the book. > > > Regarding Question No.1, I told that Server Process is > the background process and sysauth or objauth view is > used to check for username and password. The > employer told me that I am wrong. Could you pl > clarify. > > > 1) When you enter 'sqlplus scott/tiger' which > background process checks for authentication ? From > which table/view it checks for authentication ? If > password is wrong from where oracle throws the msg ? > > Regards. > Dharan. > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dharani Ravi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - DBA interview questions I faced
dba 101 is not by gaja and kirti -- that's performance tuning 101 which is indeed an excellent book dba 101 is theriault, carmichael and viscusi. --- [EMAIL PROTECTED] wrote: > Dear Ravi > DBA 101 book - BY Gaja and kirti is available in India (indian > edition). I > already have one. Excelent book!! > > Regards, > Ramesh D Papnoi > Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India > (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer) > http://www22.Brinkster.com/rpapnoi > > -- Original Text -- > > To: internet["Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]>] > > Dear Rachel, > > Thanks for your reply and guidance. Also thanks to > Kirti Deshpande and Jenny Jacobson for their replies. > In India Oracle DBA 101 book is not yet released. > Once it is released I will defently purchase the book. > > > Regarding Question No.1, I told that Server Process is > the background process and sysauth or objauth view is > used to check for username and password. The > employer told me that I am wrong. Could you pl > clarify. > > > 1) When you enter 'sqlplus scott/tiger' which > background process checks for authentication ? From > which table/view it checks for authentication ? If > password is wrong from where oracle throws the msg ? > > Regards. > Dharan. > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dharani Ravi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Internet Directory
Hi Friend : Does anyone use Oracle Internet Directory ? How does it work ? What is the password and the user that need I to use to connect with the utility oidmon ? Why is it used ? For to build hierarquical structure ? Just it ? Regards Eriovaldo _ O MSN Photos é o jeito mais fácil de compartilhar e imprimir as suas fotos: http://photos.msn.com.br/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - DBA interview questions I faced
and eventually, when they realize they can't find that omniscient person, they come back to reality --- Robert Chin <[EMAIL PROTECTED]> wrote: > > I liked the interviews where they told me about their project, and > > I told them how I could contribute - strengths and weaknesses. > > I'm great at *. I don't know much about YYY, but I'm willing > to > > learn..We cannot know everything. > > That worked in the "good old days" (pre-2001), not any more, not by a > long shot > These days one is expected to be EXPERT of everything the employers > list > explicitly and implicitly (which seems to be getting longer...) plus > this and > that > > Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL > Server ? > Sybase ? > MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps > ? > SAP? Essbase ? Cognos ? Informatica ? > > That's what's so freaky and hedious the job market for hands-on > techies is. > You ARE expected to know everything ! > > Robert Chin > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:database administration questions
With your current background, your more likely to land a job as a network administrator LONG before you'll end up in a database position. Access is still looked on as a single user system and frankly I haven't run into any large scale applications that use it, period. One of my current tasks is working with a forecasting package that states in the manual that Access should only be used for the demos. Any other application of the package should use Oracle or DB2. Also a SPC (Statistical Process Control, for those who don't know, don't ask further) package we're evaluating (actually two of them) won't work with Access even for the demos. Therefore, I'd suggest staying with the networking world. It will be around as long as database administration, if not longer. Your already trained and certified, and getting a Cisco certification is no small feat. If you really want to move into database admin, your probably looking at 2 to 3 years of learning and smaller paychecks as you pay your dues. BTW: A database restore usually takes a lot longer than fixing a network outage, to boot. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 12/23/2001 11:15 PM Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions & I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to learn? 10) Are there any associations or other groups that you belong to as a DBA? 11) What kinds of companies hire DBAs? 12) What companies do you recommed to work for? Know of any currently hiring? 13) With my background, what is the best way to advance and work my way into a real DBA position? Thank you, whom ever reads this and answers back with at least some answers to some of the questions. I really appreciate your help!!! Please, respond to me at [EMAIL PROTECTED] smiles, me thank you! Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions & I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to learn? 10) Are there any associations or other groups that you belong to as a DBA? 11) What kinds of companies hire DBAs? 12) What companies do you recommed to work for? Know of any currently hiring? 13) With my background, what is the best way to advance and work my way into a real DBA position? Thank you, whom ever reads this and answers back with at least some answers to some of the questions. I really appreciate your help!!! Please, respond to me at [EMAIL PROTECTED] smiles, me thank you! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Oracle Client Installation.
You can create a Universal Installer response file which will automate the client installation. You can mount the CD on a network device, or just copy it to a disk on a server so that you don't have to walk the CD to each PC. e.g. setup.exe -responsefile "l:\apps\oracle\816\User_Cdrive.rsp" Search around on the CD for the sample files. The active lines in our response file are: FROM_LOCATION="g:\installs\oracle\816client\STAGE\PRODUCTS.JAR" ORACLE_HOME="C:\Oracle\Ora816" ORACLE_HOME_NAME="Oracle_816" TOPLEVEL_COMPONENT={"oracle.client","8.1.6.0.0"} SHOW_SPLASH_SCREEN=true SHOW_WELCOME_PAGE=false SHOW_COMPONENT_LOCATIONS_PAGE=false SHOW_CUSTOM_TREE_PAGE=true SHOW_SUMMARY_PAGE=false SHOW_INSTALL_PROGRESS_PAGE=true SHOW_REQUIRED_CONFIG_TOOL_PAGE=true SHOW_OPTIONAL_CONFIG_TOOL_PAGE=false SHOW_RELEASE_NOTES=false SHOW_END_SESSION_PAGE=true SHOW_EXIT_CONFIRMATION=false NEXT_SESSION=false NEXT_SESSION_ON_FAIL=false [oracle.client_8.1.6.0.0] COMPONENT_LANGUAGES={"en"} INSTALL_TYPE="Custom" DEPENDENCY_LIST={ "oracle.networking.netclt","8.1.6.0.0","oracle.utilities","8.1.6.0.0","oracle.networking.netcltprod","8.1.6.0.0" } [oracle.utilities_8.1.6.0.0] DEPENDENCY_LIST={ "oracle.rdbms.sqlplus","8.1.6.0.0" } [oracle.p2k_8.1.6.0.0] DEPENDENCY_LIST={ "oracle.p2k.devtools" } [oracle.p2k.devtools_8.1.6.0.0] DEPENDENCY_LIST={ "oracle.p2k.oo4o","8.1.6.3.6" } [oracle.networking.netca_8.1.6.0.0] OPTIONAL_CONFIG_TOOLS={} Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 12/26/01 05:05AM >>> Hi, I develop applications with Delphi 5 Client/Server suit. I used Oracle Database. (with BDE connection) I have a problem with client side. To run my program on some client machine , I install oracle client for this machine. Is there any way to run my program on client without installing oracle client. BECAUSE , when client number increase , my job become difficult , every time I take oracle client CD and install one machine then install other machine ...( I do not give oracle cd to clients beacause client do not know configuration) is there simple way to make setup disk with including my application file plus oracle client files to install client side ? I hope you will understand my question. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Trigger
Try this... Create or replace trigger cre_PK before insert on tableA for each row SELECT seq.nextval INTO :new.col1 FROM dual; end __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
* Oracle DBA /System Administrator Needed in Huntsville, AL..
Position: Oracle DBA / System Administrator-NT Required Location: Huntsville, Alabama Salary Range: 55-75K (includes bonus) Description: This manufacturing company in Huntsville needs an Oracle DBA/System Administrator to provide hardware and support support in an NT/Oracle/SAP environment. MUST have Oracle, NT and SAP (or some other ERP software) experience...though SAP is preferred. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. -System Administrator Responsibilities will include: Participates in the analysis, configuration and installation of hardware products as part of IS. Supports and maintain department servers to ensure the highest availability and optimum performance possible. Maintains software installed on departmental servers to ensure the latest available version is installed as required. Supports client groups with on-going systems configurations and maintenance of hardware and operating systems. Directs projects of moderate scope. Provides technical leadership and application expertise to project teams. -DBA Responsibilities will include: Setup maintain and generally administer the SAP R/3 Oracle Database Be certain NT server's data are backed up; be certain hot patches are current to within a certain number Keep the Oracle database version current Documentation of all major technical system operations. Requirements: *Bachelor's degree in computer science or related field is highly desired. *Four or more years of related experiece as required above. *Strong analytical and problem solving skills. *Excellent communications skills * Must be a U.S. citizen or perm. resident. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Doug/Hunstville/DBA-Sysadmin/Liz I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: online backup help
Have a look at rman. It allows online backups of databases if they are in archivelog mode. If you don't want to put your databases in archivelog mode then rman can only backup them up when they are in mount state and inavailable to users. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 24, 2001 3:35 AM Dear All, We are in the planning/testing stage right now. I wanted to know if it is possible to backup the Oracle database online, i.e. at the time Oracle database is running. This is also called hot backup. If yes, do I have to install the backup tape device to the same server where the Oracle is installed? Or can I install tape drive to any other server and from there also can I take online/hot backup of the oracle database? Regards Jain Anand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand Jain INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
XP vs. W2000
This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone have any experience with XP Prof.? Pluses / minuses? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database administration questions
If you work on a site like I do you could always cross train. I am always looking for suckers (um, people) to be my backup. Right now I use one from the Unix team and one from the development team. Its the only way I get to take vacations and what no. Check with your current DBA and see if they are willing to train you while you are off doing your 'real' job. Of course, there are some folks who are worried about job security (or are just assholes) and they would not give you the time of day. You don't want to learn from those folks anyway. The excuse, "I'm too busy" is not really valid either. Training someone allowed me to offload some of my work. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, December 26, 2001 5:30 AM To: Multiple recipients of list ORACLE-L With your current background, your more likely to land a job as a network administrator LONG before you'll end up in a database position. Access is still looked on as a single user system and frankly I haven't run into any large scale applications that use it, period. One of my current tasks is working with a forecasting package that states in the manual that Access should only be used for the demos. Any other application of the package should use Oracle or DB2. Also a SPC (Statistical Process Control, for those who don't know, don't ask further) package we're evaluating (actually two of them) won't work with Access even for the demos. Therefore, I'd suggest staying with the networking world. It will be around as long as database administration, if not longer. Your already trained and certified, and getting a Cisco certification is no small feat. If you really want to move into database admin, your probably looking at 2 to 3 years of learning and smaller paychecks as you pay your dues. BTW: A database restore usually takes a lot longer than fixing a network outage, to boot. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 12/23/2001 11:15 PM Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions & I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to learn? 10) Are there any associations or other groups that you belong to as a DBA? 11) What kinds of companies hire DBAs? 12) What companies do you recommed to work for? Know of any currently hiring? 13) With my background, what is the best way to advance and work my way into a real DBA position? Thank you, whom ever reads this and answers back with at least some answers to some of the questions. I really appreciate your help!!! Please, respond to me at [EMAIL PROTECTED] smiles, me thank you! Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions & I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study? 8) Is it worth it to get a degree? If so, what specific one? 9) Are there any other programs or technologies that are valuable to
Re: XP vs. W2000
Forget it. Get Suse 7.2 or 7.3, or the latest version of RedHat. If you want to run Windoze too, get VmWare or Win4Lin. Win4Lin works with win95/98. Vmware is more flexible and will work with Win2k. I've found Win98 with Win4Lin to be more stable than Win98 by itself. Jared Ken Janusz fsys.com>cc: Sent by: Subject: XP vs. W2000 [EMAIL PROTECTED] om 12/26/01 07:50 AM Please respond to ORACLE-L This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone have any experience with XP Prof.? Pluses / minuses? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: XP vs. W2000
> > Forget it. > Get Suse 7.2 or 7.3, or the latest version of RedHat. Yeah, LINUX is great but get ready to pull (some of) your hair out installing Oracle. God help you. (or find a LINUX guru and pay him to do it) Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XP vs. W2000
How dogmatic of you Jared! Are you suffering windoze xenophobia? On my laptop I've got VMWare with Win2k and RedHat. I confess with shame that win2k is my primary O/S and that I need windoze for MS Outlook. Also, I'm addicted to MS Office. Addiction as in dependence on unhealthy things. Sigh... I'm not Luke Skywalker... I've succombed to the dark side. Steve Orr -Original Message- Sent: Wednesday, December 26, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Forget it. Get Suse 7.2 or 7.3, or the latest version of RedHat. If you want to run Windoze too, get VmWare or Win4Lin. Win4Lin works with win95/98. Vmware is more flexible and will work with Win2k. I've found Win98 with Win4Lin to be more stable than Win98 by itself. Jared Ken Janusz To: Multiple recipients of list ORACLE- This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone have any experience with XP Prof.? Pluses / minuses? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What's Oracle Trying to Hide ???
Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to "obscure" the dbms_system package but I can't find the prvtutil.sql script. Where is this stuff and why do they want to hide it? Any ideas? ...Just found the ./rdbms/admin/prvtutil.plb file and now I'm wishing I could un-"wrap" this "present" on boxing day! Eschew Obfuscation, Steve Orr Skiing Bridger Bowl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: XP vs. W2000
I agree with Jared. Even though I posted a response pointing to a website that discusses some of the pros/cons of XP and W2K, Linux is my first choice and I love it (and will love it more once I get SuSE 7.2 to work with my NVidia card so I can install Oracle again). -D- On Wednesday 26 December 2001 12:45 pm, [EMAIL PROTECTED] wrote: > Forget it. > > Get Suse 7.2 or 7.3, or the latest version of RedHat. > > If you want to run Windoze too, get VmWare or Win4Lin. > > Win4Lin works with win95/98. > > Vmware is more flexible and will work with Win2k. > > I've found Win98 with Win4Lin to be more stable > than Win98 by itself. > > Jared > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XP vs. W2000
It's really not that difficult. You do HAVE TO READ the readme's and the info on Metalink first. There are some things that need to be done to install on RedHat. These are fairly well documented on Metalink. The installation is not a point-click-and forget type install. Once all the stuff listed in the doc's and on Metalink is done the install works well. > -Original Message- > From: Robert Chin [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 26, 2001 1:25 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: XP vs. W2000 > > > > > > Forget it. > > Get Suse 7.2 or 7.3, or the latest version of RedHat. > > Yeah, LINUX is great but get ready to pull (some of) your hair > out installing Oracle. God help you. (or find a LINUX guru > and pay him to do it) > > Robert Chin > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robert Chin > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Holman, Rodney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: XP vs. W2000
Robert, you're a DBA, and you still have hair? ;) Jared ( hasn't pulled it *all* out, yet ) Robert Chin line.net>cc: Sent by: Subject: Re: XP vs. W2000 [EMAIL PROTECTED] om 12/26/01 11:25 AM Please respond to ORACLE-L > > Forget it. > Get Suse 7.2 or 7.3, or the latest version of RedHat. Yeah, LINUX is great but get ready to pull (some of) your hair out installing Oracle. God help you. (or find a LINUX guru and pay him to do it) Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Odd SQL Loader Problem
I am loading data into an Oracle table (8.1.7 on W2000 server). I am skipping fields (via filler) because I don't need to load them. However, I am getting an error on one of the input fields (being skipped) - field in data file exceeds maximum length. The record is a tilde "~" delimited flat file. The field that is giving me the error is a lengthy character field - a bunch of English verbiage. There are no tildes in this lengthy string of characters. So, why would SQL Loader give me an error on a field I do not wish to load? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Odd SQL Loader Problem
Could you have a special character like cr or nl that is causing this problem or indicating the end of record before reading all fields? -Original Message- Sent: Wednesday, December 26, 2001 3:45 PM To: Multiple recipients of list ORACLE-L I am loading data into an Oracle table (8.1.7 on W2000 server). I am skipping fields (via filler) because I don't need to load them. However, I am getting an error on one of the input fields (being skipped) - field in data file exceeds maximum length. The record is a tilde "~" delimited flat file. The field that is giving me the error is a lengthy character field - a bunch of English verbiage. There are no tildes in this lengthy string of characters. So, why would SQL Loader give me an error on a field I do not wish to load? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move DB to Another Schema
Hi Stephane, >I agree with you for a full export, and (I have just checked) a > OWNER=SYS export exports everything but tables. But there is no such > limitation with a TABLES= export : Thanks for the inputs. Guess this is something new 7.x plus since I think that was true before. Guess there are lots more such 'gotchas' and new 'features' that slip in with every new version! John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Odd SQL Loader Problem
Could be, but how do I read it? Ken -Original Message- Sent: Wednesday, December 26, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Subject:RE: Odd SQL Loader Problem Could you have a special character like cr or nl that is causing this problem or indicating the end of record before reading all fields? -Original Message- Sent: Wednesday, December 26, 2001 3:45 PM To: Multiple recipients of list ORACLE-L I am loading data into an Oracle table (8.1.7 on W2000 server). I am skipping fields (via filler) because I don't need to load them. However, I am getting an error on one of the input fields (being skipped) - field in data file exceeds maximum length. The record is a tilde "~" delimited flat file. The field that is giving me the error is a lengthy character field - a bunch of English verbiage. There are no tildes in this lengthy string of characters. So, why would SQL Loader give me an error on a field I do not wish to load? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XP vs. W2000
It's dogma only when there are reasonable alternatives. ;) Jared 'just the facts' Still "Orr, Steve" .com>cc: Sent by: Subject: RE: XP vs. W2000 [EMAIL PROTECTED] om 12/26/01 11:45 AM Please respond to ORACLE-L How dogmatic of you Jared! Are you suffering windoze xenophobia? On my laptop I've got VMWare with Win2k and RedHat. I confess with shame that win2k is my primary O/S and that I need windoze for MS Outlook. Also, I'm addicted to MS Office. Addiction as in dependence on unhealthy things. Sigh... I'm not Luke Skywalker... I've succombed to the dark side. Steve Orr -Original Message- Sent: Wednesday, December 26, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Forget it. Get Suse 7.2 or 7.3, or the latest version of RedHat. If you want to run Windoze too, get VmWare or Win4Lin. Win4Lin works with win95/98. Vmware is more flexible and will work with Win2k. I've found Win98 with Win4Lin to be more stable than Win98 by itself. Jared Ken Janusz To: Multiple recipients of list ORACLE- This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone have any experience with XP Prof.? Pluses / minuses? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What's Oracle Trying to Hide ???
I suspect that they are trying to prevent headaches by hiding 'features' that are intended for internal use only. Sometimes a "DBA" will get hold of some undocumented feature and use it just because it's there, sometimes causing database problems in the process. This type of behavior is common in the PC world. Just take a look at PC magazine and Windoze websites and you will find all kinds of "tips" and "tricks" that add no value to the system and usually eat up resources. It seems that this mentality carries over from the Windoze world to those that are new with Oracle, and the "DBA" starts twisting and turning every knob available. Kind of messes things up for times when one of those undoc features might be useful. This may be pure speculation on my part , but it's my story, and I'm sticking to it. Jared "Orr, Steve" .com>cc: Sent by: Subject: What's Oracle Trying to Hide ??? [EMAIL PROTECTED] om 12/26/01 11:30 AM Please respond to ORACLE-L Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to "obscure" the dbms_system package but I can't find the prvtutil.sql script. Where is this stuff and why do they want to hide it? Any ideas? ...Just found the ./rdbms/admin/prvtutil.plb file and now I'm wishing I could un-"wrap" this "present" on boxing day! Eschew Obfuscation, Steve Orr Skiing Bridger Bowl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XP vs. W2000
Oh C'mon... Don't you consider numerous daily reboots as "reasonable alternatives?" I understand that if you use XP and the Internet your system is wide open to intrusion... so it turns out that MS is an "open systems" software company. :-) Steve -Original Message- Sent: Wednesday, December 26, 2001 3:10 PM To: [EMAIL PROTECTED] Cc: Orr, Steve It's dogma only when there are reasonable alternatives. ;) Jared 'just the facts' Still -Original Message- http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What's Oracle Trying to Hide ???
I generally share your "speculation" but in the case of dbms_system it is referenced by other sources yet it is undocumented. If you can do a describe on it from SQL*Plus then it should be documented. So dbms_system is undocumented and incomplete but available for our use?? In dbms_system there's a procedure called "set_ev" with 5 parameters. I'm thinking this is to set events like 10046 and that the "si" parm is for SID, the "se" parm is for serial#, the "ev" parm is the event number, the "le" parm is the level. But what would the "nm" parm be and how would it be used? Curiosity may have killed the cat but with sensitive whiskers we should be able to poke our noses into certain places without incident. Here's to growing longer whiskers, Steve -Original Message- Sent: Wednesday, December 26, 2001 3:15 PM To: Multiple recipients of list ORACLE-L I suspect that they are trying to prevent headaches by hiding 'features' that are intended for internal use only. Sometimes a "DBA" will get hold of some undocumented feature and use it just because it's there, sometimes causing database problems in the process. This type of behavior is common in the PC world. Just take a look at PC magazine and Windoze websites and you will find all kinds of "tips" and "tricks" that add no value to the system and usually eat up resources. It seems that this mentality carries over from the Windoze world to those that are new with Oracle, and the "DBA" starts twisting and turning every knob available. Kind of messes things up for times when one of those undoc features might be useful. This may be pure speculation on my part , but it's my story, and I'm sticking to it. Jared -Original Message- Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to "obscure" the dbms_system package but I can't find the prvtutil.sql script. Where is this stuff and why do they want to hide it? Any ideas? ...Just found the ./rdbms/admin/prvtutil.plb file and now I'm wishing I could un-"wrap" this "present" on boxing day! Eschew Obfuscation, Steve Orr Skiing Bridger Bowl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What's Oracle Trying to Hide ???
Title: RE: What's Oracle Trying to Hide ??? because the list is so slow today, I'll add my response to it... I agree with Jared... but have one other thing to mention. Working for a company that continually delves into the internal structures and workings of Oracle I learned to respect how it works, and what it does. Internally oracle does some pretty strange things with it's transactions (when you apply DDL, what happens to the underlying $ and # tables), and especially on how it stores different objects in the database (like Nested tables and IOT's.) Understanding these new objects and they way that they work within oracle... is very strange... and I'm not sure if it is all implemented with performance/ease of use in mind. Now don't get me wrong... I love Oracle... but if we ALL really knew how things worked internally... I think people would not be so ready to use the new functionality. I think one of the reasons they 'hide' and wrap these procedures is so we don't know how it works, and makes it more 'magical.' And yes... undoc'd procedures are useful... and fun too! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 2:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: What's Oracle Trying to Hide ??? I suspect that they are trying to prevent headaches by hiding 'features' that are intended for internal use only. Sometimes a "DBA" will get hold of some undocumented feature and use it just because it's there, sometimes causing database problems in the process. This type of behavior is common in the PC world. Just take a look at PC magazine and Windoze websites and you will find all kinds of "tips" and "tricks" that add no value to the system and usually eat up resources. It seems that this mentality carries over from the Windoze world to those that are new with Oracle, and the "DBA" starts twisting and turning every knob available. Kind of messes things up for times when one of those undoc features might be useful. This may be pure speculation on my part , but it's my story, and I'm sticking to it. Jared "Orr, Steve" .com> cc: Sent by: Subject: What's Oracle Trying to Hide ??? [EMAIL PROTECTED] om 12/26/01 11:30 AM Please respond to ORACLE-L Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to "obscure" the dbms_system package but I can't find the prvtutil.sql script. Where is this stuff and why do they want to hide it? Any ideas? ...Just found the ./rdbms/admin/prvtutil.plb file and now I'm wishing I could un-"wrap" this "present" on boxing day! Eschew Obfuscation, Steve Orr Skiing Bridger Bowl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other informatio
RE: XP vs. W2000
>This question is a little off the mark. I will be ordering a new Dell PC >(8200) in the near future. I would like to know which OS I should go with. >XP Professional or W2000? Any suggestions? Anyone have any experience >with XP Prof.? Pluses / minuses? > If you need to run windows, I'd use Win2K. Check this article out about the FBI getting involved With the security problems with WinXP http://news.cnet.com/news/0-1003-200-8287567.html In addition, Someone in our office recently got a brand new laptop with XP on it and he absolutely hates the performance it gets with XP(Slow Slow Slow). I use redhat 7.2 here at the office and at home and love it(Came over from Slackware) -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian Haas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What's Oracle Trying to Hide ???
Steve, "nm" parameter is used as event name. i.e what to do if that triggering event occurs. You can set either SYSTEMSTATE or PROCESSSTATE or ERRORSTACK to dump those things. Consider a case , you want to dump the errorstack when ORA-00060 (deadlock) occurs. Here you use SID,SERIAL#,60,65535,ERRORSTACK. Triggering event 65535 is IMMEDIATE . Hope this helps. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Wednesday, December 26, 2001 3:10 PM To: Multiple recipients of list ORACLE-L I generally share your "speculation" but in the case of dbms_system it is referenced by other sources yet it is undocumented. If you can do a describe on it from SQL*Plus then it should be documented. So dbms_system is undocumented and incomplete but available for our use?? In dbms_system there's a procedure called "set_ev" with 5 parameters. I'm thinking this is to set events like 10046 and that the "si" parm is for SID, the "se" parm is for serial#, the "ev" parm is the event number, the "le" parm is the level. But what would the "nm" parm be and how would it be used? Curiosity may have killed the cat but with sensitive whiskers we should be able to poke our noses into certain places without incident. Here's to growing longer whiskers, Steve -Original Message- Sent: Wednesday, December 26, 2001 3:15 PM To: Multiple recipients of list ORACLE-L I suspect that they are trying to prevent headaches by hiding 'features' that are intended for internal use only. Sometimes a "DBA" will get hold of some undocumented feature and use it just because it's there, sometimes causing database problems in the process. This type of behavior is common in the PC world. Just take a look at PC magazine and Windoze websites and you will find all kinds of "tips" and "tricks" that add no value to the system and usually eat up resources. It seems that this mentality carries over from the Windoze world to those that are new with Oracle, and the "DBA" starts twisting and turning every knob available. Kind of messes things up for times when one of those undoc features might be useful. This may be pure speculation on my part , but it's my story, and I'm sticking to it. Jared -Original Message- Here's a paste from the $ORACLE_HOME/rdbms/admin/dbmsutil.sql script: Rem dbms_system - database system level commands (moved to Rem prvtutil.sql for more obscurity) Not only do they want to "obscure" the dbms_system package but I can't find the prvtutil.sql script. Where is this stuff and why do they want to hide it? Any ideas? ...Just found the ./rdbms/admin/prvtutil.plb file and now I'm wishing I could un-"wrap" this "present" on boxing day! Eschew Obfuscation, Steve Orr Skiing Bridger Bowl -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database administration questions
I quite agree with Kimberly. I used to be a full-fledge Oracle programmer but wanted to dabble with database administration. I asked my boss whether I could be a database administrator. His answer is yes but I still need to maintain my current systems. Now, I am a database administrator-cum-programmer. I support turnkey projects, automate processes for my users, maintain current projects, install/maintain database & support Oracle Applications etc. Prepare for lots of OT but what the heck, U will get to learn a lots of interesting things in the process New Bees -Original Message- From: Kimberly Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 1:40 AM To: Multiple recipients of list ORACLE-L Subject:RE: database administration questions If you work on a site like I do you could always cross train. I am always looking for suckers (um, people) to be my backup. Right now I use one from the Unix team and one from the development team. Its the only way I get to take vacations and what no. Check with your current DBA and see if they are willing to train you while you are off doing your 'real' job. Of course, there are some folks who are worried about job security (or are just assholes) and they would not give you the time of day. You don't want to learn from those folks anyway. The excuse, "I'm too busy" is not really valid either. Training someone allowed me to offload some of my work. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, December 26, 2001 5:30 AM To: Multiple recipients of list ORACLE-L With your current background, your more likely to land a job as a network administrator LONG before you'll end up in a database position. Access is still looked on as a single user system and frankly I haven't run into any large scale applications that use it, period. One of my current tasks is working with a forecasting package that states in the manual that Access should only be used for the demos. Any other application of the package should use Oracle or DB2. Also a SPC (Statistical Process Control, for those who don't know, don't ask further) package we're evaluating (actually two of them) won't work with Access even for the demos. Therefore, I'd suggest staying with the networking world. It will be around as long as database administration, if not longer. Your already trained and certified, and getting a Cisco certification is no small feat. If you really want to move into database admin, your probably looking at 2 to 3 years of learning and smaller paychecks as you pay your dues. BTW: A database restore usually takes a lot longer than fixing a network outage, to boot. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 12/23/2001 11:15 PM Hi! I'm looking into getting into the field of Database Administrating. Right now, I have experience with MS Access and have created several databases for companies that I have worked with in the past with Access. I'm looking for a jump in my career and the next logical step for me, I would think, would be in database field. However, I also have some networking knowledge (Cisco certified...). So, I'm looking into the advantages of both fields. I have some questions & I'm not sure who to ask or where to get my answers. But, here they go: Questions for a Database Administrator: 1) What is your typical workday like? 2) Do you work a lot of overtime? 3) What are the most valuable databse programs to learn? 4) If I was to look into learning these, should I take classes? Where would you recommend I look for classes in the Los Angeles area? 5) What language, if any, are important (Java, XML, Visual Basic, etc.)? 6) What programs are starting to get obsolete? 7) Is it worth it to get vendor certifications (Microsoft, Oracle)? If so, are there certain books that you recommend to study?
RE: XP vs. W2000
As we are treading towards OT land, I've got a Dell PIII 750 with 512MB on my desktop running WIN2K Pro. I just bought a laptop, Compaq Presario PIII 1.0 Gig Chip with 512MB running XP Pro. I run 8i and 9i on both machines. The laptop is definitely snappier when running OEM 9i. With comparably configured laptops and desktops, you would expect the desktop to be much faster. So, even though my laptop has a 1 Ghz chip vs the 750 Mhz chip on my desktop, I expected the laptop to be slower. And it is when running disk intensive operations -- 4500 RPM on the laptop vs 7200 RPM and a caching controller on the desktop. But otherwise, the laptop with XP seems to be a tad faster, and maybe it's strictly due to the faster processor. It would be interesting to run some benchmarks against the same machine running XP vs. WIN2K -- I'm sure PC Magazine or some other group has already done this. And I haven't been on the Internet with the laptop since the XP security issues came to light. Something I need to address on the laptop. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian Haas > Sent: Wednesday, December 26, 2001 5:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: XP vs. W2000 > > > >This question is a little off the mark. I will be ordering a new Dell PC > >(8200) in the near future. I would like to know which OS I > should go with. > >XP Professional or W2000? Any suggestions? Anyone have any experience > >with XP Prof.? Pluses / minuses? > > > > If you need to run windows, I'd use Win2K. Check this article out about > the FBI getting involved With the security problems with WinXP > > http://news.cnet.com/news/0-1003-200-8287567.html > > In addition, Someone in our office recently got a brand new > laptop with XP > on it and he absolutely hates the performance it gets with XP(Slow Slow > Slow). > > I use redhat 7.2 here at the office and at home and love it(Came > over from > Slackware) > > -Brian > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brian Haas > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: XP vs. W2000
Nah, I'm no DBA, just a %X*$@?! developer that gets a secret joy out of watching DBAs pulling their hair out.(or chewing off their nails...) Robert Chin - Original Message - > Robert, you're a DBA, and you still have hair? ;) > > Jared ( hasn't pulled it *all* out, yet ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
weird pga swelling
I'm experiencing a weird issue I've never encountered before. One of my clients runs a moderately active database being connected to by a group of webservers running mod_perl, making a 'standard' set of queries to generate dynamic content. 'standard' in this sense means that the queries are unchanged for many months, none of them are particularly expensive. Randomly (once/twice week) I'm having shadow processes (LOCAL=NO sessions) whose PGA is welling to huge sizes. I am measuring this with pmem. I see things like: 3606: oracleFLPDT (LOCAL=NO) Address Kbytes Resident Shared Private Permissions Mapped File 0001 24776 19960 19960 - read/exec oracle 0185 240 240 208 32 read/write/exec oracle 0188C000 1083848 946408 - 946408 read/write/exec[ heap ] 8000 1143448 1143448 1143448 - read/write/exec/shared [shmid=0x2db5] That's 1G of private heap usage by that one process. These sessions are not stuck running any particular sql, I have caught them executing any and all of the standard application code and they don't seem to be spinning on any particular query. Any thoughts? This seems like a PGA memory leak to me. // George Schlossnagle // www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN // Smarter than adding another team member, Pythian has new services // for supplementing DBAs: get our help with monitoring, 24x7 on-call, // daily verifications, storage management, performance and more.
RE: XP vs. W2000
I neither pull my hair or chew my nails. I find other ways to relieve my stress. Course, the folks at work are not to happy about it. Well, at least when the plant was open. There are very few activities I do that are not considered 'risky'. DBA work is relatively stress free for me I will take a downed database any day to a lead fall. At one time they we were coming up on a really big downtime that took months to plan and they were trying to get me to stay off the mountains. HA! -Original Message- Sent: Wednesday, December 26, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Nah, I'm no DBA, just a %X*$@?! developer that gets a secret joy out of watching DBAs pulling their hair out.(or chewing off their nails...) Robert Chin - Original Message - > Robert, you're a DBA, and you still have hair? ;) > > Jared ( hasn't pulled it *all* out, yet ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help - DBA interview questions I faced
Rachel, I'm Sorry for quoting wrong book. Actually I have both books and both are excellent! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet["Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>] dba 101 is not by gaja and kirti -- that's performance tuning 101 which is indeed an excellent book dba 101 is theriault, carmichael and viscusi. --- [EMAIL PROTECTED] wrote: > Dear Ravi > DBA 101 book - BY Gaja and kirti is available in India (indian > edition). I > already have one. Excelent book!! > > Regards, > Ramesh D Papnoi > Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India > (BrainBench & Brainbuzz Certified Oracle 8/8i DBA & Developer) > http://www22.Brinkster.com/rpapnoi > > -- Original Text -- > > To: internet["Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]>] > > Dear Rachel, > > Thanks for your reply and guidance. Also thanks to > Kirti Deshpande and Jenny Jacobson for their replies. > In India Oracle DBA 101 book is not yet released. > Once it is released I will defently purchase the book. > > > Regarding Question No.1, I told that Server Process is > the background process and sysauth or objauth view is > used to check for username and password. The > employer told me that I am wrong. Could you pl > clarify. > > > 1) When you enter 'sqlplus scott/tiger' which > background process checks for authentication ? From > which table/view it checks for authentication ? If > password is wrong from where oracle throws the msg ? > > Regards. > Dharan. > > > > __ > Do You Yahoo!? > Send your FREE holiday greetings online! > http://greetings.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dharani Ravi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: XP vs. W2000
Title: RE: XP vs. W2000 So, Jared, I have heard of VmWare which is not as far as I know Open Source(Free). I don't know of Win4Lin, is it Open Source? and won't you email me a link to the site. Regards Denham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 7:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: XP vs. W2000 Forget it. Get Suse 7.2 or 7.3, or the latest version of RedHat. If you want to run Windoze too, get VmWare or Win4Lin. Win4Lin works with win95/98. Vmware is more flexible and will work with Win2k. I've found Win98 with Win4Lin to be more stable than Win98 by itself. Jared Ken Janusz fsys.com> cc: Sent by: Subject: XP vs. W2000 [EMAIL PROTECTED] om 12/26/01 07:50 AM Please respond to ORACLE-L This question is a little off the mark. I will be ordering a new Dell PC (8200) in the near future. I would like to know which OS I should go with. XP Professional or W2000? Any suggestions? Anyone have any experience with XP Prof.? Pluses / minuses? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com