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

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Apply the solution mentioned in the below note.

Add the following entry to BRTOOLS profile init<SID>.sap:

_stat_tab_own=brtdba

Note 1605004 - Database Vault: Online Redefinition

Regards,

Venkata S Pagolu.

[Former Member · Accepted solution]

Hi,

I not get any permission issue but i get error "ORA-00054: resource busy and acquire with NOWAIT specified"  resource busy so please suggest.

Thanks,

Manas Sahoo

[Former Member · Accepted solution]

Hi Manas,

This is normal sometimes when the table is being locked for DML operations by other transactions.

The following notes talk about upgrading the brtools and updating the environment variables. Give it a try.

Note 827020 - Workaround for ORA-00054 during reorganization and rebuild

Note 1101528 - Longer runtime of table reorganisation

Br,

Venky

[Former Member · Accepted solution]

Hi Venky,

My brtools version is :

BR1001I BRSPACE 7.00 (28)

If I upgrade it can i avoid the above error.

Thanks,

Manas