ROWID Duplicated ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ROWID Duplicated ?

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    ROWID Duplicated ?

    Is there possible that 1 rowid will be shared by 2 different records
    ( from same table or different table)
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Rows in different tables that are stored together in the same cluster can have the same rowid.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2002
    Posts
    27
    there may be a chance when we do import by tranportable tablespaces

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by mallika
    there may be a chance when we do import by tranportable tablespaces
    Nope, this is not possible.
    -nagarjuna

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by mallika
    there may be a chance when we do import by tranportable tablespaces
    You know, I remember reading about this a long time ago, and it makes sense really. I can't find a mention of it in the 9iR2 docs, though.

    I distinctly remember reading that one circumstance in which a rowid could be non-unique was in a database with tablespaces transported in. Hmmm.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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