Is it ok to re-org OBJ_X_DOCUMENTS table ?

[SteveTiernan]

Hi,

I have a v5 Business Objects Repository within an Oracle 8 database. The problem is the OBJ_X_DOCUMENTS table has over a period of time grown to 2350 extents, I'd like to export/truncate and import this table to reduce number of extents (by also changing next extent size). I notice there is a block_id on this table....does that mean I cant re-org the data (as the storage blocks will change with the import) ??

Thanks in advance
Steve

 

[blom0344]

Steve,

Never tried what you about to attempt, Is there a specific reason why you want to reorganize (rebuild in ORACLE terms) the table. Performance?
In any case I would create a backup of the repository that you can restore if you run into trouble. (Though I can't think why that should happen). I assume the repo is in it's own database?

T. Blom
Information analyst
tbl@shimano-eu.com