RE: 2 Databases Problem
Hi , if I'm not wrong, it's because there is another instance use the same db name. check ur initSID.ora regards -Original Message- Setiawan Sent: Wednesday, March 28, 2001 2:45 PM To: Multiple recipients of list ORACLE-L Dear Listers , yesterday , I've created 2nd database for Test using Database Assistant on NT. and I also shutdown my Test Server later. this morning , when I tried to Startup both of My DB , I found ORA-01102 error :can not mount database exclusively. My 1st database is able to be started in OPEN mode , but I can not startup my 2nd database . please help me , how to solve it... Thanks a lot in advance : ) =bambang= Bambang Setiawan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bambang Setiawan 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: herman 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).
'Event Group Latch'
Tom Kyte (asktom.oracle.com) kindly posted me a reply to my question on the above latch. For anyone interested, the description is below Cheers Connor -- START QUOTE Event Group Latch Usage This latch is used during the following operations : An "alter system set events.." command. During process startup where the process copies the events stored in the System event group to its Process event group. Event Groups Events are considered to exist in either the process, session or system group. The differences are outlined below : System Group The event tree is built in the SGA and is derived from the settings of the instance parameter "event". It can also be modified by using the command "alter system set events...". Process Group These are initialised at process startup time via the instance parameter "event". When the process starts up we copy the event tree that we have stored in the System Group. The event tree is built in the PGA. Session Group These are events that are modified dynamically via the "alter session" command. When we perform event checking we check the session group events before those of the process group. The event tree is built in the UGA. -- END QUOTE = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Issues with Oracle on a Compaq Tru64 5.1 Cluster
Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -Original Message- Sent: 27 March 2001 22:43 To: Multiple recipients of list ORACLE-L We use COMPAQ tru64 5.1 with Oracle 8.1.7. we had noticed corruption in some all files and had to apply some O/S level patches. We followed the instructions in the following TAR# 13320267.600. You may want to do a dbv on certain files to ensure there is not corruption. Again we did not notice these problems until RMAN complained of corruption. And we noticed corruption in the redo logs. Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 27 Mar 2001 08:47:20 -0800 We are running Oracle 8.1.6.2.0 on a new Compaq Tru64 cluster running 5.1 patchkit 1. We have had Oracle running for almost 2 months. For the last several days, we have been experiencing severe I/O issues. The databases will freeze-up and claim that they can't access certain files. Occassionally even 'ls' commands will lock up to, but only when accessing certain sub-directories of file systems. Naturally, we are trying to figure out what has changed in the last few days. We know that the Legatto Networker client was installed, and we also had a UPS failure. In an attempt to isolate the problem, we have removed the Legatto Networker client. Our sysadmins are not seeing any problems at the hardware level. We have completed powered the cluster down and brought it back up. When the databases begin locking up, we do see error messages related to various file systems come across the console. For a few days, we thought it might be RMAN, but I haven't used it in the last 2 days and the problems are still occurring. So, my question is - are any of you folks on a Tru64 5.1 cluster and if so, have you seen similar problems? The systems include 3 GS80s, an ES40, and a Storage Area Network for the disks. We are not running OPS and we are not using raw devices. Thank you, Jay Hostetter -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: lerobe - Lee Robertson 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: changing db_block_size
I have read the same : different blocksizes per tablespaces in Oracle 9i. --- Rachel Carmichael [EMAIL PROTECTED] a crit: no flame supposedly in 9i you will be able to change the block size while the db is up and will also be able to have different blocksizes -- I think it's by tablespace From: "Joseph S. Testa" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: changing db_block_size Date: Tue, 27 Mar 2001 16:50:56 -0800 last i checked that was your only choice, anyone like to flame me for that statement :) joe Roy Ferguson wrote: all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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 variables; LD_LIBRARY_PATH TNS_ADMIN
Hello, I need some clarification. What is the significance of the Oracle variables, TNS_ADMIN LD_LIBRARY_PATH? When are the 2 used or what effects what in the environment? Also please if some one knows how do I monitor an Oracle Parallel Server? Any good book where I can read about OPS? Regards, Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Trying to find a book...
Rocky ! I guess you are talking about his OCP TEst prepration guide. I think it is published by new riders. A quick search on AMAZON.com will give you more detaiils - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 2:45 AM Hi Gang, Anyone know of a book by Willard Baird? I'd like to like to know the title and any thoughts you may have. TIA, Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: Import comma-delimited text file into Oracle
Helmut, I believe that SQL*Loader is the quickest way to load your data. You could write a procedure that uses UTL_FILE also. And there is another choice, but truly brute force - you could edit your file into INSERT statements and load it through SQL*PLUS. :-( Ron Morton Union Switch Signal Inc [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 27, 2001 10:36 PM To: Multiple recipients of list ORACLE-L Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Morton, Ronald D 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: Exp Imp Overwirte posiible or not?
Hi , destroy=y option doesn't meet the requirement . I checked the oracle docs and didn't find any option to overwrite data.I think i have to truncate data and then insert into appropriate tables as william pointed out. Thnaks to every one who responded. Azhar Siddiq, [EMAIL PROTECTED] ms.osd.mil To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: Exp Imp Overwirte posiible or not? 03/28/2001 12:52 AM Please respond to ORACLE-L Thanks for the correction. I'm away from the doc CD at the moment as we are moving offices... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: Exp Imp Overwirte posiible or not? The DESTROY option on an import indicates whether the CREATE TABLESPACE commands only found in a full export should be executed. Setting DESTROY=Y destroys the data files of the database being imported into. This is only used when you want to rebuild an entire database, not to overwrite data in tables. If you really need the empty all the tables in a schema, disable the constraints on the tables, truncate them, and reenable the constraints. This will only work if the schema is self contained, and it's tables are not used as a foreign key for a table in a different schema. [EMAIL PROTECTED] 03/27/01 01:50PM IIRC, there is a flag for import "destroy=y" to do what you want. This is very dangerous and you should research all the implications before trying it. If you don't have the docs, try http://technet.oracle.com and read up on the import options. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 1:46 AM To: Multiple recipients of list ORACLE-L Subject: Exp Imp Overwirte posiible or not? Hi All, I want to import data from a user dump file but when i import data, i want to overwrite the existing data . Normally imp utility append data to existing rows. Requirement of application is such that we need to overwrite existing data without dropping objects and its dependent objects. Is it possible with exp , imp utilities or i have to delete data first and then import using imp utility. Is there any other possibility... Environment Oracle8i, Windows NT4 TIA Azhar Siddiq -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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
Is terminal release of 8.0.x still supported?
We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- 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: New born DBA.....
Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LOB ?
Thank you Winnie. Thats exactly what I was looking for! Gene [EMAIL PROTECTED] 03/27/01 04:42PM I am not quite sure that you can reference a LOB in a remote database through a database link. You are very likely to get the ORA-22992 error when you attempt to do so. 22992, 0, "cannot use LOB locators selected from remote tables" // *Cause: A remote LOB column cannot be referenced. // *Action: Remove references to LOBs in remote tables. Winnie "Gene Sais" [EMAIL PROTECTED]@fatcity.com on 03/27/2001 12:52:13 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: LOB question? Can you have db A have a view w/ db link reference to db B blob data type? I think so, but not 100% sure. The reason I ask is I have a 3rd party app that wants to move 500gb worth of images to a remote db, but have the current db reference it as if it was in the same db through a view. Thanks for any blob insight the list can offer. Gene Sais -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What is best practice - differenet schema/different dbs
Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: changing db_block_size
To change the block size you have to recreate the database. How you are going to copy the data that's another issue. You can use full database export/import (pretty long downtime, or problems with data consistency) or you can do a live copy. More on a live copy you can see in: Venkat S. Devraj, Oracle 24x7 Tips Techniques, Osborne Press, 2000. I am currently working on a similar project (live database migration). I will present some results at IOUG if you are there. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:40 PM all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: djordjej 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: Issues with Oracle on a Compaq Tru64 5.1 Cluster
Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -- 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: Import comma-delimited text file into Oracle
Or you can write a program in (C, Perl, Java, etc) to parse the file and do inserts. Richard -Original Message- Daiminger Sent: Tuesday, March 27, 2001 10:36 PM To: Multiple recipients of list ORACLE-L Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Richard Ji 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: New born DBA.....
Also there is a book by Heidi Thorpe Oracle 8I Tuning and Administration where there is a big chapter about database monitoring. Alex Hillman -Original Message- From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:20 PM To: Multiple recipients of list ORACLE-L Subject:Re: New born DBA. start by reading the administrators guide and welcome to the world(Dr DBA slaps the bottom side of the newborn) :) joe Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
several peoplesoft databases (schemas) in one Oracle database
Can anybody give me pro and con for having let say several Peoplesoft schemas in the same database versus in different databases. Should objects of different schemas be in the same tablespaces or every schema should have it's own set of tablespaces etc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Metalink customer satisfaction surveys
Have any of you received one of those lately? I remember last year they used to check with us to see whether we were happy with the service, but I have received nothing in a long time. Someone soft closed one of my TARs, saying he had sent me the information I requested, but I can't find anything in my e-mail folders re. that TAR. I got the notices telling me the TAR has been updated, but I didn't receive the information the tech says he sent me -- at least I can't find it anywhere. My question was re. how we can secure the OEM, i.e. how to ensure that the OEM the DBAs use will be the only one in use to access our databases. What's to stop a developer or an end user from downloading the OEM for free, then using it to send jobs to the databases using the intelligent agents? Nothing, as far as I can see, if we go with the default configurations. I would very much like to see the guidelines I requested re. securing the OEM... I updated the TAR myself, maybe they will "un-soft-close" it. There is someone from Oracle development group on the ODTUG listserv, I sure wish there was someone from customer support or from the Oracle engineers group on this listserv. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New born DBA.....
Here is a quick list: Daily checks - Oracle Alert file logs - system resources - backups - archive logs - error logs Weekly checks - free space in Tablespaces, Tables, Indexes and Clusters Monthly checks - fragmentation in Tables, Indexes and Clusters Ben Poels Queen's University -Original Message- Xing Sent: Tuesday, March 27, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: RMAN
I put mine right before I do an archivelog backup, which I do at the end of my level 0 and level 1 backups. But if I was not doing an archivelog backup I would not even archive my current log because there would be no reason to do so,. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 9:25 PM Dear DBAs, I found this RMAN command on Oracle8i Backup Recovery documentation. This is used to backup all data files and controlfiles. run { allocate channel ch1 type disk; backup database; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; # archives current redo log sql 'ALTER SYSTEM ARCHIVE LOG ALL'; # archives all un-archived redo logs } My question is, why they put sql commands to archives current redo log and unarchived redo logs, after the "backup database" command? Why not before the "backup database" command? Will RMAN execute it as a transaction for all commands in curly bracket? TIA Yustiono -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yustiono 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).
Backup Advice.
Hi there :) After a rather interesting start of my week, I have a question for you about the backup of local PC test databases. Rant At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting ora-600's and a corrupted SYSTEM datafile! Now that was fun to say the least I can tell you! I then went on to try and install Oracle again from a copy of 8.1.6 for Windows NT/2000, which was downloaded from technet, and burned on to a cd, to save disk space.. I had originally installed 8.1.6 from this download, but when I went to decompress the files from the zip, on the CD, I had corruption on the CD!! Now, I dreamed of corrupted datafiles, corrupted CD's, even corrupted politicians over the weekend, and came in early this week to start downloading 8.1.7 (The only bonus in this little story:) which is in fact a download of 584mb. This is now STILL downloading right now at a rate of 4.5kbs, and is scheduled to finish in 17hours, and 37 minutes :( What a joy it is to have to download these extraordinarily huge files over a 56k modem. Even ADSL isn't available here until September.. \Rant The point? Well, I was wondering what you guys do out there to backup any local PC test databases you may have? I have no tape to backup too, and no real experience with backup or recovery situations. I have never backed up Oracle either :) The databases are all pretty static, as we just load up some data exported from our Access tracking system. The database is pretty much used for QA of our performance tools. What files should I backup first of all? There is no real need to have this database running in ARCHIVELOG MODE is there? Also, where would you reccomend backing up to? CD (aahhemmm!!), network drives, seperate directory? I'm really just trying to avoid the fun and games I've had this week, any advice? Thanks guys Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: . . .Compaq Tru64 5.1 Cluster / SAN?
Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle variables; LD_LIBRARY_PATH TNS_ADMIN
Oracle, by default, uses $ORACLE_HOME/network/admin to stor the tnsnames.ora, sqlnet.ora, listener.ora, snmpro.ora and snmprw.ora files for configuration of the Net8 services. If you declare a TNS_ADMIN variable oracle will use that location for these files. It allows you to keep your networking config files separate from the oracle distribution files. Example: On our development machines we have multiple oracle homes of diferent versions 8.0.x, 8.1.7, etc. All these versions use the same TNS files from a directory under the $ORACLE_BASE. Our setup is: /usr/oracle admin common SID product 8.0.5.1 8.1.7 jre oui oraInventory network admin log trace We then use the 8.1.7 listener and OEM agent against all db's. We have one sqlnet.ora and tnsnames.ora configuration for all instances on the machine. One place for log and trace files for TNS issues. It makes administration easier. The LD_LIBRARY_PATH is a variable that tells applications working with the oracle client where the oracle libraries are. It is version dependent and should be set with the oraenv. Normally it is $ORACLE_HOME/lib. If you are not using oraenv then you need to make sure that it is exported before you start doing your oracle stuff. All of this assumes that you are working with oracle on a Unix machine. The discussion applies to NT also except these variables are specified in the registry under \\HKEY_LOCAL_MACHINE\Software\Oracle HTH On Wednesday 28 March 2001 04:00, you wrote: Hello, I need some clarification. What is the significance of the Oracle variables, TNS_ADMIN LD_LIBRARY_PATH? When are the 2 used or what effects what in the environment? Also please if some one knows how do I monitor an Oracle Parallel Server? Any good book where I can read about OPS? Regards, Raja Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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 is best practice - differenet schema/different dbs
Just my $.02. I agree separate tbs for different app schema's. However, I would separate applications to their own db, especially if they are 3rd party apps. You have much less control on COTS. Some run their install scripts as sys. I don't agree w/ it, but I am not going to rewrite their code, too many impt things to do. The additional db resources required for separate databases for different apps is worth it. If management wants more apps, then you tell them to buy more hardware. Now if you have complete control of all the apps (i.e. you develop them), then maybe I would put them in the same db. Big maybe :) Gene [EMAIL PROTECTED] 03/28/01 08:35AM Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject: Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: changing db_block_size
Joe, No flame. There are other methods of doing the job, but the work!!! Spooling all the data out to comma delimited files, creating all those DDL scripts!! You'd have to be a masochist or else into some HEAVY re-engineering! Dick Goulet Reply Separator Author: "Joseph S. Testa" [EMAIL PROTECTED] Date: 3/27/2001 4:50 PM last i checked that was your only choice, anyone like to flame me for that statement :) joe Roy Ferguson wrote: all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
Is there any Access user group?
-- 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).
Opinions on this book...
Hi Gang, Happy Wednesday! Has anyone read this book? I'm interested in what you thought of it. Thanks, -Rocky --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Rocky ! I guess you are talking about his OCP TEst prepration guide. I think it is published by new riders. A quick search on AMAZON.com will give you more detaiils - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 2:45 AM Hi Gang, Anyone know of a book by Willard Baird? I'd like to like to know the title and any thoughts you may have. TIA, Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: OFF TOPIC: java servlet service provider
try elance.com -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 4:56 PM Hi, I developed a java servlet based application. I need an ASP. do you know java service provider company ? thanks in advance... = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal 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: New born DBA.....
You could also download and use the following checklists which are always handy to refer to when starting up: http://www.geocities.com/tbcox23/dba_checklist13.doc http://pillango.sirma.bg/oracle/N008_dba_checklist.pdf Good luck on that HUGE rollercoaster of a learning curve ORACLE!! HTH Mark -Original Message- William Sent: Wednesday, March 28, 2001 01:26 To: Multiple recipients of list ORACLE-L Sinardy Xing wrote: Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. shameless plug get the book _Oracle DBA 101_ it has not only that kind of list, but lots and lots of other good stuff. and you can always ask one of the authors questions right here on the list.;-) /shameless plug did i do good rachel?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Using Profiles to Force Users off After Inactivity
Ian, From what I've seen on 8.1.6 8.1.7 it still does the non immediate kill changing the session status from active/inactive to sniped, but it does release locks a whole lot faster. Dick Goulet Reply Separator Author: "MacGregor; Ian A." [EMAIL PROTECTED] Date: 3/27/2001 11:46 AM Has this been improved in 8i. When the time has expired does it still issue alter system kill session 'sid,serial#'; or does it now issue alter system kill session 'sid,serial#' immediate; Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: changing db_block_size
I'd be interested in seeing that presentation, when are you presenting? I'll be there doing the logminer thing on tuesday late afternoon, last session before BIG BASH. thanks, joe To change the block size you have to recreate the database. How you are going to copy the data that's another issue. You can use full database export/import (pretty long downtime, or problems with data consistency) or you can do a live copy. More on a live copy you can see in: Venkat S. Devraj, Oracle 24x7 Tips Techniques, Osborne Press, 2000. I am currently working on a similar project (live database migration). I will present some results at IOUG if you are there. Djordje - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 6:40 PM all, I would like to change the db_block_size (currently 2048) of our production database and would be interested in hearing from those that have done this on a not so small database. This is our oracle financials/manufacturing server and is about 30GB in size. Did you recreate the database using imp/exp or another method? Running Oracle 8.0.5 on Sun Solaris 7. thanks in advance...roy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Roy Ferguson 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: djordjej INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
Intermedia violates own constraint.
Hi. I had some problems with getting Intermedia to work after patching to 8.1.7. I got a ORA-04045: errors during recompilation/revalidation of CTXSYS.CONTEXT ORA-29835: ODCIGETINTERFACES routine does not return required interface(s) When trying to create an index. Searched Metalink, and eventually found document 1327325 where the workaround is stated to be spool recompile1.sql select 'alter package '||owner||'.'||object_name||' compile;' from dba_objects where object_type='PACKAGE' and status='INVALID' and owner in('ORDSYS','CTXSYS'); spool off; @recompile1.sql I applied this, but when I try to create the index now, I get SQL CREATE INDEX ccs_search_index ON ccs_search(content) INDEXTYPE IS ctxsys.context PARAMETERS('section group ccs_search_group'); 23 CREATE INDEX ccs_search_index * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: interMedia Text error: ORA-1: unique constraint (CTXSYS.DRC$IDX_COLSPEC) violated ORA-06512: at "CTXSYS.DRUE", line 122 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34 ORA-06512: at line 1 It seems to me, that intermedia tries to index into an existing table, and failes because it has lost track of it's own sequence? I'm just guessing here and could really use a few tips to get this thing working. Thanks, Morten -- Morten Primdahl Caput A/S Tel +45 70 12 24 42 [EMAIL PROTECTED]Nygade 6Fax +45 70 11 24 42 http://www.caput.com/ DK-1164 Kbh K -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morten Primdahl 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: 'Event Group Latch'
Title: RE: 'Event Group Latch' Thanks, Connor! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 2:56 AM To: Multiple recipients of list ORACLE-L Subject: 'Event Group Latch' Tom Kyte (asktom.oracle.com) kindly posted me a reply to my question on the above latch. For anyone interested, the description is below Cheers Connor -- START QUOTE Event Group Latch Usage This latch is used during the following operations : An alter system set events.. command. During process startup where the process copies the events stored in the System event group to its Process event group. Event Groups Events are considered to exist in either the process, session or system group. The differences are outlined below : System Group The event tree is built in the SGA and is derived from the settings of the instance parameter event. It can also be modified by using the command alter system set events Process Group These are initialised at process startup time via the instance parameter event. When the process starts up we copy the event tree that we have stored in the System Group. The event tree is built in the PGA. Session Group These are events that are modified dynamically via the alter session command. When we perform event checking we check the session group events before those of the process group. The event tree is built in the UGA. -- END QUOTE = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Real Workstation Requirements
My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I know that jinitator takes a lot of memory and processor speed to run. Oracle always specifies the absolute minimum requirements for the workstation. I am looking for some real world recommendations for hard drive sizing, memory, processor speed, processor type (Celeron, Pentium...). We don't want the absolute minimum, but allow some room for future growth. Any help would be very much appreciated. William Beilstein. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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: Someone changed INTERNAL password URGENT
Hi Alex, Are you sure in Unix you do not need password for internal if you are member of DBA group ? -- neena "Hillman, Alex" wrote: If you are on unix - you do not need internal password if you log in as member of dba group. On NT before 8.1 you need internal password but you can change it recreating password file or recreating instance using oradim. Alex Hillman -Original Message- From: Murali Vallath [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:18 AM To: Multiple recipients of list ORACLE-L Subject:Someone changed INTERNAL password URGENT URGENT, Someone changed the internal password. How do you connnect or change the internal password, if not able to find it? Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murali Vallath INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chandan 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).
Slightly off topic SFTP
DBA's, Has anyone been able to automate secure ftp "sftp"? I have several cron jobs that move an ascii file from one box to annother via cron jobs shell scripts. The security gestapo is now making us use ssh and sftp. I haven't been able to figure out the syntax to get sftp automated. Suggestions? TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: Real Workstation Requirements
I would say no Celeron processor for sure, I would go with PIII's 500 or above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use Dell Optiplex workstations, most of them are 500's and we don't run into any problems, most of them have 10 to 20 gig hd's and 256 mb's of RAM. Kev -Original Message- Beilstein Sent: Wednesday, March 28, 2001 11:25 AM To: Multiple recipients of list ORACLE-L My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I know that jinitator takes a lot of memory and processor speed to run. Oracle always specifies the absolute minimum requirements for the workstation. I am looking for some real world recommendations for hard drive sizing, memory, processor speed, processor type (Celeron, Pentium...). We don't want the absolute minimum, but allow some room for future growth. Any help would be very much appreciated. William Beilstein. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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: Kevin Kostyszyn 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: New born DBA.....
Check out First Steps on our site. -- email: [EMAIL PROTECTED] Oriole Corporation (http://www.oriole.com/) Oracle Performance Tools and Free Scripts Tel: +44 (0)20 7872 5480 Faxes: UK +44(0)705 066 8661 / US +1 240 526 5946 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 1:45 AM Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Opinions on this book...
I have W. Baird's book, "Oracle OCP". Unless there is a newer edition out it only covers Oracle 7.x, not 8 or 8i. I used it to help me pass the first OCP exam, SQL and PL/SQL. It was adequate for that if you also have considerable SQL experience with Oracle or other DBMS's. For the second exam, Database Admin, it was less than adequate because it did not cover Oracle 8 features. It was even worse for Bacup and Recovery because it did not cover RMAN. There are better OCP books out there. If you want my copy of Baird's, I'll give it to you for shipping cost, but I'd recommend the following book instead for DBA certification exam preparation: "Oracle8i Certified Professional DBA Certification Exam Guide" (With CD-ROM) by Ulrike Schwinn, Jason S. Couchman, Jeremy Judson I have been using the Oracle8 version, better for the OCP exams, but more importantly it contains a lot more useful information a DBA needs on the job. Dean Jefferson Oracle DBA -Original Message- From: Rocky Welch [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:06 AM To: Multiple recipients of list ORACLE-L Subject: Opinions on this book... Hi Gang, Happy Wednesday! Has anyone read this book? I'm interested in what you thought of it. Thanks, -Rocky --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Rocky ! I guess you are talking about his OCP TEst prepration guide. I think it is published by new riders. A quick search on AMAZON.com will give you more detaiils - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, March 28, 2001 2:45 AM Hi Gang, Anyone know of a book by Willard Baird? I'd like to like to know the title and any thoughts you may have. TIA, Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rocky Welch 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: Jefferson, Dean 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).
Standard vs Enterprise Edition
Title: Standard vs Enterprise Edition Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED]
Re:several peoplesoft databases (schemas) in one Oracle data
Alex, We've done both. Is there a down side, yes on both counts. With multiple Peoplesoft schema's your tablespaces need to be bigger, like initial size times number of schema's plus fudge factor. Also you can get IO bound on certain tablespaces, like PSINDEX real fast. You really can't have separate tablespaces for each schema without doing a LOT of work. You can have separate index tablespaces without too much work though. With multiple instances your system, redo, temp, etc.. disk consumption rises by the number of instances, semaphores and semaphore sets need maintenance, memory needs rise more than you'd believe, and system response time in general drops radically. It's a lot more pain with upgrades, patches, etc. since db links really run between instances instead of doing a loopback (Peoplesoft also ships a synonym script incase you go the non multiple instance route which really works better). Which way do you want to go, depends on your needs and resources. PeopleSoft developers and the like will buck you on having multiple schema's in one instance which I blame on PeopleSoft training, it's bad on this subject. I'd recommend a separate instance for Production and QA/TEST. Development, Demo and AUD can easily reside in the same instance. Dick Goulet Reply Separator Author: "Hillman; Alex" [EMAIL PROTECTED] Date: 3/28/2001 6:35 AM Can anybody give me pro and con for having let say several Peoplesoft schemas in the same database versus in different databases. Should objects of different schemas be in the same tablespaces or every schema should have it's own set of tablespaces etc. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Is there any Access user group?
Access User Groups... Sure, most High Schools have Groups that meet to discuss such things...I think they call them Clubs though! I've heard they provide some really neat technical discussions like..."How to Convert your Parents Paper-based Contact List into Access"..."Access 2000: Breaking the 10MB Barrier". Sorry for the sarcasm...I just couldn't resist! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Wednesday, March 28, 2001 10:36 AM To: Multiple recipients of list ORACLE-L -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haskins, Ed 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: Metalink customer satisfaction surveys
I had a call from Oracle Support about three weeks ago for a telephone Metalink customer satisfaction survey. What an opportunity;-)... I let them know it was unusably slow, inconsistent (call something the samething throughout what a concept), can't fing basic things like patches, no response on an iTAR for two or three days while the controller was off, etc, etc, etc. It was fun but I don't think the caller liked it very much. So far I don't see any improvement!!! ...JIM... [EMAIL PROTECTED] 3/28/01 7:15:22 AM Have any of you received one of those lately? I remember last year they used to check with us to see whether we were happy with the service, but I have received nothing in a long time. Someone soft closed one of my TARs, saying he had sent me the information I requested, but I can't find anything in my e-mail folders re. that TAR. I got the notices telling me the TAR has been updated, but I didn't receive the information the tech says he sent me -- at least I can't find it anywhere. My question was re. how we can secure the OEM, i.e. how to ensure that the OEM the DBAs use will be the only one in use to access our databases. What's to stop a developer or an end user from downloading the OEM for free, then using it to send jobs to the databases using the intelligent agents? Nothing, as far as I can see, if we go with the default configurations. I would very much like to see the guidelines I requested re. securing the OEM... I updated the TAR myself, maybe they will "un-soft-close" it. There is someone from Oracle development group on the ODTUG listserv, I sure wish there was someone from customer support or from the Oracle engineers group on this listserv. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton 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: sqlplus
Ravindra, try using 'trunc' on your group by clause. -Original Message- Sent: Wednesday, March 14, 2001 7:11 PM To: Multiple recipients of list ORACLE-L Can we use the group by clause on a date column.I am written a query to get a count(*) of records with a group by clause on the date column and with date b/w two specified dates.but the query just keep executing w/o giving any o/p or errors.The date field will also have the timestamp.Will this be a problem. I also tried with using the to_char but no success. How do i get the o/p. EX:The requirement is like say in a table with phone call info we want to display the count of call made b/w two dates in a month and grouped by date. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: parallel server; ops setup
Hi, I'm in digest mode, so here's reply to those OPS questions... I don't think you can set up OPS without a hardware cluster. In fact, if you don't turn on the Lock manager at the os level the Oracle installer won't even show OPS as an installation option! As for other other question re. converting a single instance db to ops... well, you'd be interested to know that to create an ops db I actually create a single instance db first, then do the following: 1. add new threads, ie. a thread per instance 2. shutdown 1st instance 3. create new init.ora for new instances 4. ensure that parallel_server=true. note this is 8i 5. startup all instances All of the above of course assumes that you have set up the hardware and installed ops as someone else has pointed out. HTH, Leng. [EMAIL PROTECTED] -- From: Muhammed Adnan Ansari Date: Tue, 27 Mar 2001 00:33:21 -0800 (PST) Subject: Parallel Server Do any body worked with Parallel server without a Hardware cluster...i mean just an evaluation of parallel server ...if yes then how??/ Adnan = Leng Kaing - [EMAIL PROTECTED] AUSOUG-VIC : http://www.ausoug.org/vic/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Leng=20Kaing?= 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: Standard vs Enterprise Edition
Title: Standard vs Enterprise Edition We also have a client that wants to use Standard because it is less expensive. I tried to install 8.1.6 SE on an NT server that already had EE on it. I made it a multihomed machine but ran into a problem with a dll. Seems to be a known bug, needless to say, it might have ruined my installation of Veritas Backup Exec, just thought I would mention it. I have been getting some very strange errors on the machine since I installed, I think I will move it to an empty machine. As far as the differences are concerned, i don't know yet. Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas JeffSent: Wednesday, March 28, 2001 10:36 AMTo: Multiple recipients of list ORACLE-LSubject: Standard vs Enterprise Edition Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks,Jeff T [EMAIL PROTECTED]
Re:Standard vs Enterprise Edition
Jeff, Yes we use Standard and Enterprise. Do you lose some things, yes. Does it matter, depends on the application. In our case we could work around those restrictions without problems. Otherwise it's a good ploy to save a buck. Dick Goulet Reply Separator Author: Thomas Jeff [EMAIL PROTECTED] Date: 3/28/2001 7:36 AM Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED] !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" HTML HEAD META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12" TITLEStandard vs Enterprise Edition/TITLE /HEAD BODY PFONT SIZE=2 FACE="Courier New"Due to Oracle's licensing shenanigans, we are looking at the use of the Standard /FONT BRFONT SIZE=2 FACE="Courier New"edition to save .nbsp; In fact, our management may even make Standard the de facto /FONT BRFONT SIZE=2 FACE="Courier New"standard while requiring justification for Enterprise./FONT /P PFONT SIZE=2 FACE="Courier New"If anyone is currently using Standard, or has experience with it, I would appreciate if/FONT BRFONT SIZE=2 FACE="Courier New"can you tell me what I lose by moving to Standard.nbsp; I've perused the features comparision /FONT BRFONT SIZE=2 FACE="Courier New"matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything./FONT /P PFONT SIZE=2 FACE="Courier New"Thanks,BR Jeff T/FONT BRFONT SIZE=2 FACE="Courier New"[EMAIL PROTECTED]/FONT /P BR /BODY /HTML -- 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).
OFFTOPIC RE: sqlplus
Title: OFFTOPIC RE: sqlplus This post would have been ALOT funnier, if Ravindra's name was, instead, Ganesh. (Sorry about all you folks that don't like Hindu Mythology based puns.) -Original Message- From: Bala, Prakash [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: sqlplus Ravindra, try using 'trunc' on your group by clause. -Original Message- Sent: Wednesday, March 14, 2001 7:11 PM To: Multiple recipients of list ORACLE-L Can we use the group by clause on a date column.I am written a query to get a count(*) of records with a group by clause on the date column and with date b/w two specified dates.but the query just keep executing w/o giving any o/p or errors.The date field will also have the timestamp.Will this be a problem. I also tried with using the to_char but no success. How do i get the o/p. EX:The requirement is like say in a table with phone call info we want to display the count of call made b/w two dates in a month and grouped by date. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Error: Failure to get normalized flag.
We batch load data into an application called Oracle Clinical. The batch load failed and gave the error: "Error: Failure to get normalized flag." Could low tablespace indirectly cause this error? Any help/ suggestions would be appreciated. Jenah Sigurdson -- 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: Backup Advice.
Mark, I might suggest that you look into a "Ghost" product for making an image of your PC. I "ghost" my pc and keep the image on the network where it is backed up each night and stored on tape. If I have problems with my PC I load the image to the second drive and I have access to all of the original files. My 2 bits. ROR mm [EMAIL PROTECTED] 03/28/01 10:30AM Hi there :) After a rather interesting start of my week, I have a question for you about the backup of local PC test databases. Rant At the end of last week I deleted my current test database along with all Oracle files, and went for a fresh install, due to having some rather interesting ora-600's and a corrupted SYSTEM datafile! Now that was fun to say the least I can tell you! I then went on to try and install Oracle again from a copy of 8.1.6 for Windows NT/2000, which was downloaded from technet, and burned on to a cd, to save disk space.. I had originally installed 8.1.6 from this download, but when I went to decompress the files from the zip, on the CD, I had corruption on the CD!! Now, I dreamed of corrupted datafiles, corrupted CD's, even corrupted politicians over the weekend, and came in early this week to start downloading 8.1.7 (The only bonus in this little story:) which is in fact a download of 584mb. This is now STILL downloading right now at a rate of 4.5kbs, and is scheduled to finish in 17hours, and 37 minutes :( What a joy it is to have to download these extraordinarily huge files over a 56k modem. Even ADSL isn't available here until September.. \Rant The point? Well, I was wondering what you guys do out there to backup any local PC test databases you may have? I have no tape to backup too, and no real experience with backup or recovery situations. I have never backed up Oracle either :) The databases are all pretty static, as we just load up some data exported from our Access tracking system. The database is pretty much used for QA of our performance tools. What files should I backup first of all? There is no real need to have this database running in ARCHIVELOG MODE is there? Also, where would you reccomend backing up to? CD (aahhemmm!!), network drives, seperate directory? I'm really just trying to avoid the fun and games I've had this week, any advice? Thanks guys Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Response times with different multiblock read count
Hi All, I am running a test query with different db_file_multiblock_read_count to test the overall throughput. environment: oracle 8.1.6 on hp-ux v11 db_block_size : 16k system is using LVM and file system is using buffered I/O and disk is mirrored but not stripped. I was expecting that having larger multiblock count would result in better performance. But, when I was testing the query with smaller multiblock count,the response time is better. Here is the testing result. Multiblock time in Secs -- 1 12.5 better 2 12.5 better 4 12.6 better 8 27 bad 16 27 bad 32 18.6 okay 64 19.0 okay I don't understand why 8,16 are taking longer time. I did make sure that oracle is issuing proper multiblock read count with the help of multiblock_read_test.sql which is available in Steve Adams's site. Thank you steve for providing valuable information scripts on your web site. select statement that I am using is, select /*+ full(t) noparallel(t) nocache(t) */ count(*) from Table t; I am clueless why it is behaving like this. Please pass your suggestions. If you need more info like oracle/OS settings etc, please let me know. When I was doing some reading on steve adam's site, he suggests the following. Date: 29-Dec-2000 20:55 Nevertheless, it remains best to allow Oracle to use large multiblock reads, as long as the optimizer is not doing inappropriate full scans. The explanation relates to the system call and context switch overheads associated with I/O. It is cheaper in CPU usage terms to request a 256K I/O and allow the operating system to service it in 64K chunks, than to request 4 I/O's of 64K each. As is mentioned in the tip on Why Large Multiblock Reads, the increased latency is not an issue because multiblock reads should not be used in cases where "first rows" response time is critical. Thanks in advance. Best Regards, Prasad -- 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: SQLCode in 8i
Regina, try sqldbcode. This will give the exact Oracle return code. Prakash -Original Message- Sent: Wednesday, March 21, 2001 9:05 PM To: Multiple recipients of list ORACLE-L We have a number of Powerbuilder applications for which we have been using the SQLCode returned from a sql statement execution to determine the next action, depending on if the statement failed (SQLCode 0), didn't return any rows (SQLCode = 100) or successfully returned data (SQLCode = 0). We upgraded to 8.1.6 two weeks ago, and just discovered that, outside of an exception block, SQLCode now always returns 0. Do any of you know a way to return to the old codes, or make it treat Powerbuilder like an exception block, or know of some other code we could use to gather this information? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Is terminal release of 8.0.x still supported?
The terminal release of Oracle8 is 8.0.6. Not sure of the desupport date, even though I have 4 databases running it. I really don't worry to much about the desupport date. As a general rule if it ain't broke I don't fix it. Granted we are going to 8.1.7 on most of them but that is to get a lot of the new features that will help in the development side of things. Don't forget that desupport just means that they will not fix new bugs, not that you can't call on existing issues. -Original Message- Sent: Wednesday, March 28, 2001 3:51 AM To: Multiple recipients of list ORACLE-L We have some 8.0.4 databases running on Sun Solaris. I believe that 8.0.4 has been desupported as of December 31, 2000. We are unable to upgrade one of our apps at this time that is running on an 8.0.4 database. Is the terminal release of 8.0.x still supported? If yes, what is that terminal release? Is it 8.0.7? How long before that terminal release will be desupported (if it is currently supported)? Thanks, Cherie Machler Gelco Information Network -- 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). -- 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: What is best practice - differenet schema/different dbs
Actually I meant Dick, nor Doug, sorry Mike -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: What is best practice - differenet schema/different dbs Hi Doug , (and all) , Just curious - the PS environment, do you put finance and HR on the same DB? Do you share the sysadm user? I'm new to this PS stuff, so this interests me. Also, in production, do you have the PS databases separated from the other OLTP databases? Thanks Mike Lanteigne -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Re:What is best practice - differenet schema/different dbs Rao, I'm going to differ from a previous return post. I think that you should use different schema's with separate tablespaces. Why? Because your all on one machine therefore all of your background Oracle processes are competing for the same CPU, memory, and IO resources which can and does slow matters down significantly. The best bet in my experience is one large DB instance with a very large SGA, particularly in the DB_BLOCK_BUFFERS area. We've tried both approaches with our PeopleSoft development environments and this works much better than multiple instances. Way too much background CPU Memory burn not to mention all of the wasted disk space for multiple system, temp, rbs, and other tablespaces. It really dings the IO too. BTW: with each schema in it's own tablespace(s) you can still take one offline without crashing the others, unless you need to take system or rbs offline. Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike 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: Lanteigne, Mike 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: Support rational
well the concept of support is you pay for it and it covers all versions(at leats until desupported which seems quick nowadays). hence the concept of "free" version upgrades :) joe From: "O'Neill, Sean" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Support rational Date: Wed, 28 Mar 2001 07:56:54 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id MAA18674for jtestamail@localhost; Wed, 28 Mar 2001 12:19:34 -0500 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Wed, 28 Mar 2001 12:19:35 -0500 (EST) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2SIIKl23874for [EMAIL PROTECTED]; Wed, 28 Mar 2001 12:18:31 -0600 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA26331;Wed, 28 Mar 2001 09:10:32 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DA35F; Wed, 28 Mar 2001 07:56:54 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "O'Neill, Sean" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: I'm kind'a thinkin' out loud on this one. but suppose we have say 3 servers, with 8.1.7 Standard edition, is there any point in paying for Oracle support for all 3 or having problems with "any" one of them logged via one support package. Where are the gotcha's on this line of thinking (I'll hope there are some!)? For those who have differnet versions of Oracle on same site do ye all take support for each flavour/version/server of Oracle or use one to cover for version groups etc.? Sean:) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. http://www.organon.ie E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother. and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: A Basic PL/SQL Question
Another option is to create a table with a large varchar2 column and insert the data row by row. You can then spool a SELECT from that table to a file. e.g. create table hold_output (mytext varchar2(4000) tablespace ts_small; -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO 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: Miller, Jay 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: Standard vs Enterprise Edition
We use it for all of our small, under 10 gig, NT databases (at last count we had 13). Many of the features of Enterprise are just not needed for these systems because the user/data volume is small and we are not using replication or fine-grain access control. All of the 3rd party applications (except SAP) on site have been coded for standard. These 3rd party vendors don't have good DBAs on staff either, but that is a different topic. List - Is that your experience also? Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation Thomas Jeff ThomasJe@tceTo: Multiple recipients of list ORACLE-L .com[EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Standard vs Enterprise Edition com 03/28/2001 09:36 AM Please respond to ORACLE-L Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED] -- 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: Problems with export/import
Maybe there are several things you want to check on your table in database B 1) Do you have any trigger on that table? 2) Do you have any foreign key constraints on that table? 3) Is that table structure the same on 2 databases? Winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001 11:24:28 AM Please respond to [EMAIL PROTECTED] To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" [EMAIL PROTECTED], "Oracle List \(Telelist\) \(E-mail\)" [EMAIL PROTECTED] cc: Hi! I'm having weird problems with exporting/importing tables... First I run an export on database A About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) tbclocktimes . . exporting table TBCLOCKTIMES 2929 rows exported The exports terminates successfully without warnings. Then I want to import that dump file into database B, but it fails: . importing VIVOUSER's objects into VIVOUSER . . importing table "TBCLOCKTIMES" IMP-00058: ORACLE error 1403 encountered ORA-01403: no data found Any idea what's going wrong? This is 8.1.6 on Win2k Thanks, Helmut Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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: SQLCode in 8i
Thanks for the suggestion, Prakash, but SQLDBCode is also returning 0 for no rows found. At 08:25 AM 3/28/01 -0800, you wrote: Regina, try sqldbcode. This will give the exact Oracle return code. Prakash -Original Message- Sent: Wednesday, March 21, 2001 9:05 PM To: Multiple recipients of list ORACLE-L We have a number of Powerbuilder applications for which we have been using the SQLCode returned from a sql statement execution to determine the next action, depending on if the statement failed (SQLCode 0), didn't return any rows (SQLCode = 100) or successfully returned data (SQLCode = 0). We upgraded to 8.1.6 two weeks ago, and just discovered that, outside of an exception block, SQLCode now always returns 0. Do any of you know a way to return to the old codes, or make it treat Powerbuilder like an exception block, or know of some other code we could use to gather this information? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: . . .Compaq Tru64 5.1 Cluster / SAN?
We are doing that here, we have a 7 ft. tall SAN frame with dozens of hard disks laying about in boxes, with two es-40s also in boxes. We plan to have that put together by mid April. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: Hand, Michael T Sent: Wednesday, March 28, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: . . .Compaq Tru64 5.1 Cluster / SAN? Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Bad Cookies with Internet Application Server 1.0
Did someone change the password of the app logging into the db? [EMAIL PROTECTED] 03/28/01 11:40AM We've been running iAS 1.0 for several months without problems. Now users who have already been verified are at times getting the following error when they move to a new URL. -- Database Log In Failed. HTTP/1.1 503 Service Temporarily Unavailable Date: Tue, 27 Mar 2001 23:56:32 GMT Server: Apache/1.3.9 (Unix) mod_ssl/2.4.10 OpenSSL/0.9.4 mod_perl/1.21 ApacheJServ/1.1 Connection: close Content-Type: text/html WWW-Authenticate: Basic realm="SLAC" Database Log In Failed An invalid username/password caused log in to database fail. --- It is not related to the URL called. Has anybody else had this problem. Nothing shows up in the error log, nothing untoward shows up in the httpds*_log(s). Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problems with export/import
Hi! I'm having weird problems with exporting/importing tables... First I run an export on database A About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) tbclocktimes . . exporting table TBCLOCKTIMES 2929 rows exported The exports terminates successfully without warnings. Then I want to import that dump file into database B, but it fails: . importing VIVOUSER's objects into VIVOUSER . . importing table "TBCLOCKTIMES" IMP-00058: ORACLE error 1403 encountered ORA-01403: no data found Any idea what's going wrong? This is 8.1.6 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Real Workstation Requirements
Thanks [EMAIL PROTECTED] 03/28/01 12:05PM I would say no Celeron processor for sure, I would go with PIII's 500 or above, minimum 128 RAM 256 would be better, at least a 10 gig hd. We use Dell Optiplex workstations, most of them are 500's and we don't run into any problems, most of them have 10 to 20 gig hd's and 256 mb's of RAM. Kev -Original Message- Beilstein Sent: Wednesday, March 28, 2001 11:25 AM To: Multiple recipients of list ORACLE-L My firm is currently using Oracle Applications 10.7SC and are in the planning stage for 11i. I have been tasked with finding the Workstation requirements for 11i. The Workstations will be running Windows 2000 with Microsoft Office, email client and a number of smaller financial applications. I know that jinitator takes a lot of memory and processor speed to run. Oracle always specifies the absolute minimum requirements for the workstation. I am looking for some real world recommendations for hard drive sizing, memory, processor speed, processor type (Celeron, Pentium...). We don't want the absolute minimum, but allow some room for future growth. Any help would be very much appreciated. William Beilstein. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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: Kevin Kostyszyn 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: William Beilstein 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: Standard vs Enterprise Edition
Sometimes I forget that unhappiness is only based on perception. "Thater, William" To: Multiple recipients of list ORACLE-L ThaterW@tele[EMAIL PROTECTED] rgy.net cc: Sent by: Subject: Re: Standard vs Enterprise Edition root@fatcity. com 03/28/2001 11:45 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: (except SAP) on site have been coded for standard. These 3rd party vendors don't have good DBAs on staff either, but that is a different topic. List - Is that your experience also? you mean you get a vender with a DBA on staff? damn, you're lucky.;-) we actually have a vendor here who does not have a working ORACLE database to test out our problems and fixes on. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
FW: [Fwd: Response times with different multiblock read count]
Prasad, the difference here is : select count(*) does not require the data in all of the columns. if you are going to be including columns that return a large amount of data, then the larger reads should help. As its most likely that the OS read size is 64 KB, it makes sense that a local minimum of the response time function is found at that point. Why don't you retry the query while bringing back all (or most) of the columns? hth, Paul Paul Drake DBA/SysAdmin Professional Software Systems Original Message Date: Wed, 28 Mar 2001 08:25:31 -0800 Reply-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hi All, I am running a test query with different db_file_multiblock_read_count to test the overall throughput. environment: oracle 8.1.6 on hp-ux v11 db_block_size : 16k system is using LVM and file system is using buffered I/O and disk is mirrored but not stripped. I was expecting that having larger multiblock count would result in better performance. But, when I was testing the query with smaller multiblock count,the response time is better. Here is the testing result. Multiblock time in Secs -- 1 12.5 better 2 12.5 better 4 12.6 better 8 27 bad 16 27 bad 32 18.6 okay 64 19.0 okay I don't understand why 8,16 are taking longer time. I did make sure that oracle is issuing proper multiblock read count with the help of multiblock_read_test.sql which is available in Steve Adams's site. Thank you steve for providing valuable information scripts on your web site. select statement that I am using is, select /*+ full(t) noparallel(t) nocache(t) */ count(*) from Table t; I am clueless why it is behaving like this. Please pass your suggestions. If you need more info like oracle/OS settings etc, please let me know. When I was doing some reading on steve adam's site, he suggests the following. Date: 29-Dec-2000 20:55 Nevertheless, it remains best to allow Oracle to use large multiblock reads, as long as the optimizer is not doing inappropriate full scans. The explanation relates to the system call and context switch overheads associated with I/O. It is cheaper in CPU usage terms to request a 256K I/O and allow the operating system to service it in 64K chunks, than to request 4 I/O's of 64K each. As is mentioned in the tip on Why Large Multiblock Reads, the increased latency is not an issue because multiblock reads should not be used in cases where "first rows" response time is critical. Thanks in advance. Best Regards, Prasad -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
online backup query
Hi gurus I am new to this group. What are those files need to backup in online backup mode? how we know the database is setup in OPS mode? Please help me. Thanks in advance. Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bad Cookies with Internet Application Server 1.0
The authentication is via the users' oracle passwords. One user just got the error, and she doesn't use cookies. It is intermittent, but once it occurs, the users need to be reauthenticated before it works successfully. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, March 28, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Did someone change the password of the app logging into the db? [EMAIL PROTECTED] 03/28/01 11:40AM We've been running iAS 1.0 for several months without problems. Now users who have already been verified are at times getting the following error when they move to a new URL. -- Database Log In Failed. HTTP/1.1 503 Service Temporarily Unavailable Date: Tue, 27 Mar 2001 23:56:32 GMT Server: Apache/1.3.9 (Unix) mod_ssl/2.4.10 OpenSSL/0.9.4 mod_perl/1.21 ApacheJServ/1.1 Connection: close Content-Type: text/html WWW-Authenticate: Basic realm="SLAC" Database Log In Failed An invalid username/password caused log in to database fail. --- It is not related to the URL called. Has anybody else had this problem. Nothing shows up in the error log, nothing untoward shows up in the httpds*_log(s). Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. 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).
Update existing rows at import
Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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).
ORA-01031: insufficient privileges
Solaris V2.6 Oracle V8.1.8 Previously I logged in as username "HR" did SQL GRANT SELECT ON EMPHEADER_MASTER TO BCM; Within a PL/SQL package the following lines exits. EXECUTE IMMEDIATE 'TRUNCATE TABLE HR_EMP'; EXECUTE IMMEDIATE 'DROP TABLE HR_EMP'; EXECUTE IMMEDIATE 'CREATE TABLE HR_EMP TABLESPACE USERS STORAGE ( INITIAL 128K NEXT 128K) UNRECOVERABLE AS SELECT * FROM HR.EMPHEADER_MASTER'; The procedure bombs with ORA-01031: insufficient privileges on the CTAS line. I (schema BCM) own the procedure execute it. I can manually (from SQL*PLUS) successfully cut, paste run the CREATE TABLE ... AS... Any advice on how to make the error go away get the table created would be greatly appreciated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
storage area networks
Anyone using storage area networks for an Oracle database. Who is the vendor and what is your opinion of the product. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META content="text/html; charset=iso-8859-1" http-equiv=Content-Type META content="MSHTML 5.00.3314.2100" name=GENERATOR/HEAD BODY style="FONT: 10pt Courier New; MARGIN-LEFT: 2px; MARGIN-TOP: 2px" DIVAnyone using storage area networks for an Oracle database.nbsp; Who is the vendor and what is your opinion of the product./DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIVJeffrey BeckstromBRDatabase AdministratorBRGreater Cleveland Regional Transit AuthorityBR1240 W. 6th StreetBRCleveland, Ohio 44113BR(216) 781-4204/DIV/BODY/HTML
RE: Update existing rows at import
Helmut, have you thought about using UTL_FILE package? -Original Message- Sent: Wednesday, March 28, 2001 2:37 PM To: Multiple recipients of list ORACLE-L Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: . . .Compaq Tru64 5.1 Cluster / SAN?
Mike, We are using the SAN architecture. Jay [EMAIL PROTECTED] 03/28/01 10:36AM Thanks for the heads up. We are also planning upgrades from 40F to 5.1 nonclustered with Oracle 8.0.6. Has anyone considered or implemented Compaq's SAN architecture? Mike Hand Polaroid Corp -Original Message- Sent: Wednesday, March 28, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Lee, Be sure to check the alerts on Metalink for Tru64 (Product Lifecycle, Alerts). There are OS level patches requried for nonclustered systems. See Note 132391.1. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 03/28/01 03:00AM Is this problem specific to the cluster solution or has it manifested itself on non-clustered setups ? We are about to implement a Tru64 5.1 Oracle 8.1.7 system. As I cannot access the tar you mentioned could you please forward on the instructions. Regards Lee -- 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).
Db stat change query
Hi gurus Is it necessary to take full backup when we change the database from archivelog mode to noarchivelog mode and vice versa. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLCode in 8i
We're not connecting via ODBC, we're using the native drivers, but yes, we have tried both the 7.3 driver we used to use and both the 8.0 and 8.1 drivers. At 12:12 PM 3/28/01 -0800, you wrote: Regina, did you try using the ODBC driver that you used earlier. -Original Message- Sent: Wednesday, March 28, 2001 1:46 PM To: Multiple recipients of list ORACLE-L Thanks for the suggestion, Prakash, but SQLDBCode is also returning 0 for no rows found. At 08:25 AM 3/28/01 -0800, you wrote: Regina, try sqldbcode. This will give the exact Oracle return code. Prakash -Original Message- Sent: Wednesday, March 21, 2001 9:05 PM To: Multiple recipients of list ORACLE-L We have a number of Powerbuilder applications for which we have been using the SQLCode returned from a sql statement execution to determine the next action, depending on if the statement failed (SQLCode 0), didn't return any rows (SQLCode = 100) or successfully returned data (SQLCode = 0). We upgraded to 8.1.6 two weeks ago, and just discovered that, outside of an exception block, SQLCode now always returns 0. Do any of you know a way to return to the old codes, or make it treat Powerbuilder like an exception block, or know of some other code we could use to gather this information? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Regina Harter 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: Update existing rows at import
Can you have a before-insert trigger on your table to do whatever you want and then use conventional sqlldr to load it? winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001 12:38:10 PM Please respond to [EMAIL PROTECTED] To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" [EMAIL PROTECTED], "Oracle List \(Telelist\) \(E-mail\)" [EMAIL PROTECTED], "Joe Sawyer \(E-mail\)" [EMAIL PROTECTED], "Frach Karsten \(E-mail\)" [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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: Db stat change query
Yes, it is necessary to take a full backup when you change your database from noarchivelog mode to archivelog mode. Or else you will never have a "base" to perform recovery if it is needed. Winnie "Seema Singh" [EMAIL PROTECTED]@fatcity.com on 03/28/2001 01:25:26 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi gurus Is it necessary to take full backup when we change the database from archivelog mode to noarchivelog mode and vice versa. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Update existing rows at import
Helmut, Use SQLLOADER to load the file into a temporary table. Then write a script/procedure to scan the contents of temporary table, compare this info with base table, if row exists, update, else insert. IMME (In my modest eperience) this is the easiest way. HTH Some Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! * 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Db stat change query
Yes. Unless you can risk having a time where you can't recover your database. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Db stat change query Hi gurus Is it necessary to take full backup when we change the database from archivelog mode to noarchivelog mode and vice versa. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A 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 query
In V$INSTANCE, there is a column named PARALLEL which will tell you whether the instance is in OPS mode or not. In online backup mode, you will need to backup 1) all datafiles 2) a binary backup of the controlfile 3) all archivelog files generated during the online backup period of time 4) I will also backup the init.ora file, a backup trace of the controlfile, password file etc. Winnie "Seema Singh" [EMAIL PROTECTED]@fatcity.com on 03/28/2001 12:25:55 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Hi gurus I am new to this group. What are those files need to backup in online backup mode? how we know the database is setup in OPS mode? Please help me. Thanks in advance. Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Update existing rows at import
You can't query or modify the same table as the trigger is firing on (The old mutating table problem). What you could do is set up a temp table with a before insert trigger which would query the other table and take the appropriate actions, this would solve you having to run a separate procedure after the temp table was loaded. Or load the temp table and run a procedure. When your done with your insert, truncate the temp table and your ready for your next load. [EMAIL PROTECTED] 03/28/01 04:06PM Can you have a before-insert trigger on your table to do whatever you want and then use conventional sqlldr to load it? winnie "Helmut Daiminger" [EMAIL PROTECTED] on 03/28/2001 12:38:10 PM Please respond to [EMAIL PROTECTED] To: "Oracle DBA List \(Lazy DBA\) \(E-mail\)" [EMAIL PROTECTED], "Oracle List \(Telelist\) \(E-mail\)" [EMAIL PROTECTED], "Joe Sawyer \(E-mail\)" [EMAIL PROTECTED], "Frach Karsten \(E-mail\)" [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein 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).
Script to Compare table structures
Hi, I would appreciate if someone could pass me a script which compares table structures? Johnson __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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).
FW: Standard vs Enterprise Edition
Oops !!! forgot to send the attachment. Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. Size of the database is 70GB. The application uses very limited database features. No replication, partitioning, OPS, standby database, ... Please see attached document from Oracle Technet for differences between Oracle Enterprise Edition and Oracle Standard Edition. If you do not need the extra functionality like partitioning, advanced replication it may not be worth the extra effort of spending money on the Enterprise Edition. The cost of the Enterprise Edition compared to the Standard Edition is large (2 x). Most companies purchase the Enterprise Edition but do not even use 30% of the features that come with it. What a waste of $$$. Please see attached .PDF to get more insight on technical differences between the both editions. HTH Suhen Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED] 8i_fam.pdf
Re: Script to Compare table structures
Download free version of TOAD from www.toadsoft.com. Once installed and logged into look under View---Schema Differences you can compare many aspects of two schemas (eg compare your test and production schemas). Table comparisons are one of the many things you can compare. HTH --- Johnson Poovathummoottil [EMAIL PROTECTED] wrote: Hi, I would appreciate if someone could pass me a script which compares table structures? Johnson __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil 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 email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini 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).
Does anyone know a link to 9i documentation?
Thanks, Waleed -- 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: Standard vs Enterprise Edition
Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. The application uses very limited database features. No replication, partitioning, OPS, standby database, ... Please see attached document from Oracle Technet for differences between Oracle Enterprise Edition and Oracle Standard Edition. If you do not need the extra functionality like partitioning, advanced replication it may not be worth the extra effort of spending money on the Enterprise Edition. The cost of the Enterprise Edition compared to the Standard Edition is large (2 x). Most companies purchase the Enterprise Edition but do not even use 30% of the features that come with it. What a waste of $$$. Please see attached .PDF to get more insight on technical differences between the both editions. HTH Suhen Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather 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: Standard vs Enterprise Edition
Title: RE: Standard vs Enterprise Edition Thanks everyone for the replies. -Original Message- From: Suhen Pather [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Subject: FW: Standard vs Enterprise Edition Oops !!! forgot to send the attachment. Jeff, We have a retail application (JDA) using Oracle 8.1.6 using the Standard Edition. It works fine with very few problems. Size of the database is 70GB. The application uses very limited database features. No replication, partitioning, OPS, standby database, ... Please see attached document from Oracle Technet for differences between Oracle Enterprise Edition and Oracle Standard Edition. If you do not need the extra functionality like partitioning, advanced replication it may not be worth the extra effort of spending money on the Enterprise Edition. The cost of the Enterprise Edition compared to the Standard Edition is large (2 x). Most companies purchase the Enterprise Edition but do not even use 30% of the features that come with it. What a waste of $$$. Please see attached .PDF to get more insight on technical differences between the both editions. HTH Suhen Due to Oracle's licensing shenanigans, we are looking at the use of the Standard edition to save . In fact, our management may even make Standard the de facto standard while requiring justification for Enterprise. If anyone is currently using Standard, or has experience with it, I would appreciate if can you tell me what I lose by moving to Standard. I've perused the features comparision matrix, but I'd like to see some other feedback to ensure I'm not overlooking anything. Thanks, Jeff T [EMAIL PROTECTED]
NOT A SINGLE MAIL!
Hi! I haven't received a single mail from the LiST.. Is there a problem? Please tell Thanks - Original Message -- "Rachel Carmichael" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Rachel Carmichael" [EMAIL PROTECTED] Date:Thu, 22 Mar 2001 05:36:05 -0800 Subject:RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Tim, That sounds about right. SRDF is something like Symmetrix Remote Data Facility and is basically mirrored disks at a remote site. Rachel From: "Tim Sawmiller" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Date: Thu, 22 Mar 2001 04:30:26 -0800 So, Jared, are you auditioning for Louis Rukeyser's job? 8-) Lisa can probably explain better, but as I recall, BCV is something Backup Control Volumes. It's a third mirror that can be split off from the other two and used for a cold backup (e.g. shutdown Oracle database, split BCVs from the mirror set, restart Oracle (this takes like 5 minutes or less); run cold backup at your leisure). Then they can be re-attached to the mirrored disks at any time and the BCVs are synchronized with the mirrored disks automagically. Right Lisa? [EMAIL PROTECTED] 03/21/01 11:17PM Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast, let me tell you! Worth every penny we paid) However you can also mount the BCV's and access the data. Honestly I don't see any reason why I wouldn't be able to install Oracle on this server and open up a read-only database on the BCV's. Except for maybe the fact that my employer practically chokes when Oracle quotes pricing. We are running HP/UX. If you want more specific info, email me directly and I'll be glad to answer questions. Have a great day... Lisa Rutland Koivu Oracle Database Administrator -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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
Oracle Books on Audio Tapes
Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol 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: Standard vs Enterprise Edition
The cost of the Enterprise Edition compared to the Standard Edition is large (2 x). The way i figure enterprise is over 6.5 times more expensive. Enterprise = $100/Universal Power Unit to $15.00/Universal Power Unit. That is quite a difference.I would sure make sure we used feature available ( if they work..) Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski 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).
Nologging
I know it is possible when creating a table to specify no logging so that it doesn't generate redo logs. Is it possible, AFTER the table has already been created, to change it to nologging? Also this is a dev database that we don't care about doing any type of recovery and just want to do some quick loads -- is it possible to change the entire database to nologging? This is on Oracle 8.0.5. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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: Nologging
that has nothing to do with the question. But anyway, try ALTER TABLE NOLOGGING instead. oli [EMAIL PROTECTED] wrote Alter database noarchivelog; will change the entire database. see the following for detailed information: http://technet.oracle.com/docs/products/oracle8i/doc_index.htm HTH, Jim -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, March 28, 2001 4:37 PM I know it is possible when creating a table to specify no logging so that it doesn't generate redo logs. Is it possible, AFTER the table has already been created, to change it to nologging? Also this is a dev database that we don't care about doing any type of recovery and just want to do some quick loads -- is it possible to change the entire database to nologging? This is on Oracle 8.0.5. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt 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).
about ops on linux
Recently I installed ops ( oracle 8.1.7.0.1) on linux ( redhat 6.2). Unfortunately, everytime I ran ocmstart.sh, the system crashed. I'm sure I've did all needed to be done according to the documents. Any suggestions? below is extracted from cm.log. Wed Mar 28 17:22:42 2001 | ERROR | 0400 | StartCMMon(); NMAttach failed - 2 : [ 0 4 0 ] Wed Mar 28 17:22:43 2001 | WARNING | 0402 | CmConnectListener (pid=563, tid=1026): WatchdogPing failed (rc=12). Wed Mar 28 17:22:45 2001 | WARNING | 0402 | CmConnectListener (pid=563, tid=1026): WatchdogPing failed (rc=12). Wed Mar 28 17:22:47 2001 | MESSAGE | 0400 | CreateLocalEndpoint(): Network Address: 192.168.100.180 Wed Mar 28 17:22:47 2001 | ERROR | 0400 | StartCMMon(); NMAttach failed - 2 : [ 0 4 0 ] Wed Mar 28 17:22:48 2001 | WARNING | 0402 | CmConnectListener (pid=563, tid=1026): WatchdogPing failed (rc=12). Wed Mar 28 17:22:50 2001 | WARNING | 0402 | CmConnectListener (pid=563, tid=1026): WatchdogPing failed (rc=12). Wed Mar 28 17:22:52 2001 below is extracted from nm.log Wed Mar 28 17:22:16 2001 | WARNING | InitClusterDb():
RE: NOT A SINGLE MAIL!
cos u dont like Air. Ask Jared :) -Original Message- From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:16 PM To: Multiple recipients of list ORACLE-L Subject: NOT A SINGLE MAIL! Hi! I haven't received a single mail from the LiST.. Is there a problem? Please tell Thanks - Original Message -- "Rachel Carmichael" [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:"Rachel Carmichael" [EMAIL PROTECTED] Date:Thu, 22 Mar 2001 05:36:05 -0800 Subject:RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Tim, That sounds about right. SRDF is something like Symmetrix Remote Data Facility and is basically mirrored disks at a remote site. Rachel From: "Tim Sawmiller" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: EMC TimeFinder, and EMC TimeFinder vs Hot Standby Date: Thu, 22 Mar 2001 04:30:26 -0800 So, Jared, are you auditioning for Louis Rukeyser's job? 8-) Lisa can probably explain better, but as I recall, BCV is something Backup Control Volumes. It's a third mirror that can be split off from the other two and used for a cold backup (e.g. shutdown Oracle database, split BCVs from the mirror set, restart Oracle (this takes like 5 minutes or less); run cold backup at your leisure). Then they can be re-attached to the mirrored disks at any time and the BCVs are synchronized with the mirrored disks automagically. Right Lisa? [EMAIL PROTECTED] 03/21/01 11:17PM Ok, does someone one to define SRDF and BCV for those of us that don't have any idea what you're talking about? Jared On Wed, 21 Mar 2001, Koivu, Lisa wrote: Hi Yosi, how are you? I can't exactly clarify your fish vs. potatoes, er, timefinder vs. SRDF question but I can tell you that we have BCV's implemented here. We use them for backup and recovery (and it's extremely slick and fast, let me tell you! Worth every penny we paid) However you can also mount the BCV's and access the data. Honestly I don't see any reason why I wouldn't be able to install Oracle on this server and open up a read-only database on the BCV's. Except for maybe the fact that my employer practically chokes when Oracle quotes pricing. We are running HP/UX. If you want more specific info, email me directly and I'll be glad to answer questions. Have a great day... Lisa Rutland Koivu Oracle Database Administrator -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com
Re: Nologging
Yes you can issue the alter table nologging but it will only be relevant for certain operations not all UPDATE, DELETE, conventional path INSERT statements. Jim Reference the following I found on metalink: Doc ID: Note:1038660.6 Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 21-NOV-1997 Last Revision Date: 02-MAY-2000 Language: USAENG PURPOSE This article gives further information about the options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8. SCOPE APPLICATION For users requiring further information about these options. The options UNRECOVERABLE in Oracle7 and NOLOGGING in Oracle8 can be used when creating a table as select. They will send the actual create statement to the redo logs (this information is needed in the data dictionary). All rows loaded into the table during the create are not sent to the redo logs. With UNRECOVERABLE in Oracle7 any subsequent Data Manipulation Language (DML) command on the table WILL be sent to the redo logs. The UNRECOVERABLE option can be used in early versions of Oracle8 but will eventually be replaced by the NOLOGGING option. With NOLOGGING in Oracle8, although you can set the NOLOGGING attribute for a table, partition, index, or tablespace, NOLOGGING mode does not apply to every operation performed on the schema object for which you set the NOLOGGING attribute. Only the following operations can make use of the NOLOGGING option: alter table...move partition alter table...split partition alter index...split partition alter index...rebuild alter index...rebuild partition create table...as select create index direct load with SQL*Loader direct load INSERT All of these SQL statements can be parallelized. They can execute in LOGGING or NOLOGGING mode for both serial and parallel execution. Other SQL statements (such as UPDATE, DELETE, conventional path INSERT, and various DDL statements not listed above) are unaffected by the NOLOGGING attribute of the schema object. -Original Message- To: [EMAIL PROTECTED] [EMAIL PROTECTED]; Jwalski3 [EMAIL PROTECTED] Date: Wednesday, March 28, 2001 5:25 PM that has nothing to do with the question. But anyway, try ALTER TABLE NOLOGGING instead. oli [EMAIL PROTECTED] wrote Alter database noarchivelog; will change the entire database. see the following for detailed information: http://technet.oracle.com/docs/products/oracle8i/doc_index.htm HTH, Jim -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, March 28, 2001 4:37 PM I know it is possible when creating a table to specify no logging so that it doesn't generate redo logs. Is it possible, AFTER the table has already been created, to change it to nologging? Also this is a dev database that we don't care about doing any type of recovery and just want to do some quick loads -- is it possible to change the entire database to nologging? This is on Oracle 8.0.5. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- 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). -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Walski 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: A Basic PL/SQL Question
Hi ... you can go for UTL FILE feature of Oracle PL/SQL, it is very handy while handling large amount of data that DBMS_OUTPUT can't handle due to the buffer size constraints. Cheers, Bagchi. On Wed, 28 March 2001, "Miller, Jay" wrote: Another option is to create a table with a large varchar2 column and insert the data row by row. You can then spool a SELECT from that table to a file. e.g. create table hold_output (mytext varchar2(4000) tablespace ts_small; -Original Message- Sent: Tuesday, March 27, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Hi, This is my first attempt at writing a PL/SQL procedure. Everything works fine, except I have a firly large table I am running against. I am trying to display my output with DBMS_OUTPUT.PUT_LINE. I have set the buffer size to 100, apparently the maximum value, but it still isn't enough to print output for my entire table. Is there another way to display data? Or is there some way to increase the maximum? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO 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: Miller, Jay 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). __ 123India.com - India's Premier Portal Get your Free Email Account at http://www.123india.com -- 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: Oracle Books on Audio Tapes
Long drive to work ..eh ?? -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 6:21 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Books on Audio Tapes Is there any place where we can get Oracle books on Tape (Audio tapes or CD's) RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:RE: very urgent
Ajay's going to try that one too, and we are going to get 5 more mails ! :)) -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 29, 2001 4:27 AM To: Ajay Jain; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Re:RE: very urgent Ajay, Did you shutdown the database cleanly first? Then delete all the redolog files on the OS? If so, of course you can perform a "fake" recovery until cancel and open redo log on the database since all the datafile are offline and checkpoint has been performed. but if the redolog files are lost when the database is up and the instance crashed. I doubt if you can do the same thing. Winnie Hi here is how i did it I had a test database i deleted all the redolog files. including current. The database was in noarchivelog. But i think you can do for archivelog also. Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SVRMGR connect internal Connected. SVRMGR startup ORACLE instance started. Total System Global Area130801648 bytes Fixed Size 69616 bytes Variable Size78213120 bytes Database Buffers 52428800 bytes Redo Buffers90112 bytes Database mounted. ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u21/test/redo_1a.rdo' ORA-00312: online log 1 thread 1: '/u22/test/redo_1b.rdo' SVRMGR alter database open resetlogs ; alter database open resetlogs * ORA-01139: RESETLOGS option only valid after an incomplete database recovery SVRMGR recover database ORA-00283: recovery session canceled due to errors ORA-00264: no recovery required SVRMGR recover database until cancel ; Media recovery complete. SVRMGR alter database open resetlogs ; Statement processed. SVRMGR if you have lost ALL ( including the redolog file with status CURRENT in V$log, V$logfile) Redolog files then there is no way to open the database .. it is called single point of failure. you must recreate the database or restore from old backup see attached notes. Well Golly Gee Willikers, so THATS why we do backups, eh Tex? Let that be a lesson to ya varmit. Ya wanna go on the trail, you gotta take provisions or ya get stranded. Oh also make sure ya don't do stupid stuff like rounding up your redo logs on /tmp which likely gets cleared out on reboots. Kevin Little Database Cowboy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com --- Runbox Mail Manager - www.runbox.com Free online email application Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
identify which logs are need to start recovery
usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Source Code about Java Classes
Sergio, It doesn't seem to likely that Oracle will provide the source for their products. Jraed Who is this guy? Can't even spell his own name... -- 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: Does anyone know a link to 9i documentation?
Have you not tried at OTN, if it is 9i OAS then try http://technet.oracle.com/docs/products/forms/doc_index.htm HTH! Aleem -Original Message- Sent: Thursday, March 29, 2001 4:35 AM To: Multiple recipients of list ORACLE-L Subject:Does anyone know a link to 9i documentation? Thanks, Waleed -- 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: Abdul Aleem 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).