cancel
Showing results for 
Search instead for 
Did you mean: 

Table Reorgnazation procedure

prasad_sure
Participant
0 Kudos

Hi,

Anybody please help me. How to reorgnize tables with procedure.

Our server is HP_UX and oracle.

Please suggest me.

Regards

Prasad

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prasad,

If you have DBA skills, you can connect to the database using sqlplus and execute the statement : alter index sap<SID>."INDEX_NAME" rebuild online;

Another method is execute the report RSANAORA using SE38.

In this report you need to fill the the index name and select the option to rebuild online. Take care, the option "rebuild" should cause many locks in your system.

Another point that you need to worry is if you have freespace in tablespace to ensure that a copy of any index that you need to rebuild.

If you need more information, please let me know.

Best Regards,

Itamar Marioto

prasad_sure
Participant
0 Kudos

Hi Itamar Marioto,

Sorry for the delay.

Next week mostly we are doing table Reorganization.

We are planning these table Reorganization through SAPDBA.

So Please if u are having any document Procedure please send to me.

I am waiting for your reply.

Thanks & Regards

S.Prasad

former_member204746
Active Contributor
0 Kudos

Prasad, note 646681 uses BRTOOLS instead of SAPDBA and this is the tool that should be used. If using Oracle 10g, you have no choice, for Oracle 8 or 9, you can still use SAPDBA

for SAPDBA, use the guide at http://www.erphome.net/pdf/saezpdf/112saez.pdf

also view http://help.sap.com/saphelp_crm50/helpdata/en/d1/a9fe114b8a11d189510000e829fbbd/frameset.htm

good luck.

prasad_sure
Participant
0 Kudos

Hi,

Please provide any one how to create the index Reorgnazation procedure.

What is the procedure? Please explain to me.

Regards

S.Prasad

Former Member
0 Kudos

Hi Prasad,

You can re-organize using SAPDBA

Select tablespace and enter index.

Regards,

Payal Patel

prasad_sure
Participant
0 Kudos

Hi,

For this activity how much space i want to increase.

For example ACCTIT i want to reorgnization this table. How much space is required. please give the example.

Becaue this activity tommorow morning we are planned.

Please help me.

Regards

S.Prasad

former_member204746
Active Contributor
0 Kudos

you will need as much space as ACCTIT is presently using. while reorg is running, you will double this table's space.

so, put datafiles of its tablespace to autoextend.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Prasad,

Could you provide us more detailed information about your needs?

The table mentioned is a database table in the oracle database?

Why do you want to reorganize a table?

Do you plan to do this with the system running?

Best Regards,

Itamar Marioto

prasad_sure
Participant
0 Kudos

Hi Marioto,

Thanks.

For F.62 Performance issue SAP Is recommended by Reorganize the indexes of table BKORM. Yes when the system is running on that time. Because of this is a production server.

Regards

S.Prasad

former_member204746
Active Contributor
0 Kudos

read SAP note 646681.

it explains the whole process.