Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Index Limit
Or, increase db_block_size (re-create database), and set pct_free low
(for the indexes). Things must fit in one block, I suppose.
I ran into the same problem when creating a complex index with a lot
of columns, re-created things with 8k blocksize instead of 2 and it
worked.
raas
-- "With enough free time, effort, and an input string that looks like the winning entry in last year's obfuscated-C contest, you can turn someone's simple mistake into a nationally syndicated news story."Received on Tue Oct 10 2000 - 02:31:15 CDT