on 05-03-2011 10:57 AM
Hello Experts ,
We are planning to do re-organization , Could you please suggest below points
1) While re-organizationneed to be done for index tablespace also ?
2) How to find raw fileds for a table
3) we have 700GB size of table space and 100 GB free and i am planning to do using export/import method do 100 gb space sufficient or do i need to add extra space
Thanks
Vamsi
1) you cannot reorganize a table without reorganizing its indexes, so yes
2) Not clear, do you think of 'LONG RAW' fields? You can either search in the abap dictionary for those data types you want, or you do a select against dba_tab_columns against the database.
3) Rule of thumb is that exports are at about 10% of the original database size, but only a test export will definitely answer that.
Cheers Michael
Bonus question: why are you doing the reorg?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.