Skip to Content
0
Former Member
Feb 03, 2007 at 12:11 AM

Reorganizing a Table with LOB columns?

161 Views

The BRSPACE Documentation states...

BRSPACE also supports the reorganization of tables with all types of large object (LOB) columns. Large objects are recreated with the same physical characteristics as before the reorganization.

I can't figure out the syntax to reorganize a Table and it's LOBs.

Here's the error I get, when I try to reorganize a LOBINDEX. Can anyone explain why I'm sending "SYS_IL0021404147C00007$$", but it's trying to rebuild 'SYS_IL0021404147C0000723706', which it can't find........

sapbwpci01:orabwp 72% brspace -p initBWP.sap -confirm force -s 20 -l E -f idrebuild -a rebuild -s PSAPBWP -o SAPBWP -i "SYS_IL0021404147C00007$$"

BR1001I BRSPACE 6.40 (40)

BR1002I Start of BRSPACE processing: sdunhqqs.idr 2007-02-02 12.56.58

BR0280I BRSPACE time stamp: 2007-02-02 12.56.58

BR1009I Name of database instance: BWP

BR1010I BRSPACE action ID: sdunhqqs

BR1011I BRSPACE function ID: idr

BR1012I BRSPACE function: idrebuild

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRSPACE time stamp: 2007-02-02 12.56.59

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2007-02-02 12.57.06

BR0814I Number of tables/partitions in schema of owner SAPBWP: 22111/10977

BR0814I Number of tables in schema of owner SAPBWPDB: 142

BR0280I BRSPACE time stamp: 2007-02-02 12.57.18

BR0815I Number of indexes/partitions in schema of owner SAPBWP: 30760/61459

BR0815I Number of indexes in schema of owner SAPBWPDB: 224

BR1179E Index(es) 'SYS_IL0021404147C0000723706' not found

BR0182E Checking parameter/option '-i|rebuild_index' failed

BR0280I BRSPACE time stamp: 2007-02-02 12.57.18

BR0669E Cannot continue due to previous warnings or errors

BR0280I BRSPACE time stamp: 2007-02-02 12.57.18

BR0700E Fatal errors occurred - terminating processing...

BR1023I Number of indexes processed: 0

BR1004E BRSPACE function 'idrebuild' failed

BR1008I End of BRSPACE processing: sdunhqqs.idr 2007-02-02 12.57.18

BR0280I BRSPACE time stamp: 2007-02-02 12.57.18

BR1007I BRSPACE terminated with errors

Thanks,

Scott