Knowledge Management

Question:
Dear all,
Is it necessary to do table reorg after I have archive sap data?
Answer:
Hello,
not necessary, but recommended.
We don't do table reorg,
but we do index reorg.
(Online index reorg is possible with Oracle 9i)
Answer:
Dear hoinz,
Thanks for your reply,I want to know whether the database space
would be released after I have archived data? If I do table reorg , How can I do? My system environment:SAP 45B,Oracle 8.1.7, HP_UX.
DB size 2TB.
Regards,
Answer:
Hello,
no, the database space will not be released. For this you definitely have to reorg.
Without reorg, the space of your deleted entries will be available for new entries in the same table (that's why we don't reorg), but not for new entries in other tables.
And as for your question how to reorg: As we do not do it, I feel not qualified to answer. I think you will need export and import, during downtime. But you should be able to find all you need in the docs. (SAP notes, or other guides.)
regards
Answer:
Hello,
no, the database space will not be released. For this you definitely have to reorg.
Without reorg, the space of your deleted entries will be available for new entries in the same table (that's why we don't reorg), but not for new entries in other tables.
And as for your question how to reorg: As we do not do it, I feel not qualified to answer. I think you will need export and import, during downtime. But you should be able to find all you need in the docs. (SAP notes, or other guides.)
regards
I don't do DB reorg after archive,it's possible that the space of my deleted entries will be not available for new entries in the same table ,because the db size increase quikly as the before.
Is there problem in the db configuration set or else?
Our db: oracle 8.1.7
sap: 45B
Thanks for your reply.
BR,
TOM