RE: Oracle 11i
Thanks, Mike. It still asks me to provide billing info when I tried to order the CD Packs. How did you get it for free? Nancy From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle 11i Date: Wed, 10 Sep 2003 01:24:24 -0800 Nancy, look in the Oracle Store. You can buy it for next to nothing. Click the CD Packs tab, choose the platform you want, select 11i Release 9. Cheers, Mike Hately -Original Message- Sent: 10 September 2003 02:24 To: Multiple recipients of list ORACLE-L I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Try MSN Messenger 6.0 with integrated webcam functionality! http://www.msnmessenger-download.com/tracking/reach_webcam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 11i
I would like to evaluate Oracle 11i. Could any body let me know what are pros and cons between Oracle 11i and Oracle Collaboration Suite? Is there any place where I can download Oracle 11i and related documents for trial? I can not find them on Oracle web site. Thanks for any inputs in advance. Nancy _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Loader problem
Tim, Sorry for late reply. I was out for a few days. You are right. CHAR(4000) fixed the problem. I really appreciate your help and all the help from other people who answered my question. Thanks. Anna From: Tim Gorman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: SQL Loader problem Date: Tue, 29 Jul 2003 15:09:29 -0800 Sliced bread or not, the syntax problem will be the same since external tables are modeled on SQL*Loader syntax... :-) Anna, I suspect that there is confusion on the SQL*Loader concepts of external datatypes and internal datatypes, which incidentally is shared by external tables currently. SQL*Loader's internal datatypes match the standard Oracle RDBMS datatypes, but the external datatypes are something else altgoether... I don't have docs available, but specifying an external datatype of VARCHAR or VARCHAR2 probably doesn't mean what you want it to mean. If memory serves, I think it is supposed to be a two-byte binary integer (which is the data length) to be followed by the data itself. Or something like that... Try CHAR(4000), perhaps? The Server Utilities manual from the standard Oracle doc-set on http://otn.oracle.com; has all this stuff in it... Hope this helps... -Tim on 7/29/03 3:19 PM, Mladen Gogala at [EMAIL PROTECTED] wrote: Try with external tables. The best thing since sliced bread. On 2003.07.29 17:39, Anna Li wrote: Hi All, I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is 4000 characters, but 1000 characters. It was inserted successfully when I execute insert statement in TOAD as: insert into skills_tmp values(..); Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance. Anna _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Loader problem
Hi All, I'm trying to use SQL Loader to load data from a text file into a table. However, I always get error as column SKILL_DESCRIPTION field in data file exceeds maximum length where the column SKILL_DESCRIPTION is declared as varchar2(4000). I know the data is 4000 characters, but 1000 characters. It was inserted successfully when I execute insert statement in TOAD as: insert into skills_tmp values(..); Is there any option in SQL Loader I have to set in order to load a long string? Thanks for all the inputs in advance. Anna _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
install delete_commit procedure
Hi All, I would like to create DELETE_COMMIT procedure (developed and distributed by Oracle support). Does anyone know where I can get the script? Thanks in advance for your help. Anna _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unique constraint violation problem
Thanks for all of you who replied the message. I apologize for not explaining the problem clearer. Actually, the error was reported at 13:35:13pm from the application. There is a column called date_created in the table that records what time the record was created. The value of date_created for the record that caused error message is the same as reported from application. That's why I said that the record was inserted into the table successfully. I know Oracle recommends that we do not explicitly define unique indexes on tables. Why? Anna From: Jacques Kilchoer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: unique constraint violation problem Date: Mon, 07 Jul 2003 12:59:25 -0800 My explanation would be that the record was NOT inserted successfully into the table. Proof of that would be that there are no duplicate records in the table. -Original Message- From: Anna Li [mailto:[EMAIL PROTECTED] I created a unique index on a table called REGISTRATION_K, but no unique constraint. Last week when the application tried to insert a record into the table, we got following error in the log file: Oracle::st execute failed: ORA-1: unique constraint (REGISTRATION_K) violated However, the record was inserted into the table successfully. There are no duplicate records in the table. Could anyone explain why? Any input will be highly appreciated. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
unique constraint violation problem
Hi, I created a unique index on a table called REGISTRATION_K, but no unique constraint. Last week when the application tried to insert a record into the table, we got following error in the log file: Oracle::st execute failed: ORA-1: unique constraint (REGISTRATION_K) violated However, the record was inserted into the table successfully. There are no duplicate records in the table. Could anyone explain why? Any input will be highly appreciated. Thanks in advance. Anna _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
unique constraint violation problem
Hi, I created a unique index on a table called REGISTRATION_K, but no unique constraint. Last week when the application tried to insert a record into the table, we got following error in the log file: Oracle::st execute failed: ORA-1: unique constraint (REGISTRATION_K) violated However, the record was inserted into the table successfully. There are no duplicate records in the table. Could anyone explain why? Any input will be highly appreciated. Thanks in advance. Anna _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Anna Li INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).