Re: Rollback Segments
And I'm sitting at my (the) oaktable right now thinking about a few things Jonathan Lewis said an hour ago, sorrounded by good whiskies brought in by Kyle Hailey and Connor McDonald and Jonathan. We still have a few seats available for his Master Class on Monday. You're of course all invited to attend for free and stay in my house... Now let's move a few decades forward, to other great products: Does anyone remember the Oracle Card product? Sure, some do. Now, how many ever saw the email variant of Oracle Card? Do you know what it was called (and I'm not kidding)? Oracle PostCard. Yep. It was probably the first product to handle LONG RAW's. Went out of production so fast you wouldn't beleive it. Pretty much before it went into production. Or how about Oracle Visuelle or whatever it was called? Remember the user group meeting in Paris or Brussels in the late 80's where Larry proudly presented it? I guess it later became Oracle Graphics Anyway, a friend of mine - Mogens Egan - and I stole the EOUG flag (took it down from the pole outside the conference center) and used it for the Danish user group meetings for a while. I wonder where it is now. It carried this cube with Europe on. Anjo Kolk wrote: Thanks.Yes I am on the list and on the oak table (http://www.oaktable.net ;-))Anjo."Gogala, Mladen" wrote: Wow! I've been recommending your paper about Oracle7 wait eventseverywhere! I didn't know that you are on this list, too.-Original Message-Sent: Tuesday, February 19, 2002 2:43 AMTo: Multiple recipients of list ORACLE-LHow about iag/iap ? And rpt ? Oh and SQL*Menu ?And there were about 14 enqueue/locks in Oracle Version 5 as far as I canremember.Anjo KolkBrings back memories of joining Oracle Europe in 1985 ;-)- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5.Hemant K ChitalePrincipal DBAChartered Semiconductor Manufacturing LtdRachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AMSent by: [EMAIL PROTECTED]Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback SegmentsUFI no, but the rest... that's where I started in Oracle -- version 5--- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: Holy cow Mladen, what a memory!Does anybody else remember (or admit to) using UFI?Jim**...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Conboy, Jim INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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). __Do You Yahoo!?Yahoo! Sports - Coverage of the 2002 Olympic Gameshttp://sports.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Rachel Carmichael INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-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: 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 na me 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: Anjo Kolk INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California--
RE: Oracle8i - Oracle9i issue??????
Well, yes, I do understand that C# is MS's new-fangled language. My question "C# ?" actually meant "There already are applications out there that use C# against an Oracle Database ? Do they use MS ODBC to connect ? Could the "SQL command not properly ended" error be because of the ODBC drivers ?". I forgot the reference to "windows" in the original email and was thinking more of Pro*C or Pro*C++ applications against Oracle. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd "Pardee, Roy E" <[EMAIL PROTECTED]> 22/02/2002 11:38 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Oracle8i - Oracle9i issue?? C# is ms' we-can't-run-away-with-the-java-standard-so-here's-our-own-'c-like' -language language for .Net. There's a good bit of foofaraw over whether or not it is better/faster than/will kill java etc. in the dev community. Not to be confused with the latest version of visual C++ (which is mostly the same as old C++, but includes extensions for coding against the .net virtual machine) or J#, which is supposedly yet still more Java-like than C#. Interested readers can get the party line at http://www.msdn.microsoft.com/msdnmag/issues/0900/csharp/csharp.asp. Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, February 22, 2002 12:38 AM To: Multiple recipients of list ORACLE-L Yeah they refer to it as C "Sharp" as in the music # symbol. It is Microsoft's C.Net - I think. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:08 AM To: Multiple recipients of list ORACLE-L C# ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Denham Eva <[EMAIL PROTECTED]> 22/02/2002 03:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle8i - Oracle9i issue?? Hello Guru's I wonder if any of you have had this problem, we have a external company developing a software package in C#. On their Oracle9i test system, the software works fine, however once brought accross to our systems, which is an Oracle8i ( 817) system the software gives a (ORA - 00933 SQL command not properly ended) error, but funny enough only on the one window. I am told by them that they do straight select from a table, saving the returned columns in variables etc. The only difference is they don't have any semi-colons (;) at the end of the their queries. But catch 22 it works on the other screens(windows). Hope you folks can help TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). Yo
Re: Oracle OLE-DB
I love the java that Oracle provide for doing this sort of thing. You can simply have all of the files sent to the server and a process on the server can do it Oracle has CSV and XML parsers so you just hand it all off to the server to do. It will parse the files and then load it automatically into the databse for you Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = Viral Amin <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 23/02/2002 03:08 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Oracle OLE-DB Hi All Can anyone help me on this..Pls reply ASAP The requirement is as follows: -- The front-end is reading some data from external files (flat files like csv or maybe xml). -- The middle tier application (C++ component) is processing this information i.e. identifying the data and mapping the information to the respective table/column format -- The middle tier application is storing this mapped information in some kind of buffer/array -- The OLE-DB (or anything similar) set of functions/procedures should provide means to interface with this buffer and also the oracle database. I wanted to know if there is any layer (like OLE-DB or something similar) that can read this and provide functions that can insert/update data to the oracle database. Please let me know anyone's view on this. Let anybody forward me the ideas if any. Regards, Viral Amin -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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).
SQL Loader:How to load data with carriage return embedded
Hi DBAs, I have a flat file with Varchar2 data spread across lines with carriage return.. I have tried using the following but in vain. = LOAD DATA INFILE 'test.dat' "str X'0c0a'" INTO TABLE arul.test1 FIELDS TERMINATED BY "~" optionally enclosed by '"' trailing nullcols ( no , descr ) = where descr - Varchar2(4000) field.. There is no error message(!)?? Note - With the above spec. able to load only the first record with carriage returns embedded. Rest of the records are skipped as bad records(!) . Can anyone suggest the ways of loading it thru SQL Loader? Thank you. regards, Arul. * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com