reorg_table Failed error during reorganization

[Former Member]

Hi All,

I am getting the following error when performing online reorganization on oracle 9.2.0.6 database using BRSPACE 6.40 (32).

When I try to reorg online to move to a ASSM tablespace, I get the following error:

BR0280I BRSPACE time stamp: 2008-06-17 16.28.20

BR0815I Number of indexes/partitions in schema of owner SAPR3: 36335/5925

BR1107E Table(s) /BIC/EZ4DSD_C21~010 not found

BR0182E Checking parameter/option '-t|reorg_table' failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2008-06-17 16.28.20

I tried giving wildcard "*", but it fails reorg process.

I tried the following commands to drive it:

brspace -f tbreorg -s PSAPFACTI2 -t "*" -n PSAPR3FACT -p 3

brspace -c force -f tbreorg -s PSAPFACTI2 -t "*" -n PSAPR3FACT -p 4

All help will be useful.

Many Thanks,

Nisch

[Former Member · Accepted solution]

Can it be that you try to perform an online reorganization on a pure index tablespace? Please always reorganize the data tablespace - the related indexes will be reorganized implicitly.

[stefan_koehler]

Hello Nisch,

just check this: SE14 -> /BIC/EZ4DSD_C21 -> Extras -> Database object -> Check

The message "BR1107E Table(s) /BIC/EZ4DSD_C21~010 not found" is a little bit misleading, because of the ~010 is no table.. it is an index.

Please check the DDIC consistency with SE14 and maybe create the 010 index for the table /BIC/EZ4DSD_C21.

Regards

Stefan