Hi all,
I have some inquiry with the command brspace for Oracle-based SAP system.
I been using the command [brspace -function tbreorg -action reorg -tablespace "<tablespace name>" -table "<table name>" -mode online] to re-org my database after deletion of workflow log.
However, in my DEV system, I have a number of create-client-delete-client and the harddisk space used is getting quite large.
I wanted to free some space in Oracle tablespace, and i am wondering if:
1. Can I use the command above, remove the -table to re-org the table as a whole?
2. Or the tablespace's free area will auto be available after I delete a client?
In another note,
3. Someone here mention that re-index database would improve the database responses after a client-deletion. Is it better to re-index the database periodically or can I safely ignore this until the database get extremely sluggish (this refer to DEV-based system)?
Thank you