on 05-13-2007 2:47 AM
Hi,
Anybody please help me. How to reorgnize tables with procedure.
Our server is HP_UX and oracle.
Please suggest me.
Regards
Prasad
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.