BR1121E DDL buffer overflow - SQL statements longer than 5120 KB

[Former Member]

Dear all,

I tried zu reorganize a Tablespace and got the following Error-Message:

BR1124I Starting reorganization of table SAPR3./BIC/FZ_SD02 ...

BR1121E DDL buffer overflow - SQL statements longer than 5120 KB

BR0280I BRSPACE thread 2: time stamp: 2007-12-07 20.51.26

BR1119E Creation of DDL statements for table SAPR3./BIC/FZ_SD02 failed

We use Oracle 10.2.0.2 + BRSPACE 7.00 (26) + SAP NetWeaver 2004s (SAP BASIS 7.0 PL12)

Can anyone help me to solve this issue

Regards

Carsten

[Former Member · Accepted solution]

Dear Carsten,

please see OSS #646681 - Reorganizing tables with BRSPACE:

"

Remark 10:

-

---

In the case of tables that have a lot of partitions (several thousand), the following terminations can occur, which are caused by the length of the DDL statement:

BR1120E SQL statement 'CREATE TABLE' longer than 1024 KB"

BR1121E DDL buffer overflow - SQL statements longer than 5120 KB.

The internal buffers in BRSPACE allow tables with up to approximately 3,500 partitions to be reorganized, provided that they do not have more than four indexes. If you have even larger tables (in terms of the number of partitions/indexes) and the above-mentioned errors occur, set the following environment variables to avoid them:

setenv BR_MSL 10485760

setenv BR_DBL 41943040

These environment variables will increase the internal buffers in BRSPACE tenfold, so that no problems should occur with large tables. Now you can repeat the reorganization for the affected tables.

"

Regards

Sascha

[Former Member · Accepted solution]

Hello Sascha,

thank you very much for your help.

I have read this SAP-Note but at the time I read the SAP-Note I did not have this Problem.

I set the variables and started the reorganization and its works fine

Best regards

Carsten

[Former Member]

Hello,

BR_DBL sets the value for the DDL buffer

BR_MSL sets the value for the CREATE statements

You may increase to higher values should the recommended values do not help.