Does anyone know how to figure out which specific index is causing a DUP_VAL_ON_INDEX exception? thanks. David Medinets, Consultant, http://www.codebits.com ...
David Medinets
medined@...
Jun 3, 2002 2:05 pm
153
+ Interjection by listserv moderator: + If you'd like to respond to this particular posting, please + reply directly to the sender at xsventure@......
The name of the index will be part of the error message retrieved by SQLERRM....
John Flack
johnf@...
Jun 4, 2002 1:22 pm
155
A DUP_VAL_ON_INDEX exception is equal to an ORA-00001: Unique constraint (%s.%s) violated. To find the exception place an exception handler to the trigger code...
Freyer, David
dfreyer@...
Jun 4, 2002 1:23 pm
156
+ Interjection by listserv moderator: + Although specifics on the training company mentioned below were to + be sent directly to originator of this thread, I...
Also, Tidewater Community College (Va Beach campus) offers Oracle DBA and Developer courses. I teach the Developer series and am certified in any classes I...
Hello everybody !! I'm doing some tests with RMAN, and I have some doubts : 1 - When I run the script below using FORMAT option, a file is created in the...
VOUG Membership - Just a quick reminder about a local Oracle training opportunity that we are offering on Thursday (June 6th). This is the one-day Oracle Fast...
Greetings: Here is a methodology I've used. This is not my original work, although I have reformatted it, made some changes, and have added it to my "recipe...
jlg
goldsmithj@...
Jun 4, 2002 9:23 pm
161
Greetings, Please help me out, the query is as follows $sql = "update PHYSPAGES set FLAGS = ? where PUB_DATE = $pubdate and LEVEL_ID = '$pub_level' and FLAGS =...
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: John Flack <johnf@...> Two things to look at popped...
Narendra, I've some questions about your query. You are updating PUB_DATE, and PUB_LEVEL with $pubdate and $pub_level respectively. And also selecting the...
Tarun Sharma
tarun.sharma@...
Jun 12, 2002 3:35 pm
164
Gary, Have you used EXPLAIN PLAN or SQL_TRACE, etc. to get an execution plan? Without any additional information (indexes created on table, data distribution,...
Mark C. Stock
mcstock@...
Jun 12, 2002 3:37 pm
165
Hi All, We have a corporation table in which the helpdesk adds new corporations that want to do business with the company. The only code in the application...
SHARIQ MIRZA
SMIRZA@...
Jun 12, 2002 4:25 pm
166
How do you format a SQL*Loader control file to ignore information at the top of the Infile (file that contains the data I am loading)... the actual data...
Rebecca Saxon
ras@...
Jun 13, 2002 4:47 pm
167
+ Interjection by listserv moderator: + Several helpful responses to this posting, below... ... From: Regis Biassala <regis.biassala@...> If it is not...
Are you getting the data file on a unix server or windows server? If unix, would it be possible to set up a job that will cut out the first 8 lines of the...
Jenkins, Jeremiah
jeremiah.jenkins@...
Jun 13, 2002 4:55 pm
169
+ Interjection by listserv moderator: + Thank you to Rebecca Saxon and and Pam Himes who also responded + to this posting with similar suggestions... Use the...
gsokola@...
Jun 17, 2002 11:21 pm
170
I found the message "Performance statistics empty: data overflow" in my alert log file. No error message number to look up (to find "Action:"), no related...
gsokola@...
Jun 17, 2002 11:23 pm
171
Dear All, I have a table with sample data as below. The primary key of the table is (SID, SEQ_NO). For a given SID value, if a combination of (PID, C_DAY, ...
Xu, Xinhua
XuX@...
Jun 17, 2002 11:24 pm
172
Gary, If you are running MTS, this could be bug 1246206. From Metalink: Bug 1246206 was filed for this issue. The message does not indicate any problems. One...
Coak, Mitch
mcoak@...
Jun 19, 2002 11:41 am
173
+ Interjection by listserv moderator: + Several helpful replies to this posting, below... ... From: "Blizard, Robert" <robert.blizard@...> Date: Wed...
Thank everyone for the help. I think I omitted something in my original e-mail. I have several other fields in the same table. Data in those fields are random...
Xu, Xinhua
XuX@...
Jun 19, 2002 7:05 pm
175
Thanks for the help everyone. By using the "skip 7" parameter in the SQLLDR call line, I was able to resolve my problem!...
Rebecca Saxon
ras@...
Jun 19, 2002 8:10 pm
176
Friends , I have a question regarding the usage of functions over procedures. A function can perform a DML as well as a procedure , but what would be a thumb...
Vaibhav Dani
vdani@...
Jun 21, 2002 10:53 am
177
Functions are generally used in software when you are returning 1 value. If you are returning 0 or more than 1 value than you should use a procedure. jim...
james.smith@...
Jun 21, 2002 11:20 am
178
The advantage to functions is to be able to use the return value in an expression -- within PL/SQL and within SQL statements. There is no inherent performance...
Mark C. Stock
mcstock@...
Jun 21, 2002 11:20 am
179
... As far as I know, deciding when to use function versus a procedure has no bearing on performance. Instead the only criteria that I use is this: If I need...
David Medinets
medined@...
Jun 21, 2002 3:45 pm
180
I have a column named Updated_By and I want Oracle to automatically show the user who is inserting and/or deleting information in a table. How can I do this?...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
