Hi,
I got the duplicate values in my partition talbe. i got pk on that table. i am using oracle 8.1.6.2.0 , Solaris 2.8, VxVM,VxFS.
Can any body any tell reason why i am getting the duplicate
rows, i would be appriciate.
Thanks
Chan
Printable View
Hi,
I got the duplicate values in my partition talbe. i got pk on that table. i am using oracle 8.1.6.2.0 , Solaris 2.8, VxVM,VxFS.
Can any body any tell reason why i am getting the duplicate
rows, i would be appriciate.
Thanks
Chan
Same table_name, different owner maybe?
select owner, segment_name, partition_name, segment_type
from dba_segments
where segment_name = 'YOUR_TABLE_NAME'
are the dublicate rows from separate partitions?
do key columns contain null values?