D
Dave Cullen
I want to convert a text column in one of my tables to date data type. I
created a new column and now I need to copy the data from the old column
to the new one.
Problem is that the table uses multiple keys to identify a unique
record. The old date field is one of them:
OPERATION..SESSIONDATE..SESSIONTIME.. (all three fields define a complex
key)
SESSIONDATE is a text formatted column that I want to copy to a date
formatted field named SESSION_DATE. When I try to run an update query I
get an error message that says
"Single row update/delete affected more than one row of a linked table.
Unique index contains duplicate values"
What can I do? The table is an Oracle 9i linked table.
created a new column and now I need to copy the data from the old column
to the new one.
Problem is that the table uses multiple keys to identify a unique
record. The old date field is one of them:
OPERATION..SESSIONDATE..SESSIONTIME.. (all three fields define a complex
key)
SESSIONDATE is a text formatted column that I want to copy to a date
formatted field named SESSION_DATE. When I try to run an update query I
get an error message that says
"Single row update/delete affected more than one row of a linked table.
Unique index contains duplicate values"
What can I do? The table is an Oracle 9i linked table.