Automated Oracle reorganization

[Former Member]

Cheers,

Need to find a way to do automatic online reorganization of 2 table monthly.

I searched all over, but I can't find an concludent answer.

I saw some suggestions to use crontab and other schedulers, but I prefer to be done in SAP.

Jordy

[Former Member · Accepted solution]

Hi Jordy,

You can create a command on SM49 and execute it, if you would like.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Hi Orkun,

Interesting with sm49. Thanks, although, no possibility to do it via some jobs that include some report ?

Like for example RSANAORA for statistics -> SAP Report - Analysis of Oracle tables for creating statistics

Thanks

[Former Member · Accepted solution]

>> Like for example RSANAORA for statistics -> SAP Report - Analysis of Oracle tables for creating statistics

Well, I don't know an standard ABAP report which reorganize a database object such as table or index. So you can create the command and call in an ABAP code. Then schedule it on the system.

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

I have posted a possibility to schedule the reorgs in the other thread:

Cheers Michael

[Former Member · Accepted solution]

Thanks Michael,

Thank you all