Skip to Content
0
Former Member
Apr 06, 2012 at 03:40 PM

BR0301E SQL error -54 at location tab_onl_reorg-34, SQL statement:

129 Views

Dear All,

When I re-org a table is give the error "BR0301E SQL error -54 at location tab_onl_reorg-34, SQL statement:" Please find the details of error. Please help me.

BR0301W SQL error -54 at location tab_onl_reorg-51, SQL statement:

'ALTER TABLE "SAPSR3"."PROP" DROP PRIMARY KEY KEEP INDEX'

ORA-00054: resource busy and acquire with NOWAIT specified

BR0280I BRSPACE time stamp: 2012-04-06 20.33.23

BR0640I SQL statement waiting for busy resource:

'ALTER INDEX "SAPSR3"."PROP~0#$" RENAME TO "PROP~0"'

BR0280I BRSPACE time stamp: 2012-04-06 20.34.24

BR0640I SQL statement waiting for busy resource:

'ALTER INDEX "SAPSR3"."PROP~0#$" RENAME TO "PROP~0"'

BR0280I BRSPACE time stamp: 2012-04-06 20.35.24

BR0640I SQL statement waiting for busy resource:

'ALTER INDEX "SAPSR3"."PROP~0#$" RENAME TO "PROP~0"'

BR0280I BRSPACE time stamp: 2012-04-06 20.36.24

BR0640I SQL statement waiting for busy resource:

'ALTER INDEX "SAPSR3"."PROP~0#$" RENAME TO "PROP~0"'

BR0280I BRSPACE time stamp: 2012-04-06 20.37.24

BR0301W SQL error -54 at location tab_onl_reorg-53, SQL statement:

'ALTER INDEX "SAPSR3"."PROP~0#$" RENAME TO "PROP~0"'

ORA-00054: resource busy and acquire with NOWAIT specified

Thanks,

Manas