DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Duplicate Rows in the Partition Table

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192

    Angry

    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Same table_name, different owner maybe?

    select owner, segment_name, partition_name, segment_type
    from dba_segments
    where segment_name = 'YOUR_TABLE_NAME'
    Jeff Hunter

  3. #3
    Join Date
    Nov 2000
    Posts
    212
    are the dublicate rows from separate partitions?
    do key columns contain null values?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width