Skip to Content
author's profile photo
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 01:35 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded