SAP Knowledge Base Article - Preview

1866150 - BRSPACE error ORA-01749 - during compress table

Symptom

When using following BRSPACE command for compress tables:

brspace -u / -f tbreorg -s <source_tbs> -t "*" -n <target_tbs> -c ctablobind -lc medium

The following error was displayed in log:

BR0301E SQL error -1749 at location tab_onl_reorg-53, SQL statement:
'GRANT INSERT ON "SAPSR3DB"."DBCHECKORA#$" TO "SYS"'
ORA-01749: you may not GRANT/REVOKE privileges to/from yourself
BR0280I BRSPACE time stamp: 2012-10-10 16.31.48
BR1106E Reorganization of table SAPSR3DB.DBCHECKORA failed


Read more...

Environment

  • SAP systems with Oracle database
  • Not restricted to a product or product version

Keywords

brtools, compressing, compression, BR0301E, SQL_error_-1749, BR1106E, reorganization, oracle_compression, 19c, 18c, 12c, 11g, 10g , KBA , BC-DB-ORA-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.