you can't get more than 1 record loaded per second?
joe
>>> rlsmith_at_kmg.com 08/20/01 11:25AM >>>I
have a trigger that does an insert on a table containing 5 columns.
Thefirst three columns are variable information. The fourth column in
SYSDATE.The last column is either the constant INSERT or DELETE. The
first fourcolumns are in a unique index. When the user runs the
program that firesthe trigger she gets an Oracle error that says there is a
unique contraintviolation on the index. The data IS unique! This
is a very small table.The last character of the index is SYSDATE which goes
down to seconds. Sowhy would I get the
violation?Thanks!Ron -- Please see the official ORACLE-L
FAQ: http://www.orafaq.com-- Author:
Smith, Ron L. INET: rlsmith_at_kmg.comFat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
Lists--------------------------------------------------------------------To
REMOVE yourself from this mailing list, send an E-Mail messageto:
ListGuru_at_fatcity.com (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).
Received on Mon Aug 20 2001 - 09:50:50 CDT
