Re: Oracle 9.2 Stability Feedback Requested
All the bugs? Possible? Perhaps... Reality? Nope. The crippling bugs with SMU appear (at first glance) to be fixed in 9.2, but there is no shortage of other bugs. The first one I found was with many queries against the data dictionary being 70-180 times slower! I'm running 9.2.0.1 on Linux - exclusive and RAC - but not yet production. On the 9.2.0.1 RAC nodes, I'm getting tons of trace files with CMInit warnings, but support said Don't worry. Be happy. Its OK Searching for patches for 9.2.0.1 on Linux, I get 22 hits. Most are related to some bug ;) Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 2:13 PM Dave - Can you post the bug number? I searched Metalink and couldn't find any matches for 9.2. Is it possible that Oracle fixed the bugs by 9.2? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 20, 2002 12:57 PM To: Multiple recipients of list ORACLE-L Sam, The only problem I have come acroos is using SMU [ system managed undo ] instead of rollback segments Check metalink under bug database Dave Clarke. Cisco Systems - Amsterdam -Original Message- Sent: Tuesday, August 20, 2002 6:39 PM To: Multiple recipients of list ORACLE-L Hi Can anybody tell me what the track record has been for Oracle 9.2? Has it been reliable and stable? We have clients asking us about Oracle 9.2 and I would like to gather some experience from the field on how reliable it has been. Most of our clients are running Windows NT/2000, some are running UNIX. Appreciate any feedback anybody can provide. Thanks a lot. Sam Bootsma, OCP Technical Support Analyst [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Bootsma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Dave Robert Clarke (daclarke) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Shutdown Immediate Hanging
My recommendation #1 would be not to shutdown at all. Oracle spent all that time and money devising wonderfully complex memory management (which they pass on to us as license dollars) so shutting down is like throwing money in the toilet.. My recommendation #2 is (for those rare times when you need to shutdown) to not use shutdown immediate - because they got the name wrong :-) If you need to shutdown, I'd just do: alter system checkpoint; shutdown abort hth connor --- Steve Perry [EMAIL PROTECTED] wrote: MessageI hope somebody can help me with this shutdown problem. There's 2 questions unless: how to troubleshoot a stalled shutdown and the best way to deal with it. #1 - Database hangs during shutdown We have several instances running 8.1.7.3 on Win2k and continue to have intermittent shutdown problems. The shutdown never completes. Here's are the steps used to stop the database 1.) Stop the application servers 1.) run a kill session script to kill all remaining sessions except the one running the script 2.) issue shutdown immediate and hope it shuts down. At this point, the database closes but it never dismounts. We never receive the Completed: ALTER DATABASE DISMOUNT Is there anything I can do to diagnose the problem at this point? After 15 minutes, Arcserve backs up the files to tape (delay field in arcserve job). After the backup is complete, the database startup script is run. The alert log says the startup is normal, but no connections are allowed into the database. I either have to do a shutdown abort or stop the service and then I can start the database. I wrote a script to detect the shutdown hangs that will page me, do a shutdown abort, startup and then shutdown immediate (before the backup job starts) There's not much I can do when it stalls and I don't mind running the script if it won't corrupt my database. Is there a better way to handle this? I checked metalink and opened a tar. Oracle said it was a security dll issue with MS and that I should change the scripts to shutdown the service instead of using svrmgrl or sqlplus. That was fine until I realized that stopping the service will do a shutdown immediate. If the database doesn't complete before the ora_SID_shutdown_timeout value, it does a shutdown abort (or equivalent). Thanks, Steve = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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).
how to startup in restricted mode ?
Guys, i am on 8.1.6 / win2k . how do i startup my DB in restricted mode for maintenance purpose ? i dont want my users to connect during this time. Is it STARTUP RESTRICT ? i did it . but still users are able to connect . can DBAs connect , when DB is started in this mode ? plz correct me if i am wrong . TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: move table to differnt datafile
Thanks a lot Irfan
RE: how to startup in restricted mode ?
Is it STARTUP RESTRICT ? Ya i did it . but still users are able to connect . Check the users who can connect. They will have RESTRICTED SESSION system privilege can DBAs connect , when DB is started in this mode ? Ya. DBA role has all the system privileges granted with admin option. So RESTRICTED SESION comes automatically Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: java.sql.SQLException: Io exception: Connection reset by peer: so
It comes because of the network problems. -Original Message- Sent: Thursday, August 22, 2002 12:24 AM To: Multiple recipients of list ORACLE-L so Hello List, Does anybody there know the following error message and how to resolve it? java.sql.SQLException: Io exception: Connection reset by peer: socket write error Environment classes12.zip Oracle 8.1.6.3 Solaris 2.8 Thanks, Mike ** This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege. Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer. Sempra Energy Trading Corp. (SET) is not the same company as SDGE or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Wu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Statement to check the last actions done.Urgent!
Hello, is there any SQL statement to see what SQL have been performed over a database??? Inserts, deletes, etc. TIA -- Beatriz Martínez Jiménez Ingeniera Informática Tfno: 983 546646 [EMAIL PROTECTED] Fundación CIDAUT Centro de Investigación y desarrollo en Automoción Parque Tecnológico de Boecillo, p.209. 47151 Boecillo, Valladolid. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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 to startup in restricted mode ?
The RESTRICTED SESSION privilege allows users to logon when the database is opened in restricted mode. You should revoke this privilege. The DBA role contains this privilege. -Rich -Original Message- Sent: Thursday, August 22, 2002 5:03 AM To: Multiple recipients of list ORACLE-L Guys, i am on 8.1.6 / win2k . how do i startup my DB in restricted mode for maintenance purpose ? i dont want my users to connect during this time. Is it STARTUP RESTRICT ? i did it . but still users are able to connect . can DBAs connect , when DB is started in this mode ? plz correct me if i am wrong . TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Gesler, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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 to startup in restricted mode ?
Don't startup listener process. JP On Thursday 22 August 2002 11:03, you wrote: Guys, i am on 8.1.6 / win2k . how do i startup my DB in restricted mode for maintenance purpose ? i dont want my users to connect during this time. Is it STARTUP RESTRICT ? i did it . but still users are able to connect . can DBAs connect , when DB is started in this mode ? plz correct me if i am wrong . TIA. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Statement to check the last actions done.Urgent!
V$SQL Beatriz Martínez Jiménez wrote: Hello, is there any SQL statement to see what SQL have been performed over a database??? Inserts, deletes, etc. TIA -- Date: Wednesday, Aug 21,2002 !! !! ! For people who like peace and quiet: ! !a phoneless cord. ! !! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dizzy74 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: PL/Sql question
Dennis, I'd guess that the developer did not try it correctly. Ask to see the code. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Tom - The developer reports that he tried this but it didn't work. The third position is still a space value. Thanks to everyone for the good replies. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 21, 2002 3:13 PM To: '[EMAIL PROTECTED]' Cc: DENNIS WILLIAMS Dennis, Try changing your insert statement to: insert into JOBOFFERFACT_LOAD (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME, PACKAGEPRICE, PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE, PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES (LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,' '), TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE, PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ; Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 2:04 PM To: Multiple recipients of list ORACLE-L In response to the questions for more details, here are the PL/SQL code and SQL Loader control file. Everything is varchar2(2), explicitly defined as such in PL/SQL. Thanks for all the nice replies. PL/SQL snippets ...snip... marketingcodeVARCHAR2(3); ...snip... FILELOCATION := '/usr/users/madmload/text_files'; OPEN_MODE:= 'r'; FILENAME := 'prodload.txt'; FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE ); ...snip... UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING); marketingcode := substr(outputstring, 21, 3); ...snip... insert into JOBOFFERFACT_LOAD (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME, PACKAGEPRICE, PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE, PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES (LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE, PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ; Sql*Loader script LOAD DATA INFILE '/usr/users/madmload/joblid.txt' BADFILE '/usr/users/madmload/jobload.bad' APPEND INTO TABLE JOBFACT ( JOBNBR POSITION(1:10) CHAR, LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL, MDRPRIMARYIDPOSITION(21:28) CHAR, MARKETINGCODE POSITION(29:31) CHAR, SUBPROGRAMCODE POSITION(32:32) CHAR, TERRITORYCODE POSITION(33:34) CHAR, SUBTERRITORYCODEPOSITION(33:36) CHAR, SELLINGMETHODCODE POSITION(37:37) CHAR, BIDIND POSITION(38:38) CHAR, PDKIND POSITION(39:39) CHAR, PDKPARTNBR POSITION(40:44) CHAR, RETAKEIND POSITION(45:45) CHAR, PLANTCODE POSITION(46:46) CHAR, PLANTRECEIPTDATEPOSITION(47:56) DATE /MM/DD NULLIF PLANTRECEIPTDA, PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL, PLANTRECEIPTMONTH POSITION(52:53) INTEGER EXTERNAL, PHOTOGRAPHYDATE POSITION(57:66) DATE /MM/DD NULLIF PHOTOGRAPHYDATE=BLANKS, SHIPDATEPOSITION(67:76) DATE /MM/DD NULLIF SHIPDATE=BLANKS, SHOTQTY POSITION(77:80) INTEGER EXTERNAL, SHIPPEDPACKAGEQTY POSITION(81:84) INTEGER EXTERNAL, PAIDPACKAGEQTY POSITION(85:88) INTEGER EXTERNAL, UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL, XNOPURCHASEQTY POSITION(93:96) INTEGER EXTERNAL, CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL, CASHRETAINEDAMT POSITION(106:114) DECIMAL EXTERNAL, ACCTCMSNPAIDAMT POSITION(115:123) DECIMAL EXTERNAL, ESTACCTCMSNAMT POSITION(124:132) DECIMAL EXTERNAL, CHARGEBACKAMT POSITION(133:141) DECIMAL EXTERNAL, SALESTAXAMT POSITION(142:150) DECIMAL EXTERNAL, TERRITORYCMSNAMTPOSITION(151:159) DECIMAL EXTERNAL, TERRITORYEARNINGSAMTPOSITION(160:168) DECIMAL EXTERNAL, EXPECTEDCASHAMT POSITION(169:177) DECIMAL EXTERNAL, SOURCEFISCALYEARCONSTANT '2003', PROOFPOSE POSITION(178:178) DECIMAL EXTERNAL, PROOFCOUNT POSITION(179:182)DECIMAL EXTERNAL, SEASONDESC POSITION(183:183)DECIMAL EXTERNAL, EXTRACTDATE POSITION(184:193) DATE /MM/DD NULLIF EXTRACTDATE=BLANKS, FUNPACKJOB
OT FW: Intersting
-Original Message- Sent: Thursday, August 22, 2002 2:59 PM Subject:Intersting Interesting conversation between Camels A mother and a baby camels were lazing around, and suddenly the baby camel ask... Baby : Mother, mother, can I ask you some question? Mother: Sure! why son, is there something bothering you? Baby : Why do camel have humps? Mother: Well son, we are desert animals, we need the humps to store water and we are known to survive without water. Baby : Okay, then why are our legs long and our feet rounded? Mother: Son, obviously they are meant for walking in the desert. You know with these legs I can move around the desert better than anyone...! Said the mother proudly. Baby : Okay, then why are our eye lashes long? Sometimes it is bothering my sight. Mother: My son, those long thick eye lashes are your protective cover. They help to protect your eyes from the desert sand and wind. Said mother camel with eyes brimming with pride. Baby : I see. So the hump is to store water when we are in the desert, the legs are for walking through the desert and these eye lashes protects my eyes from the desert. Then what the hell are we doing here in the zoo??? MORAL OF THE STORY: SKILLS, KNOWLEDGE, ABILITIES AND EXPERIENCES ARE ONLY USEFUL IF YOU ARE AT THE RIGHT PLACE -- 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).
RE: Statement to check the last actions done.Urgent!
Hi tia, You can see it through the V_$SQL table. For this you need to get the Last_SQL_Address and Last_SQL_HASH value from the v_SEssion table. Once you have these just query v_$SQL table with the 2 params. Regards Savio -Original Message- Sent: Donnerstag, 22. August 2002 13:33 To: Multiple recipients of list ORACLE-L Hello, is there any SQL statement to see what SQL have been performed over a database??? Inserts, deletes, etc. TIA -- Beatriz Martínez Jiménez Ingeniera Informática Tfno: 983 546646 [EMAIL PROTECTED] Fundación CIDAUT Centro de Investigación y desarrollo en Automoción Parque Tecnológico de Boecillo, p.209. 47151 Boecillo, Valladolid. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Simplicio Noronha, Savio INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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).
Problem with Outer Join
Hi, In our employee's attendance application the attendance data is stored in table 'A' including employee ID and attendance date time. Another table 'B' has one column with dates of current year (365 records). For the sake of simplicity, other fields are ignored. Table: A Employee_ID Attend_date (date with time) Table: B year_date (one record each for a day of current year i.e., 365 records) In a report (single employee at a time) showing all dates of the year and in front of it whether the employee was present or not we are running the following query. Assume that table A has 15 records of employee ID 123, the query should return 365 records with 15 records telling the time but it returns 15 records only. SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+), 'dd-mm-') and employee_id = 123; To my understanding this is perhaps because of the filter employee_ID=123. What would be the query to get the required result? TIA! Aleem -- 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).
RE: Problem with Outer Join
Aleem, Your query should be: SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date,'dd-mm-') (+) The above says to return all records from the year_date table and , oh, by the way, return any records in the employee table where dates match. A better way to do this would be: WHERE trunc(year_date) = trunc(attend_date) (+) The Trunc command simply strips all time from date columns. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Hi, In our employee's attendance application the attendance data is stored in table 'A' including employee ID and attendance date time. Another table 'B' has one column with dates of current year (365 records). For the sake of simplicity, other fields are ignored. Table: A Employee_ID Attend_date (date with time) Table: B year_date (one record each for a day of current year i.e., 365 records) In a report (single employee at a time) showing all dates of the year and in front of it whether the employee was present or not we are running the following query. Assume that table A has 15 records of employee ID 123, the query should return 365 records with 15 records telling the time but it returns 15 records only. SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+), 'dd-mm-') and employee_id = 123; To my understanding this is perhaps because of the filter employee_ID=123. What would be the query to get the required result? TIA! Aleem -- 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). -- 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).
utl_file_dir vs create directory
Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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).
Strange Data issue.....
Title: Strange Data issue. Hello Gurus, I have a problem which I hope someone can help me with. I am trying to clean up some data on a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. The select used is : select race||','||gender||','||count(*) from pers group by race, gender; The result is as follows: A,F,62 A,M,613 A,M,35 A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 The problem is that the result returns double Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
One potential problem in 9.2 ... was RE: Oracle 9.2 Stability Fee
So far we haven't found our problem in a testing environment it is 9201 on a RAC cluster. We are having difficulty getting 6i reports server to run, but no major problems. Okay here is something I will be investigating ... something for you all to think about. The query is something like this ... select col_1, col_2, nvl(col_3,'X') col_3 from table_a union select col_1, col_2, 'X' col_3 from table_b / This is of course not the complete query but just to give you all an idea. What happens is col_3 is actually defined as varchar2(2) in the database. Sometimes the value for this column be null, single character or two characters. This is working fine in our 8161 database, oracle forms passes parameter to a database packaged procedure which has this code. When we moved this to 9.2, the query started giving ORA-6502 errors. When removed col_3 from the query, things were just fine. Here is the catch, after playing with it for about 15 minutes, I changed the nvl clause to NVL(col_3, 'XX') col_3 thing worked as before, no errors. What gives?? I will try to test this again, but has any of you encountered this before? BTW yesterday I searched on Metalink for all bugs reported in 9.2.0.1 and fixed in 10.0.0.0, there were 7 bugs reported to be fixed in 10i. Some of them may be back ported, but isn't is good to know? 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! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Problem with Outer Join
Tom, I think by the post he wants to limit result set by employee_id for ex. employee_id=123 Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Problem with Outer Join Sent by: [EMAIL PROTECTED] 08/22/2002 08:58 AM Please respond to ORACLE-L Aleem, Your query should be: SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date,'dd-mm-') (+) The above says to return all records from the year_date table and , oh, by the way, return any records in the employee table where dates match. A better way to do this would be: WHERE trunc(year_date) = trunc(attend_date) (+) The Trunc command simply strips all time from date columns. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Hi, In our employee's attendance application the attendance data is stored in table 'A' including employee ID and attendance date time. Another table 'B' has one column with dates of current year (365 records). For the sake of simplicity, other fields are ignored. Table: A Employee_ID Attend_date (date with time) Table: B year_date (one record each for a day of current year i.e., 365 records) In a report (single employee at a time) showing all dates of the year and in front of it whether the employee was present or not we are running the following query. Assume that table A has 15 records of employee ID 123, the query should return 365 records with 15 records telling the time but it returns 15 records only. SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+), 'dd-mm-') and employee_id = 123; To my understanding this is perhaps because of the filter employee_ID=123. What would be the query to get the required result? TIA! Aleem -- 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). -- 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:
RE: Strange Data issue.....
group by race||','||gender||','||count(*) might be better. -Message d'origine- De: Denham Eva [mailto:[EMAIL PROTECTED]] Date: jeudi 22 août 2002 14:59 À: Multiple recipients of list ORACLE-L Objet: Strange Data issue. Hello Gurus, I have a problem which I hope someone can help me with. I am trying to clean up some data on a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. The select used is : select race||','||gender||','||count(*) from pers group by race, gender; The result is as follows: A,F,62 A,M,613 A,M,35 A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 The problem is that the result returns double Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bernard, Gilbert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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).
nt password change and OEM
On NTs that are not a Primary or Backup Domain controller, OEM install instructions were to create a local user id. This works with no problems. However, we have just implemented a policy wherein all NT account passwords now change every 90 days. Therefore, looking for suggestions on how to change the NT password and OEM passwords on a regular basis. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216) 781-4204
RE: Shutdown Immediate Hanging
Title: Message Steve, Recently I got same problem and I have resolved it. This will happen if you setup INITIAL and NEXT extent size very small for TEMPORARY tablespace. Look at the following information: http://metalink.oracle.com and look for the following DOC ID: DOC ID: 61997.1 DOC ID: 1076161.6 I created new LOCALLY MANAGEDTEMPORARY tablespace which handles better than DICTIONARY tablespace: CREATE TEMPORARY TABLESPACE temp TEMPFILE '/d05/oradata/prod/temp01.dbf' SIZE 2048M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp; Muthar Ahmed DBA -Original Message-From: Steve Perry [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:13 PMTo: Multiple recipients of list ORACLE-LSubject: Shutdown Immediate Hanging I hope somebody can help me with this shutdown problem. There's 2 questions unless: how to troubleshoota stalledshutdown and the best way to deal with it. #1 - Database hangs during shutdown We have several instances running 8.1.7.3 on Win2k and continue to have intermittent shutdown problems. The shutdown never completes. Here's are the steps used to stop the database 1.) Stop the application servers 1.) run a kill session script to kill all remaining sessions except the one running the script 2.) issue shutdown immediate and hope it shuts down. At this point, the database closes but it never dismounts. We never receive the "Completed: ALTER DATABASE DISMOUNT" Is there anything I can do to diagnose the problem at this point? After 15 minutes, Arcservebacks upthe files to tape (delay fieldin arcserve job). After the backup is complete, the database startup script is run. The alert log says the startup is normal, but no connections are allowed into the database. I either have to do a shutdown abort or stop the service and then I can start the database. I wrote a script to detectthe shutdownhangsthat will page me, do a shutdown abort, startup and thenshutdown immediate (before the backup job starts) There's not much I can do when it stalls and I don't mind running the script if it won't corrupt my database. Is there a better way to handle this? I checked metalink and opened a tar. Oracle said it was a security dll issue with MS and that I should change the scripts to shutdown the service instead of using svrmgrl or sqlplus. That was fine until I realized that stopping the service will do a shutdown immediate. If thedatabase doesn't complete before the ora_SID_shutdown_timeout value, it does a shutdown abort (or equivalent). Thanks, Steve
RE: Strange Data issue.....
Title: Strange Data issue. Denham, Your "group by" does not match what you are selecting, thus the results are wrong. Change your query as follows: select race||','||gender,count(*) from pers group by race||','||gender Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: Strange Data issue. Hello Gurus, I have a problem which I hope someone can help me with. I am trying to clean up some data on a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. The select used is : select race||','||gender||','||count(*) from pers group by race, gender; The result is as follows: A,F,62 A,M,613 A,M,35 A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 The problem is that the result returns double Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Problem with Outer Join
Rick, That's not how I read it. He wants all dates returned showing whether an employee was present or not. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 22, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Tom, I think by the post he wants to limit result set by employee_id for ex. employee_id=123 Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Problem with Outer Join Sent by: [EMAIL PROTECTED] 08/22/2002 08:58 AM Please respond to ORACLE-L Aleem, Your query should be: SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date,'dd-mm-') (+) The above says to return all records from the year_date table and , oh, by the way, return any records in the employee table where dates match. A better way to do this would be: WHERE trunc(year_date) = trunc(attend_date) (+) The Trunc command simply strips all time from date columns. Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L Hi, In our employee's attendance application the attendance data is stored in table 'A' including employee ID and attendance date time. Another table 'B' has one column with dates of current year (365 records). For the sake of simplicity, other fields are ignored. Table: A Employee_ID Attend_date (date with time) Table: B year_date (one record each for a day of current year i.e., 365 records) In a report (single employee at a time) showing all dates of the year and in front of it whether the employee was present or not we are running the following query. Assume that table A has 15 records of employee ID 123, the query should return 365 records with 15 records telling the time but it returns 15 records only. SELECT year_date, to_char(attend_date, 'hh:mi:ss' ) FROM A, B WHERE to_char(year_date, 'dd-mm-') = to_char(attend_date(+), 'dd-mm-') and employee_id = 123; To my understanding this is perhaps because of the filter employee_ID=123. What would be the query to get the required result? TIA! Aleem -- 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). -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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
RE: utl_file_dir vs create directory
Title: RE: utl_file_dir vs create directory I believe that the 'create directory' command is only appropriate when dealing with BFILEs. It's not exactly a substitute for the UTL_FILE package and UTL_FILE_DIR parameter. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Subject: utl_file_dir vs create directory Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: utl_file_dir vs create directory
a) its dynamic (so bounce needed) b) its more granular - you can grant read/readwrite etc hth connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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: utl_file_dir vs create directory
This is VERY limited but from what I remember she is correct and it is CREATE_DIRECTORY. Is the file you are writing out a BFILE or an external table. I think that is when you use this option. Oh hell, I'm going to RTFM to find this out as well. Lee Lee Robertson Oracle DBA __ __ ACXIOM Direct Dial: +44 (0)191 525 7344 Acxiom Limited Telephone: +44 (0)191 525 7000Camberwell Way Facsimile: +44 (0)191 525 7100 Doxford Tech. Park Sunderland E-mail: [EMAIL PROTECTED] SR9 9XZ -Original Message- Sent: 22 August 2002 13:59 To: Multiple recipients of list ORACLE-L Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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). * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: PL/Sql question
Tom - Thanks to you and everyone else for the great suggestions. He and I are sitting down tomorrow to straighten this out. I was concerned that there might be some PL/SQL oddity that I wasn't aware of (he is a pretty good PL/SQL programmer). I appreciate your ruling that out. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 22, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Dennis, I'd guess that the developer did not try it correctly. Ask to see the code. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Tom - The developer reports that he tried this but it didn't work. The third position is still a space value. Thanks to everyone for the good replies. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 21, 2002 3:13 PM To: '[EMAIL PROTECTED]' Cc: DENNIS WILLIAMS Dennis, Try changing your insert statement to: insert into JOBOFFERFACT_LOAD (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME, PACKAGEPRICE, PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE, PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES (LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,' '), TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE, PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ; Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 2:04 PM To: Multiple recipients of list ORACLE-L In response to the questions for more details, here are the PL/SQL code and SQL Loader control file. Everything is varchar2(2), explicitly defined as such in PL/SQL. Thanks for all the nice replies. PL/SQL snippets ...snip... marketingcodeVARCHAR2(3); ...snip... FILELOCATION := '/usr/users/madmload/text_files'; OPEN_MODE:= 'r'; FILENAME := 'prodload.txt'; FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE ); ...snip... UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING); marketingcode := substr(outputstring, 21, 3); ...snip... insert into JOBOFFERFACT_LOAD (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME, PACKAGEPRICE, PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE, PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES (LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE, PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ; Sql*Loader script LOAD DATA INFILE '/usr/users/madmload/joblid.txt' BADFILE '/usr/users/madmload/jobload.bad' APPEND INTO TABLE JOBFACT ( JOBNBR POSITION(1:10) CHAR, LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL, MDRPRIMARYIDPOSITION(21:28) CHAR, MARKETINGCODE POSITION(29:31) CHAR, SUBPROGRAMCODE POSITION(32:32) CHAR, TERRITORYCODE POSITION(33:34) CHAR, SUBTERRITORYCODEPOSITION(33:36) CHAR, SELLINGMETHODCODE POSITION(37:37) CHAR, BIDIND POSITION(38:38) CHAR, PDKIND POSITION(39:39) CHAR, PDKPARTNBR POSITION(40:44) CHAR, RETAKEIND POSITION(45:45) CHAR, PLANTCODE POSITION(46:46) CHAR, PLANTRECEIPTDATEPOSITION(47:56) DATE /MM/DD NULLIF PLANTRECEIPTDA, PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL, PLANTRECEIPTMONTH POSITION(52:53) INTEGER EXTERNAL, PHOTOGRAPHYDATE POSITION(57:66) DATE /MM/DD NULLIF PHOTOGRAPHYDATE=BLANKS, SHIPDATEPOSITION(67:76) DATE /MM/DD NULLIF SHIPDATE=BLANKS, SHOTQTY POSITION(77:80) INTEGER EXTERNAL, SHIPPEDPACKAGEQTY POSITION(81:84) INTEGER EXTERNAL, PAIDPACKAGEQTY POSITION(85:88) INTEGER EXTERNAL, UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL, XNOPURCHASEQTY POSITION(93:96) INTEGER EXTERNAL, CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL, CASHRETAINEDAMT POSITION(106:114) DECIMAL EXTERNAL, ACCTCMSNPAIDAMT POSITION(115:123) DECIMAL EXTERNAL, ESTACCTCMSNAMT POSITION(124:132) DECIMAL EXTERNAL, CHARGEBACKAMT POSITION(133:141) DECIMAL EXTERNAL, SALESTAXAMT POSITION(142:150) DECIMAL EXTERNAL, TERRITORYCMSNAMTPOSITION(151:159)
RE: utl_file_dir vs create directory
Rachel, it is recommended that you use create directory rather than utl_file_dir. http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920 /a96590/whatsnew.htm#970251 just scroll down a bit. I think create directory will let you perform the function of utl_file_dir but dynamically. For changing utl_file_dir you required to bounce the instance, but not in this case. I think this is why ... 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, August 22, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Pro*C error after install
I am getting the following error after installing Pro*C on an existing 8.1.7 instance. Can anyone help? mailto:oracle@cdwtst oracle@cdwtst: make -f demo_proc.mk sample1 /usr/ccs/bin/make -f /u001/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk OBJS=sample1.o EXE=sample1 build cc -xO2 -Xa -xstrconst -xF -mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP -I. -I/u 001/app/oracle/product/8.1.7/precomp/public -I/u001/app/oracle/product/8.1.7/rdbms/public -I/u001/app/oracle/product/8.1.7/r dbms/demo -I/u001/app/oracle/product/8.1.7/plsql/public -I/u001/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSL TS_ENABLE -D_SVID_GETTOD-c sample1.c /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `sample1.o' Current working directory /u001/app/oracle/product/8.1.7/precomp/demo/proc *** Error code 1 make: Fatal error: Command failed for target `sample1' R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: utl_file_dir vs create directory
Damn, it isn't CREATE_DIRECTORY at all, it is without the underscore -Original Message- Sent: 22 August 2002 14:04 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' This is VERY limited but from what I remember she is correct and it is CREATE_DIRECTORY. Is the file you are writing out a BFILE or an external table. I think that is when you use this option. Oh hell, I'm going to RTFM to find this out as well. Lee Lee Robertson Oracle DBA __ __ ACXIOM Direct Dial: +44 (0)191 525 7344 Acxiom Limited Telephone: +44 (0)191 525 7000Camberwell Way Facsimile: +44 (0)191 525 7100 Doxford Tech. Park Sunderland E-mail: [EMAIL PROTECTED] SR9 9XZ -Original Message- Sent: 22 August 2002 13:59 To: Multiple recipients of list ORACLE-L Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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). * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: assistance
HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Strange Data issue.....
Title: Strange Data issue. This will not fix it. Group by race,gender should return only one row for each unique combination of both columns. I can not help on this except advising to check the ASCII for both columns or check for special characters in these columns if they are wider that one char. Regards, Waleed -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Strange Data issue. Denham, Your "group by" does not match what you are selecting, thus the results are wrong. Change your query as follows: select race||','||gender,count(*) from pers group by race||','||gender Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: Strange Data issue. Hello Gurus, I have a problem which I hope someone can help me with. I am trying to clean up some data on a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. The select used is : select race||','||gender||','||count(*) from pers group by race, gender; The result is as follows: A,F,62 A,M,613 A,M,35 A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 The problem is that the result returns double Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: utl_file_dir vs create directory
yes I saw the docs. but that doesn't tell me that I can CREATE A FILE which is what we want to do. Since this is a new application and database, I can bounce the instance all I want, no one is using it except me and the programmers yet --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Rachel, it is recommended that you use create directory rather than utl_file_dir. http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920 /a96590/whatsnew.htm#970251 just scroll down a bit. I think create directory will let you perform the function of utl_file_dir but dynamically. For changing utl_file_dir you required to bounce the instance, but not in this case. I think this is why ... Raj __ Rajendra JamadagniMIS, 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, August 22, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl_file_dir vs create directory
that's what I thought, but the docs would lead you to believe it is the preferred substitute in all cases... I was always under the impression that BFILEs are read-only. If this is wrong, then we can and should probably use the 'create directory' and BFILE. If this is right, then a BFILE is useless to me in this circumstance Rachel --- Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] wrote: I believe that the 'create directory' command is only appropriate when dealing with BFILEs. It's not exactly a substitute for the UTL_FILE package and UTL_FILE_DIR parameter. Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -Original Message- Sent: Thursday, August 22, 2002 8:59 AM To: Multiple recipients of list ORACLE-L Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SunFire v100
headless server? What's that? --- Maria Aurora VT de la Vega [EMAIL PROTECTED] wrote: Hello everyone. Just want to ask if anybody tried to use a SunFire v100 as a database server. I was told this is a headless server, but otherwise, very similar to any other sun servers. Looks like an oracle database on this baby can work enough as a development server. Would like to get anybody's opinion. Will oracle work on this or not? Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: utl_file_dir vs create directory
Connor, So create directory can be used instead of the utl_file_dir initialization parameter and can still be used with the utl_file package? That's my only worry, as the docs lead me to believe that I need to replace the use of utl_file with BFILEs Once I have created a directory, it remains available across database shutdown and startup? Rachel --- Connor McDonald [EMAIL PROTECTED] wrote: a) its dynamic (so bounce needed) b) its more granular - you can grant read/readwrite etc hth connor --- Rachel Carmichael [EMAIL PROTECTED] wrote: Okay, I'll admit I know nothing about the create directory command and am off to read the fine manuals as soon as I hit send on this my developer sent me an email saying do you know of this new feature create_directory? it is recommended to use create_directory instead of utl_file_dir First, she's not in, I can't ask her WHO recommended it. But I will. Second, I think she meant create directory, without the underscore. Basically what we are doing is reading an orders table and generating a flat file to be shipped to the fulfillment center. This will be done via a PL/SQL procedure which will be called at regularly scheduled times. Why would I want/need to use create directory instead of utl_file? The database will go live in 9.2.0.1 Any advice is welcome! Rachel __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- 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). __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
re: query help.
Hey list Guru, Can anyone help me with this query?Many thanks, SELECT A.COUNTY_CODE, C.COUNTY_NAME, lpad(B.PRECINCT,4,' '), count(*), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(18*12))/(1*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(19*12))/(11*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(30*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(40*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(50*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(60*12))/(5*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, A.DOB)-(65*12))/(10*99)),1,0)), sum(decode(A.DOB, NULL, 1, 0)) FROM ONLINE_VOTERS A, ADDRESS_INDEX B, COUNTIES C WHERE A.COUNTY_CODE = B.COUNTY_CODE AND A.ADDRESS_ID = B.ADDRESS_ID AND A.COUNTY_CODE = C.COUNTY_CODE AND A.STATUS IN ('V','S') GROUP BY A.COUNTY_CODE, C.COUNTY_NAME, lpad(B.PRECINCT,4,' ') UNION ALL SELECT D.COUNTY_CODE, C2.COUNTY_NAME, lpad(D.PRECINCT,4,' '), count(*), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(18*12))/(1*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(19*12))/(11*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(30*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(40*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(50*12))/(10*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(60*12))/(5*12)),1,0)), sum(DECODE(0,floor((months_between(sysdate, D.DOB)-(65*12))/(10*99)),1,0)), sum(decode(D.DOB, NULL, 1, 0)) FROM OFFLINE_VOTERS D, COUNTIES C2 WHERE D.COUNTY_CODE = C2.COUNTY_CODE AND D.STATUS IN ('V','S') GROUP BY D.COUNTY_CODE, C2.COUNTY_NAME, lpad(D.PRECINCT,4,' '); _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: cw INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.
Dennis,In my case Net8 connection is not feasible because I have both OS Windows 2000/ Linux on the same machine using dual boot. So the only option for me is to export the required user from Windows database and then import from Linux database. But please note that I have source database Windows 2000/9i, but the source database is Linux/8.1.6. Can this be any problem for export/import.Recently I copied a database from a Window machine to another window machine by copying the database files, redo log file, control files etc to target machine in the corresponding directory and just created a service on the target machine by using oradim and it worked fine. Is that possible if you want to move the database and other files of Windows OS database to a Linux OS database and then use svrmgrl to do something similar to get windows database working on Linux. I know for this to work, I need to recreate or make changes to control file. Thanks.-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of DENNISWILLIAMSSent: Wednesday, August 21, 2002 4:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux7.Kumar Ummm . . . are you using any 9i features? I'm assuming you haveconsidered using 9i on Red Hat. Sounds like probably use the 8i exportfunction to create the export file. I'm assuming the data involved is smallenough to make export/import practical. If you create a Net8 connection, youcan just copy the data.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Wednesday, August 21, 2002 3:24 PMTo: Multiple recipients of list ORACLE-L8.1.6I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/Oracle 8.1.6. Please suggest the options.Thanks.--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Dharminder Kumar 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: DENNIS WILLIAMS 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).
Oracle DBA position- Must already live in WI
Position: Oracle DBA Years Exp: 3+ years Location: Milwaukee, WI Industry: Software Compensation: 45-70K depends on experience plus Exceptional benefits. *Candidates must already be living in the state of Wisconsin. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. *Position Description: Fantastic career opportunity with probably the most high tech company in the state of Wisconsin. Small group of dynamic players, team orientated, fun place to work! *Requirements: -3-5 years of operational experience with oracle within a Unix environment. -Should be very well rehearsed in performing backup and recoverys including moving databases from host to host, renaming databases, Imports and Exports, etc. Experience with setting up disaster-recovery scenarios is desirable. -Performance tuning experience: SQL statements, using Explain Plans and TKProf is essential; Evaluating operational performance problems, memory tuning, cache tuning, statement tuning, etc. -Diagnosing application issues in an Application Server environment is a must. -General oracle dba experience should include establishing dba instances, building databases, adding files to tablespaces, understanding of Rollback Segments, etc. -The candidate should also have experience in writing PL/SQL preferably in a financial environment; this also includes understanding and building Entity Relationship Diagram for an application and using oracle Designer (preferred), or ERWin. -Unix experience should include several years of script writing in KSH, SH, and/or Perl -U.S. citizenship or permanent residency is also required. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/DBA/Milwaukee/Steve We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: assistance
Not me. I must be to much of a financial risk. ;o) -Original Message- Sent: Thursday, August 22, 2002 9:49 AM To: Multiple recipients of list ORACLE-L HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: FW: assistance
They probably don't/can't do anything about international garbage, but the federal trade commission has some spam efforts: http://www.ftc.gov/bcp/conline/edcams/spam/ At this url: http://www.ftc.gov/opa/1998/9806/uce.htm The Commission said it closely monitors the development of commerce on the Internet and is monitoring UCE for deception and fraud. An FTC e-mail address where consumers can forward fraudulent e-mail ( [EMAIL PROTECTED] ) has collected over 100,000 pieces of UCE and is receiving up to 1,500 new pieces daily. On Thu, Aug 22, 2002 at 06:48:30AM -0800, Robertson Lee - lerobe wrote: HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list,
RE: Strange Data issue.....
Title: Strange Data issue. Waleed, what I suggested was that the select and group by were not the same columns, thus the results were unpredicitble. He is selecting one thing, and grouping by another. If he selects and groups by the same items, this will work just fine. It makes no sense to me why he is concatenating everything together. A better query would be : select race, gender, count(*) from pers group by race, gender Tom Mercadante Oracle Certified Professional -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 11:04 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Strange Data issue. This will not fix it. Group by race,gender should return only one row for each unique combination of both columns. I can not help on this except advising to check the ASCII for both columns or check for special characters in these columns if they are wider that one char. Regards, Waleed -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 10:14 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Strange Data issue. Denham, Your "group by" does not match what you are selecting, thus the results are wrong. Change your query as follows: select race||','||gender,count(*) from pers group by race||','||gender Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: Strange Data issue. Hello Gurus, I have a problem which I hope someone can help me with. I am trying to clean up some data on a table. This table happens to be a personnel table. In this table there are two columns RACE and GENDER. The select used is : select race||','||gender||','||count(*) from pers group by race, gender; The result is as follows: A,F,62 A,M,613 A,M,35 A,,15 C,F,34 C,M,198 C,M,4 C,,2 I,F,13 I,M,69 I,M,1 W,F,205 W,M,972 W,M,28 W,,15 The problem is that the result returns double Ms, M indicating Male. As highligthed above I have tried converting to ascii to see if they are different in anyway but both Ms return ascii 77. Does anyone have any thoughts on this? TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
utl_file_dir versus create directory
in 9.0.2, you can use utl_file commands against directory objects, quickie example: create directory tmp as '/tmp';grant write on directory tmp to public;grant read on directory tmp to public; declare ft utl_file.file_type; begin ft:=utl_file.fopen('TMP','x.gf','w'); utl_file.put(ft,'X!@#$'); utl_file.fclose(ft);end;/ edit /tmp/x.gf and no i dont have my utl_file_dir set at all. joe
RE: assistance
I haven't had this recently. I can't believe the number of government officials out there who covertly email people out of the blue with fantastic offers of wealth. I've been contacted by deposed leaders, heads of government departments and, on one occasion, a king who needed my money to help him recover the throne of which he'd been cheated. When he was properly enthroned he was going to shower me with the kind of riches only seen in pirate movies. I always feel that was a chance wasted. I could have been a Maharajah by now. Yes, I got lots of this kind of old bollocks. Cheers, Mike -Original Message- Sent: 22 August 2002 15:49 To: Multiple recipients of list ORACLE-L HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. blather blather This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately 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: FW: assistance
Oh, I get such mails usually once a month, although they are from persons of Nigeria. If these are from yahoo or so then I send them back to [EMAIL PROTECTED] else just press del Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: .uk Subject: FW: assistance Sent by: [EMAIL PROTECTED] 2002.08.22 17:48 Please respond to ORACLE-L HELLO anyone else get this pile of S**T !! Lee -- 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: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.
Kumar, You can't copy the datafiles between OSs unless they are binary compatable, with Windows and any flavor of Unix are not. Also, you will have problems trying to export from 9i and import to 8i. You need to run the export using 8i executables, or at least I could never get it to work any other way. Is there a reason you can't install 9i on the Linux side? Also, if you are saying that both "machines" are the same hardware ("dual boot"), how do you expect to get the .dmp file from one "side" to the "other side"? Do you have some network storage somewhere? Good Luck, John P Weatherman Database Administrator Replacements Ltd. -Original Message-From: Dharminder Kumar [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 22, 2002 11:11 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7. Dennis,In my case Net8 connection is not feasible because I have both OS Windows 2000/ Linux on the same machine using dual boot. So the only option for me is to export the required user from Windows database and then import from Linux database. But please note that I have source database Windows 2000/9i, but the source database is Linux/8.1.6. Can this be any problem for export/import.Recently I copied a database from a Window machine to another window machine by copying the database files, redo log file, control files etc to target machine in the corresponding directory and just created a service on the target machine by using oradim and it worked fine. Is that possible if you want to move the database and other files of Windows OS database to a Linux OS database and then use svrmgrl to do something similar to get windows database working on Linux. I know for this to work, I need to recreate or make changes to control file. Thanks.-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of DENNISWILLIAMSSent: Wednesday, August 21, 2002 4:39 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux7.Kumar Ummm . . . are you using any 9i features? I'm assuming you haveconsidered using 9i on Red Hat. Sounds like probably use the 8i exportfunction to create the export file. I'm assuming the data involved is smallenough to make export/import practical. If you create a Net8 connection, youcan just copy the data.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED]-Original Message-Sent: Wednesday, August 21, 2002 3:24 PMTo: Multiple recipients of list ORACLE-L8.1.6I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/Oracle 8.1.6. Please suggest the options.Thanks.--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Dharminder Kumar 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: DENNIS WILLIAMS 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).
RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.
Kumar - Generally, export/import expects to be going to a higher level of Oracle. If you are moving the data from 8.1.6 to 9i, then that will present no problems. Going the other way, moving data from 9i to 8.1.6 can pose problems. The usual recommendation is to use the 8.1.6 exp program against the 9i database. Are the Linux/W2K files binary compatible. I don't know myself, but somebody does. Learn the techniques for cloning an Oracle database. I believe http://www.orafaq.com http://www.orafaq.com has a paper on this. If not, just search using Google. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 22, 2002 10:11 AM To: Multiple recipients of list ORACLE-L Dennis, In my case Net8 connection is not feasible because I have both OS Windows 2000/ Linux on the same machine using dual boot. So the only option for me is to export the required user from Windows database and then import from Linux database. But please note that I have source database Windows 2000/9i, but the source database is Linux/8.1.6. Can this be any problem for export/import. Recently I copied a database from a Window machine to another window machine by copying the database files, redo log file, control files etc to target machine in the corresponding directory and just created a service on the target machine by using oradim and it worked fine. Is that possible if you want to move the database and other files of Windows OS database to a Linux OS database and then use svrmgrl to do something similar to get windows database working on Linux. I know for this to work, I need to recreate or make changes to control file. Thanks. -Original Message- mailto:[EMAIL PROTECTED]]On Behalf Of DENNIS WILLIAMS Sent: Wednesday, August 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L 7. Kumar Ummm . . . are you using any 9i features? I'm assuming you have considered using 9i on Red Hat. Sounds like probably use the 8i export function to create the export file. I'm assuming the data involved is small enough to make export/import practical. If you create a Net8 connection, you can just copy the data. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 21, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 8.1.6 I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/ Oracle 8.1.6. Please suggest the options. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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 http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: assistance
Title: RE: assistance Yup. Its a scam. Believe it or not, some people have actually fallen for it! Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Robertson Lee - lerobe [EMAIL PROTECTED] Sent: Thursday, August 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: FW: assistance HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I am a native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / 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
RE: Oracle DBA position- Must already live in WI
I *really* don't understand these things. Why would an employer say must be living in Wisconsin. I can understand saying relocation fees not available. Feel like I should be moving so I don't miss the opportunity to apply. -Original Message- Sent: Thursday, August 22, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Position: Oracle DBA Years Exp: 3+ years Location: Milwaukee, WI Industry: Software Compensation: 45-70K depends on experience plus Exceptional benefits. *Candidates must already be living in the state of Wisconsin. This is a full time staff position so no sub-contractors or third parties please. Please do not call or send a resume if you are not in the U.S. and/or need sponsorship. *Position Description: Fantastic career opportunity with probably the most high tech company in the state of Wisconsin. Small group of dynamic players, team orientated, fun place to work! *Requirements: -3-5 years of operational experience with oracle within a Unix environment. -Should be very well rehearsed in performing backup and recoverys including moving databases from host to host, renaming databases, Imports and Exports, etc. Experience with setting up disaster-recovery scenarios is desirable. -Performance tuning experience: SQL statements, using Explain Plans and TKProf is essential; Evaluating operational performance problems, memory tuning, cache tuning, statement tuning, etc. -Diagnosing application issues in an Application Server environment is a must. -General oracle dba experience should include establishing dba instances, building databases, adding files to tablespaces, understanding of Rollback Segments, etc. -The candidate should also have experience in writing PL/SQL preferably in a financial environment; this also includes understanding and building Entity Relationship Diagram for an application and using oracle Designer (preferred), or ERWin. -Unix experience should include several years of script writing in KSH, SH, and/or Perl -U.S. citizenship or permanent residency is also required. For immediate consideration, please send your resume as an attachment to: Bill Law, Oracle Placement Specialist OraStaff, Inc. Email: [EMAIL PROTECTED] Please use job code: One/DBA/Milwaukee/Steve We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the posiition described above- if it is not a match for your skills. Thanks, Bill Law -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: assistance
Just mentioned this to the boss Lee, and he said he's had one too? (He's not a member of the Oracle-L or Oracle-L-OT lists..). Mark -Original Message- Dave Sent: 22 August 2002 16:19 To: Multiple recipients of list ORACLE-L Not me. I must be to much of a financial risk. ;o) -Original Message- Sent: Thursday, August 22, 2002 9:49 AM To: Multiple recipients of list ORACLE-L HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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:
Oracle Applications Hanging
I'm sorry for posting this again, but I thought maybe it skipped everyone's eye. Every once in a while the oracle applications hang, because the listener is taking too much CPU. Even after waiting for a long time, the Listener process continues to hog the processor and people cannot connect to Oracle Apps. Any pointers on why this might be happening. Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Pro*C error after install
You favorite Unix vendor should ship you ANSI C compiler, preferably for free. Other solution is obtain a binary for gcc from http://www.gcc.org and change makefile line CC=/usr/ucb/cc to read CC=/usr/local/bin/gcc. If you chose the latter, you will have to tweak the makefile a bit so that it works. Let me warn you in advance: this is not easy. Using SUN's compiler you'll pay some more but you will lose much less time. In the end, the cost for your company will be the same, regardless of the option you chose. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 22, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject: Pro*C error after install I am getting the following error after installing Pro*C on an existing 8.1.7 instance. Can anyone help? mailto:oracle@cdwtst oracle@cdwtst: make -f demo_proc.mk sample1 /usr/ccs/bin/make -f /u001/app/oracle/product/8.1.7/precomp/demo/proc/demo_proc.mk OBJS=sample1.o EXE=sample1 build cc -xO2 -Xa -xstrconst -xF -mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP -I. -I/u 001/app/oracle/product/8.1.7/precomp/public -I/u001/app/oracle/product/8.1.7/rdbms/public -I/u001/app/oracle/product/8.1.7/r dbms/demo -I/u001/app/oracle/product/8.1.7/plsql/public -I/u001/app/oracle/product/8.1.7/network/public -DSLMXMX_ENABLE -DSL TS_ENABLE -D_SVID_GETTOD-c sample1.c /usr/ucb/cc: language optional software package not installed *** Error code 1 make: Fatal error: Command failed for target `sample1.o' Current working directory /u001/app/oracle/product/8.1.7/precomp/demo/proc *** Error code 1 make: Fatal error: Command failed for target `sample1' R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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).
OT: RE: assistance
Lee, Well! I guess you are not eligible because you broke the Top Secrecy code of conduct! A local tv station saw this scam and contacted this guy - actually recorded him for on-air viewing (with the mopes permission). Showed it to be an absolute scam. Your email address must be used all over the place! :) -Original Message- Sent: Thursday, August 22, 2002 10:49 AM To: Multiple recipients of list ORACLE-L HELLO anyone else get this pile of S**T !! Lee -Original Message- Sent: 22 August 2002 16:44 To: [EMAIL PROTECTED] STRICTLY CONFIDENTIAL URGENT. I ama native of Cape Town in South Africa and I am an Executive Accountant with the South Africa DEPARTMENT OF MINERAL RESOURCES AND ENERGY First and foremost, I apologized using this medium to reach you for a transaction/business of this magnitude, but this is due to Confidentiality and prompt access reposed on this medium. I have decided to seek a confidential co-operation with you in the execution of the deal described Hereunder for the benefit of all parties and hope you will keep it as a top secret because of the nature of this transaction. Within the Department of Mining Natural Resources where I work as an Executive Accountant and with the cooperation of four other top officials, we have in our possession as overdue payment bills totaling Twenty - One Million, Five Hundred Thousand U. S. Dollars ($21,500,000.) which we want to transfer abroad with the assistance and cooperation of a foreign company/individual to receive the said fund on our behalf or a reliable foreign non-company account to receive such funds. More so, we are handicapped in the circumstances, as the South Africa Civil Service Code of Conduct does not allow us to operate offshore account hence your importance in the whole transaction. This amount $21.5m represents the balance of the total contract value executed on behalf of my Department by a foreign contracting firm, which we the officials over-invoiced deliberately. Though the actual contract cost have been paid to the original contractor, leaving the balance in the Tune of the said amount which we have in principles gotten approval to remit by Key tested Telegraphic Transfer (K.T.T) to any foreign bank account you will provide by filing in an application through the Justice Ministry here in South Africa for the transfer of rights and privileges of the former contractor to you. I have the authority of my partners involved to propose that should you be willing to assist us in the transaction, your share of the sum will be 25% of the $21.5 million, 70% for us and 5% for taxation and miscellaneous expenses. The business itself is 100% safe, on your part provided you treat it with utmost secrecy and confidentiality. Also your area of specialization is not a hindrance to the successful execution of this transaction. I have reposed my confidence in you and hope that you will not disappoint me. Endeavor to contact me immediately my e-mail address whether or not you are interested in this deal. If you are not, it will enable me scout for another foreign partner to carry out this deal I want to assure you that my partners and myself are in a position to make the payment of this claim possible provided you can give us a very strong Assurance and guarantee that our share will be secured and please remember to treat this matter as very confidential matter, because we will not comprehend with any form of exposure as we are still in active Government Service and remember once again that time is of the essence in this business. I wait in anticipation of your fullest co-operation. Yours faithfully, JOSEPH EDWARD NOTE: REPLY TO [EMAIL PROTECTED] * 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. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / 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