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

Thread: Binary Primary Keys

  1. #1
    Join Date
    Jan 2000
    Location
    Adelphi, Md. USA
    Posts
    28
    Hi Gurus,

    I have two issues:

    1. On windows NT with Oracle version 8.1.5, 8.05, and 7.3.4, does anyone know whether Oracle can generate 32 or 64 binary primary key? The situation is that the client has a lot of sites and want to identify the uniqueness by generating a 32 bit primary key where the first 12 characters represents the particular site and then the rest of the field is the part for the primary key that is used on the file. In some files, the 13 thru 32 bits can represent a foreign. I just cannot find out whether Oracle generates 32 and/or 64 bits key? Also, does anyone know if there is an impact from using 32 bits and then going to 64 binary? If One of the Oracle versions that I have mentioned does not support binary, does one/all of the versions support hexadecimal and/or octal? If any of the scenarious hold true.. how are binary/octal/hexadecimal key be generated?

    2. Can an exported file from Oracle 8i ( 8.1.5) be imported to 7.3.4 and/or 8.0.5.

    I realize this is a mouthful, but please advise if you can.

    Thanks

  2. #2
    Join Date
    Nov 2000
    Posts
    20

    Export/Import

    Hai,

    for the Question 2

    Run Catexp7.sql This will

    create v7 style export/import views against the v8 RDBMS
    so that EXP/IMP v7 can be used to read out data in a v8

    Hope this will be helpfull for you.

    ...Thomas
    Thomas

  3. #3
    Join Date
    Jan 2000
    Location
    Adelphi, Md. USA
    Posts
    28
    On the NT server with Oracle 7.3.4, I should run catexp7.sql before I would be able to import the file that is comming from the server with Oracle 8i (8.1.5) unto the server with Oracle 7.3.4. The reason for my statement is that your reply says against the v8 RDBMS. If I run catexp7.sql on my v8 RDBMS, I could switch it back by running say catexp8.sql to get it back to where it should be on v8 RDBMS?

    Thanks

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