Something like: create table keys( key_id char(8) primary key, key_val raw(128) not null); where key_id is rawtohex(<the 32-bit key id>) and key_val is the 1024bit key... although it's technically feasable to generate duplicate key id's (especially with this sample size) it's probably not good policy to allow them. The question is, what are you -doing- with 50M keys? That's enough for the entire population of the west coast (and then some)! Henrik Ekenberg wrote: > Hello, > > We need to store some public keys in our database. > One key is 1024 bit and the other is 32 bit. > > How can we do ? We will have more than 50 000 000 rows in our table. > > Regards > Henrik > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Henrik Ekenberg > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
