on 03-04-2010 12:58 PM
Hello guys,
I wonder how SAP creates an index when it is executed via SE14 or SE11 transactions. I mean on Oracle level and especially ONLINE option. My consideration is that I must create an index on a big table and the duration is around 5+ hours. We tested this in a fresh test environment (copy from productive system). Unfortunately we cannot lock the productive system for so long period. So, if index creation is with ONLINE option - it will not lock the table and it will be used if necessary.
Thank you for your suggestions and advices.
Best regards,
Detelin
Hi
I guess you can create online i.e when the system is running from SE11.
Please check the link
Link: [http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Detelin
No, during index creation database locks the table. So, although your SAP is up particular table will be locked for deletion , insert etc.
But from oracle level you can create index online by running SQL command
Please refer to note Note 334224 - Important notes for creating indexes
Regards
Anindya
Edited by: Anindya Bose on Mar 4, 2010 6:57 PM
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.