Re: Solved... Was: Boolean dates...
I hope the name of the column in the table - BDATE - doesn't stand for BOOLEAN DATE - otherwise you'll have to rename it too, to JDATE! ;-) [EMAIL PROTECTED] 24/10/2003 1:29:41 List... I finally found the answer about the infamous 'boolean dates'! (this was the term that my boss used when he told me about the dates... boolean dates). After receiving a lot of mails talking about Julian dates... I started to test in that way. I could find the following which is the solution to my problem. sql select bdate, to_date(bdate + 1721436, 'J') tdate sql from paam sql where rownum 6; BDATE TDATE --- 728464 01-JUL-95 728434 01-JUN-95 728403 01-MAY-95 728495 01-AUG-95 728283 01-JAN-95 As you can see the key is: 1721436 Thanks again to all! Best regards! JL __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Please note that your email address is known to AUSTRAC for the purposes of communicating with you. The information transmitted in this e-mail is for the use of the intended recipient only and may contain confidential and/or legally privileged material. If you have received this information in error you must not disseminate, copy or take any action on it and we request that you delete all copies of this transmission together with attachements and notify the sender. This footnote also confirms that this email message has been swept for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
setproperties on new ORDDOC gives ORA-6512?
Hello, I am attempting to convert the CLOBs in an existing table into ORDDOCs in a new table. I _seemed_ to be almost there. I allocated a new ORDDOC using INIT(), and used writeToSource() on the doc pointer to transfer the text (which I first converted to RAW). The application that accepts this now lists the new document, and displays the text contents. I now need to set the size (and MIME type, even though the app seems to understand that it's a text document). I called setproperties after writeToSource, and get a set of ORA-6510/ORA-6512 errors. (Included below) I'd really appreciate any advice! Thanx and regards, Arn. DEV1 l 1 DECLARE 2 3 srcRec arn5%ROWTYPE; 4 doc ORDSYS.ORDDOC; 5 ctx RAW(4000) :=NULL; 6 userArg RAW(4000); 7 len INTEGER; 8 comtxt VARCHAR2(32767); 9 comraw RAW(32767); 10 res integer; 11 doc2 ORDSYS.ORDDOC; 12 13 BEGIN 14 15 DELETE FROM assessment_document 16 WHERE DOC_NO = 0; 17 18 DELETE FROM media_document 19 WHERE DOC_NO = 0; 20 21 INSERT INTO assessment_document VALUES( 1, 0 ); 22 23 INSERT INTO media_document VALUES( 24 0, 'comment3.txt', 758197915, SYSDATE, 758197915, SYSDATE, 25 ORDSYS.ORDDOC.INIT() 26 ) RETURNING DOC_OBJ INTO doc; 27 28 SELECT * 29 INTO srcRec 30 FROM arn5 31 WHERE a=0; 32 33 len := LENGTH( srcRec.b ); 34 --res:= doc.openSource(userArg, ctx); 35 36 comtxt := dbms_lob.substr(srcRec.b); 37 doc.writeToSource(ctx, 1, len, utl_raw.cast_to_raw(comtxt)); 38 doc.setProperties(ctx,true); 39 40 COMMIT; 41* END; DEV1 / DECLARE * ERROR at line 1: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at ORDSYS.ORDDOC, line 337 ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at line 38 ** Please note that your email address is known to AUSTRAC for the purposes of communicating with you. The information transmitted in this e-mail is for the use of the intended recipient only and may contain confidential and/or legally privileged material. If you have received this information in error you must not disseminate, copy or take any action on it and we request that you delete all copies of this transmission together with attachements and notify the sender. This footnote also confirms that this email message has been swept for the presence of computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone storing their documents in the database with
Dennis, Thanx very much for the tip. I'm going through the doco at the moment - it looks pretty intense! Could be just what I'm looking for. [EMAIL PROTECTED] 18/1/2003 8:09:43 This message has been scanned by MAILSweeper. Arn - I don't know if this will help, but since I don't see where you've received any replies, you might take a look at a new Oracle9i feature, Database Workspace Management. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 10:34 PM To: Multiple recipients of list ORACLE-L This is a question that runs right up alongside the RTFM answer, but I have not gleaned this from the Oracle documentation. I have been able to successfully store a range of documents (Word, Excel, etc) in the database, using Intermedia and the ORDDoc object type and adapting the Photo Album demo JSP application that Oracle supplies. Equally, I have been able to retrieve them via the browser and either open them with a plug-in or save them locally. My problem now is that of maintaining them - change control, I guess. Now, when a document is retrieved from the database, it's only a copy, and thus changes to the copy need to be reloaded into the database, overwriting the current version. At this point, it appears I would need to build a versioning application that allows documents to be checked out, making it obvious to the user that changes to the local copy will *NOT* automatically be reflected in the database version, and later checked back in, updating the database version to match the local copy. Is this correct, or have I completely missed something a whole lot simpler? How are others handling updates to documents stored in the database? Thanx for any advice! Regards, Arn. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone storing their documents in the database with
Robert, Does this mean you're using it? If so, could you describe your use, and any caveats? [EMAIL PROTECTED] 21/1/2003 15:28:47 This message has been scanned by MAILSweeper. Workspace management - cool feature! RF -Original Message- Sent: Monday, January 20, 2003 8:49 PM To: Multiple recipients of list ORACLE-L Dennis, Thanx very much for the tip. I'm going through the doco at the moment - it looks pretty intense! Could be just what I'm looking for. [EMAIL PROTECTED] 18/1/2003 8:09:43 This message has been scanned by MAILSweeper. Arn - I don't know if this will help, but since I don't see where you've received any replies, you might take a look at a new Oracle9i feature, Database Workspace Management. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 10:34 PM To: Multiple recipients of list ORACLE-L This is a question that runs right up alongside the RTFM answer, but I have not gleaned this from the Oracle documentation. I have been able to successfully store a range of documents (Word, Excel, etc) in the database, using Intermedia and the ORDDoc object type and adapting the Photo Album demo JSP application that Oracle supplies. Equally, I have been able to retrieve them via the browser and either open them with a plug-in or save them locally. My problem now is that of maintaining them - change control, I guess. Now, when a document is retrieved from the database, it's only a copy, and thus changes to the copy need to be reloaded into the database, overwriting the current version. At this point, it appears I would need to build a versioning application that allows documents to be checked out, making it obvious to the user that changes to the local copy will *NOT* automatically be reflected in the database version, and later checked back in, updating the database version to match the local copy. Is this correct, or have I completely missed something a whole lot simpler? How are others handling updates to documents stored in the database? Thanx for any advice! Regards, Arn. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Freeman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Anyone storing their documents in the database with
This is a question that runs right up alongside the RTFM answer, but I have not gleaned this from the Oracle documentation. I have been able to successfully store a range of documents (Word, Excel, etc) in the database, using Intermedia and the ORDDoc object type and adapting the Photo Album demo JSP application that Oracle supplies. Equally, I have been able to retrieve them via the browser and either open them with a plug-in or save them locally. My problem now is that of maintaining them - change control, I guess. Now, when a document is retrieved from the database, it's only a copy, and thus changes to the copy need to be reloaded into the database, overwriting the current version. At this point, it appears I would need to build a versioning application that allows documents to be checked out, making it obvious to the user that changes to the local copy will *NOT* automatically be reflected in the database version, and later checked back in, updating the database version to match the local copy. Is this correct, or have I completely missed something a whole lot simpler? How are others handling updates to documents stored in the database? Thanx for any advice! Regards, Arn. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays
But how long did it take to wrap??? :-) [EMAIL PROTECTED] 21/12/2002 0:03:50 This message has been scanned by MAILSweeper. Speaking of house ... Congratulations !! Yesterday my wife and I celebrated our 5th wedding anniversary. I was looking for what gift to give on a 5th anniversary. So my boss googled for a while and said ... he found the gift and a nice gift as well. He says, traditional gift is wood, so just give your wife the house you built. That was easy ... no shopping involved and she already loves the gift. Happy Holidays everyone !! 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! -Original Message- Sent: Thursday, December 19, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Well I've got another excuse. We just moved into our newly constructed house. I tell the kids that they get their own room for Christmas and they just say, Oh Dad! So even though we're still living out of boxes I have to got get more junk and put it in fancier boxes... very strange. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Passing in NULL via SQL ACCEPT
This is because SQLPlus does the substitution before executing the block, and thus the entered value is inserted into the code as a literal, not as a bind variable. eg, accept x prompt 'Enter x:' begin if x = 2 then do_something; end if; end; If the user enters 100, then the block becomes: begin if 100 = 2 then do_something; end if; end; However, if the user doesn't enter anything, x is replaced with nothing, leaving the block as: begin if = 2 then do_something; end if; end; which produces an execution error. One way around this is to ensure there's always a correct argument in that position, eg: begin if 'x' = '2' then do_something; end if; end; For null entry, this would give: begin if '' = '2' then do_something; end if; end; which works. HTH -a [EMAIL PROTECTED] 14/3/2002 1:43:24 This message has been scanned by MAILSweeper. I'm writing an anonymous PL/SQL block that accepts various input from SQL*Plus via ACCEPT commands. I then take the SQL input and use it in the block, usually by assigning it to a PL/SQL variable. If no value is specified on the ACCEPT line, it appears that nothing is passed into PL/SQL, not even NULL. I tried using NVL(variable,0) to reassign the supposed NULL to a 0, but the program returns an error that nothing exists in place of variable. Any ideas how to catch this null, which I want to be a viable option (e.g., if the varible is NULL then perform certain operations). Thanks much -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Sql question
command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Answer to SCOTT/TIGER
v7's DBA manual also had a fun entry under Dirty reads in the index... [EMAIL PROTECTED] 31/1/2002 6:10:44 This message has been scanned by MAILSweeper. Anybody ever notice in the Index of v6's DBA manual had an entry for Bert and Ernie and a page number, although there was no reference for Bert or Ernie on the page? Of course, what could compare with Digital's HELP DATATRIEVE WOMBAT ? Or VMS v4's C Language manual with all those gay references... printf(I saw four men with moustaches on Christopher Street!\n); Ah, those were the days... back when people still had a sense of humor... Bambi. (Still living in the past where the rent is cheaper) -Original Message- Sent: Wednesday, January 30, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Here is the answer: SCOTT, is the last name of Bruce Scott, who was the early Developer working with Bob Miner (Larry's Technical Partner in 1980), TIGER, was the name of Bruce's cat. Source: Oracle8i for Dummies Foreword by Ned Dana, who worked with Bruce and Bob in rewriting the Oracle Version 3.0 in C, back then. After all, this book has some neat things :) - Kirti -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: SCOTT/TIGER
So who was SYS, and why on earth did s/he name his/her pet CHANGE_ON_INSTALL??? :-) [EMAIL PROTECTED] 24/1/2002 12:00:27 This message has been scanned by MAILSweeper. The name I was given is Scott Gossett. My team leader and one of our team members took the advanced seminars last year, and their instructor was Scott, and he admitted his notoriety. -Original Message- Sent: Wednesday, January 23, 2002 4:00 PM To: Multiple recipients of list ORACLE-L there are several instructors named Scott how do you know which one it is or even if it's one of the instructors? --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Ok...it's true. Take the Oracle Technical seminars and you too may get to meet Scott, Live and In Person. Unfortunately, Tiger is waiting for Scott at the Rainbow Bridge, but Scott is still there (at least he was last year...you know how Oracle's been lately). -Original Message- Sent: Wednesday, January 23, 2002 10:26 AM To: Multiple recipients of list ORACLE-L I was once told with certainty from an Oracle instructor that Scott was an early developer, and Tiger was his cat. But without actually meeting Scott I take this with a grain of salt. I expect there are many urban legends surrounding this. Jim -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Installing Extra Oracle Features After The Initial Install
[EMAIL PROTECTED] 4/1/2002 5:05:29 If I do a customized install, is it going to fowl up the stuff that has already been installed? Only if you're chicken. Or act like a turkey. (Sorry for this poultry contribution :-) ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: how delete myfile* in unix
two ways: $ rm myfile* or $ rm myfile\* [EMAIL PROTECTED] 13/12/2001 13:30:18 This message has been scanned by MAILSweeper. Hi, I accitentaly create a file with * $ myfile* $ ls myfile1 myfile2 myfile3 myfile* how to delete myfile* without delete the rest of the file * here is not a wildcard but system see this as a wildcard Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard 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). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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).
Costs in explain plan
Hi, Can you compare the costs that are displayed in explain plan output? For example, I have a query that contains a merge join. The cost reported in the explain plan is 134. By including a hint to use a nested loop instead, the cost becomes 1160. Does this mean the merge join plan is more efficient, despite generally being considered a less efficient join method than a NL? Thanx -a ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Out put in a single line
Not knowing exactly how the SQL Looks in v$logmnr_contents, I hazard a guess that because the sql_redo column is VARCHAR2(4000), it contains the entire SQL statement? (ie, the SQL statement is not split over multiple rows in the table as it is in, say, USER_SOURCE? If that's the case, then I'd guess that your problem is that the line length in SQL*Plus is too short. If you issue a set linesize 4000 and rerun your query to spool the statements out, each statement should be on a single line. hth -arn [EMAIL PROTECTED] 11/12/2001 13:50:19 This message has been scanned by MAILSweeper. Hi lists, Solaris: 2.6 Oracle 8i I am trying to extract insert statements from archive log files using log miner. All the statements are collected into a spool file. We ran them against another database (test schema). But the insert statement taken from this arch logs is split into multiple lines. I have to manually open the spool file in vi and remove unwanted spaces and I am making it into single line. Then only the insert is successful. There are around 20,000 insert statements in that spool file. You know how much time it will take to modify each statement. Does anybody throw some light how can I make the insert statements into a single line...? or is there a way to get the data in a single line from archive log. select sql_redo from v$logmnr_contents; If this is finished, we can move to production. Hope u can understand it is urgent. Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Change sysdate in database to a future date
SYSDATE is determined by the operating system's date. You can't change the current date and time in Oracle; you have to change it at the OS level. If, however, your aim is to determine things like what's the date one week from today, then you can use Oracle's date arithmetic functionality (eg, SYSDATE + 7 to determine the date one week from today). hth -arn [EMAIL PROTECTED] 7/12/2001 14:45:21 This message has been scanned by MAILSweeper. Hi Gurus, I need to change the sysdate in the database to a future date. Does anyone know the command to do it ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Problem importing objects to different tablespace
George, I've just tried the process as you've listed below (including dropping the exported table before importing again) and it worked fine without needing to precreate the table in the new tablespace. This is on Oracle 8.1.7. I noticed that the DDL in the export file included the old tablespace, but it was still created in the new tablespace OK. My first attempt failed, because I forgot to change the user's default tablespace to the new one before importing, but once that was done, it was successful. FYI. -arn [EMAIL PROTECTED] 28/11/2001 10:32:33 This message has been scanned by MAILSweeper. Funny because Oracle has explicitly stated that you can actually import a user's objects to it's new default tablespace as long as you make sure that the user doesn't have any quota or privs on the old tablespace. George -Original Message- Sent: Tuesday, November 27, 2001 1:00 PM To: Multiple recipients of list ORACLE-L The default tablespace is only used whenever there is no tablesapce parameter in the crate and alter table/index statements. Since the export always have tablespace parameter with the create table/index statement, your import method definitely will fail. You can change the tablespace for the segment by creating the segment in the desired tablesapce first, then import. Jun -Original Message- Sent: Tuesday, November 27, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error space quota exceeded for tablespace old tablespace for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Feng, Jun 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: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public
Re: [Q] what difference between count(0), count(1) and
As I understand it, count(*) counts all rows. Anything other than * is treated as an expression and it returns the number of rows where that expression evaluates to not null. So what Deepak said below about count(col1) giving the count of non-null instances of col1 is correct. That also means that count(0), count(1), etc should behave the same as count(*), as 0, 1, etc are not null. Now, is count(*) less efficient in execution than count(1)? I've been asked this before, and I don't know. I would've thought count(*) and count(1) would be the same, execution-wise. Is this correct? -a [EMAIL PROTECTED] 25/10/2001 11:30:17 This message has been scanned by MAILSweeper. Thank you for answer. How about count(0)? From: Deepak Thapliyal [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: [Q] what difference between count(0), count(1) and count(*) Date: Wed, 24 Oct 2001 11:41:11 -0800 i think count(*) gives count of all columns .. where as count(col1) gives count for col1 ignoring nulls in col1 Deepak --- aaa aaa [EMAIL PROTECTED] wrote: Can anyone tell me what is difference between : select count(*) ... from .. select count(0) ... select coun (1) ... select count(2) ... Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: aaa aaa 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!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal 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/intl.asp - - Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Rash of shared memory errors
Thanx, everyone, for replying so quickly! We're on 8.1.7.1 (sorry for omitting that in my OP). I'll look for the patch straight after this. Rahul and Connor, when you say the cause may be that the application is not using bind variables, do you mean that the application is using dynamic SQL, and thus almost every call to the DB during application execution is different, thus limiting query reuse? If that's the case, then this is not the cause in our app, as we don't use dynamic SQL at all. However, if you mean another way of not using bind variables, but in static queries, then could you please explain how this could be done, so I can check our app? Thanx very much. -arn [EMAIL PROTECTED] 21/9/2001 23:05:22 This message has been scanned by MAILSweeper. i would take a look at the application before increasing the size -- From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, September 21, 2001 7:50 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rash of shared memory errors Arn A shared pool size of 16 Meg is not large enough. This error clearly indicates that you are out of memory. It may be larger than your test and maintenance db, but it is not large enough for your developers. I don't know about you, but I have more developers on my Dev instances than testers on my testing instance! My shared pool value in my Dev instance is 80Meg, and I never get this error. Try increasing your shared pool to at least 50 Meg and see if the problem goes away. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 21, 2001 3:55 AM To: Multiple recipients of list ORACLE-L Hi, Just recently, we have been frequently receiving errors like the following in our development database: ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer) The size of our shared pool is not too small (I think); it's larger than our test and maintenance databases, for example. shared_pool_reserved_sizestring 80 shared_pool_size string 1600 What could be causing this level of frequent fragmentation? We have been developing a new application in the database, but this has been ongoing for some months; the errors appeared only in the last week or so. What should I be looking for to solve this? Thanx for any advice. -arn ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Rash of shared memory errors
Hi, Just recently, we have been frequently receiving errors like the following in our development database: ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer) The size of our shared pool is not too small (I think); it's larger than our test and maintenance databases, for example. shared_pool_reserved_sizestring 80 shared_pool_size string 1600 What could be causing this level of frequent fragmentation? We have been developing a new application in the database, but this has been ongoing for some months; the errors appeared only in the last week or so. What should I be looking for to solve this? Thanx for any advice. -arn ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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).
Controlling transactions when JDBC connection closed?
We're reusing a set of Java classes from an old application in a new application. The old application used a PC database; the new one is using Oracle. It appears that the PC database implicitly rolled back transactions if a connection to the database was closed. However, with Oracle, is appears that when we close a JDBC connection, the current transaction is implicitly committed. I understand that these classes *should* be explicitly controlling their transactions, and committing or rolling back before closing the connection to the database, and we will have to fix these classes to do so. However, I would also like to know if it's possible to change this behaviour of Oracle of implicitly committing upon close. Is there a JDBC configuration file or something like that? This is Oracle 8.1.7, in a JRUN environment, if that's any help. (As you can tell, this Java stuff is not my forte...) Thanx for any advice. -ak ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: completely off-topic question...
How do the two versions differ? [EMAIL PROTECTED] 5/8/2001 4:32:27 J.K. Rowling (does Harry Potter count as science fiction?) American and British versions, as well as the cassettes of all 4 books (that was my birthday present from my parents last year) ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arn Klammer 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: Recovery from noarchive db corrected
The actual archiving of log files itself should not impact the performance of the insert jobs, unless the archiving process is slow enough to cause the database to pause while a log is archived so it can be reused. The only other reason why the developers wouldn't want it is if the space required to store the archived logs impinges on their development space; in that case, you'd have a case for getting more storage. Either way, the inability to recover a database due to the absence of logs is far worse! -a [EMAIL PROTECTED] 6/4/2001 14:45:28 This message has been scanned by MAILSweeper.The developer application running huge batch inserting data into database,that is what they told me, if you are me what you will do?-Original Message-TestaSent: Friday, 6 April 2001 11:55 AMTo: Multiple recipients of list ORACLE-Lassuming you're the dba, since when does the developer dictaterecoverability to a DBA about a database.sounds like a role problem there.joeSinardy Xing wrote: Our Developer prefer the archive off, I can't change that anymore :( -Original Message- Sent: Thursday, 5 April 2001 8:54 PM To: LazyDBA mailing list Turn archiving on. -Original Message- From: Sinardy Xing [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 05, 2001 4:57 AM To: LazyDBA mailing list Subject: Recovery from noarchive db corrected Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any technique to share ? Sinardy 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: 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.comPerforming Remote DBA Services, need some backup DBA support?For Sale: Oracle-dba.com domain, its not going cheap but feel free toask :)--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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Qualifying columns to improve performance?
At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine thetable to which each column belongs. Is this still a valid rule? Does this apply to statements in PL/SQL procedures/packages? Or are they different, because they are checked at compile time? -a ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: sql query
It's because Oracle dates are stored as a real number, where the integer portion represents the date and the decimal portion represents the time. This means you can do date arithmetic simply by adding or subtracting numbers to a date, where 1.0 = one day, 2.0 = two days, etc. This means that, as far as fractions of a day are concerned, 0.5 = half a day = 12 hours, 1/24 = one hour, 1/(24 * 60) = 1 minute and 1/(24 * 3600) = 1 second. In your example, 5/(24*3600) = 5 seconds that are being subtracted from the current date/time. (This representation is really handy - to convert a date/time to just a date (no time portion), you just have to TRUNC() the date.) -a [EMAIL PROTECTED] 3/4/2001 14:00:20 This message has been scanned by MAILSweeper.I found a query to get the time 5 seconds less than the current time asselect to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual;I am really not sure as to why 24*3600 is used for.Can anyone tell me why it is used.ThanksRavindra-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **
Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
How about having the books recited by Larry Ellison himself? With the tranquil sounds of his japanese garden asbackground? Andall in haiku? "Instance will not start The logs have been deleted Have you a backup?" -a [EMAIL PROTECTED] 30/3/2001 6:16:47 This message has been scanned by MAILSweeper.Rachel Carmichael wrote: only if I can get the microphone on my desktop to work... did some upgrading over the weekend (can you say broadband wireless network?) and somehow lost the mike in the process...hmmm DBA101 in the dulcet tones of our very ownORACLE goddess? sounds [ok ok i know, fish pun.;-)] like a best sellerto me.;-)--Bill Thater Certifiable ORACLE DBATelergy, 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **