RE:[sap-basis] Creating index DDLOADD_0 again
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Snowy (Certified Netweaver '04/Oracle Basis consultant) on Mar 24 at 2:55 PM |  Mark as helpful |
Hi,
This index does not appear in SAP's data dictionary, so, you need to create it manually at SQLPLUS level. Go on a system that still has this index and re-create it manually with the same parameters.
---------------Original Message---------------
From: alrica
Sent: Wednesday, March 24, 2010 6:23 AM
Subject: Creating index DDLOADD_0 again
> I experts,
>
> I had an upgrade in my solution manager for EPH1 and to go to the end I had to delete index DDLOADD_0 which belongs to DDLOADD table.
> Now I want to create it again and it gives me an error : Index could not be created completely in the database -> This could be caused by the fact that an index with the same name exists in the database, but it is unknown to the ABAP/4 Dictionary. Activating the index in the ABAP/4 Dictionary is possible, but it is not possible to create it in the database.
> I enter SQLPLUS and this indix does?n exist in all_indexes table.
> Can you help me to solve this problem?
> Thanks a lot.
> Aldina
__.____._ This index does not appear in SAP's data dictionary, so, you need to create it manually at SQLPLUS level. Go on a system that still has this index and re-create it manually with the same parameters.
---------------Original Message---------------
From: alrica
Sent: Wednesday, March 24, 2010 6:23 AM
Subject: Creating index DDLOADD_0 again
> I experts,
>
> I had an upgrade in my solution manager for EPH1 and to go to the end I had to delete index DDLOADD_0 which belongs to DDLOADD table.
> Now I want to create it again and it gives me an error : Index could not be created completely in the database -> This could be caused by the fact that an index with the same name exists in the database, but it is unknown to the ABAP/4 Dictionary. Activating the index in the ABAP/4 Dictionary is possible, but it is not possible to create it in the database.
> I enter SQLPLUS and this indix does?n exist in all_indexes table.
> Can you help me to solve this problem?
> Thanks a lot.
> Aldina
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
SnowySAP Basis Helper
Posted helpful replies on 50 threads in a group to earn a Silver Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
55% of IT Pros Use Social Media to Advance Their Careers. See the Survey Results
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
