cancel
Showing results for 
Search instead for 
Did you mean: 

Re-oraganization in in 4.6c and opracle 9i, Hp unix

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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?

Answers (0)