Are you sure about that length limit? I remember something that the limit is that your index columns have to fit into one oracle database block and that block in defined by DB_BLOCK_SIZE (you have to define it before you create your database).
But if there is a limit then you can reduce the column size. I didn't tune the database scheme yet, we should look at the sql statements and define primary keys & indices where needed. latestrevisions should have a primary key of (uri,branchname) I think. Dirk "GARTRELL,MIKE (HP-Corvallis,ex1)" wrote: > > I have a few questions about the schema used for the JDBC store: > 1.) Some tables, like the "objects" table, have a varchar(3200) as a > primary key. Oracle 8i is unable to index tables having a primary key type > where the length of varchar is greater than 1080. > 2.) Why do some tables, such as "latestrevisions", lack a primary > key? > > ---> Mike Gartrell <--- ---> [EMAIL PROTECTED] <--- > ---> phone: (541) 715-0008 <--- > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
