on 05-01-2007 2:48 PM
Hello,
We are running SAP R/3 Enterprise 4.7 on an Oracle 9.2.0.7.0 database and have an issue with a limit on a table index of 16 fields. The Oracle version has a limit of 32 but the SAP application doesn't allow more than 16.
Has anyone else encountered this problem and, if so, have you found a way around it or just lived with the restriction?
Thanks,
Paul.
Hi Lars,
Thanks for your suggestion, I'll put it to our developers and see what they think. What we have found is that some of the table/index fields are not actually used and were incorporated some time ago so we have removed an unused field and added the new field that we need. This has resolved our issue for now.....
Regards,
Paul.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Paul,
since the ABAP/4 Dictionary is designed to db independend, there are several occurences where you cannot use up the options of the underlying db to the fullest.
Leaving aside for a moment that a 16 field secondary index is rather big you might use a workaround here.
Define a smaller index in SE11 but do create the index as you like it on the DB via sqlplus. That way you cannot transport the index but the DB02 DB check will find the index from the ABAP/4 DDIC on the DB.
Before you create that kind of index you really should doublecheck if this index is what your application really needs. Keep in mind that there is a considerable amount of work to be done to maintain such a big index and that it will allocate much space as well.
KR Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
an index with more than 16 fields!
with so many fields, an index might not be helpful...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.