Solution : https://service.sap.com/sap/support/notes/646681 (SAP Service marketplace login required)
Summary :
SAP Note elucidates the use of BRSPACE for online reorganization of tables in SAP environments with Oracle as the database. From Oracle version 9.2, utilizing the DBMS_REDEFINITION package is possible, albeit certain constraints such as non-handling of LONG and LONG RAW fields persist, demanding manual offline reorganization via Export/Import for those field types. Migrating from dictionary managed tablespaces (DMTs) to locally managed tablespaces (LMTs) is recommended, especially for large tables which might benefit from targeted tablespaces. Timely application of Oracle patches and adhering to SAP Notes regarding data type conversions (e.g., LONG to LOB) is emphasized to avoid compatibility issues. Efficient use of BRTOOLS or BRGUI interfaces is recommended for executing BRSPACE commands.
Key words :
oracle priority recommendations / additional info category consulting validity, customer component bc-db-ora-dba database administration, setenv br_msl 10485760setenv br_dbl 41943040these environment variables, copying large production clients 214995 oracle locally managed tablespaces, br1121e ddl buffer overflow - sql statements longer, sql> connect /sql> alter table sapuser move tablespace <tsp_name>, sysdbasql> alter user sys temporary tablespace psaptemp, /o-intensive database operations 771191 copying bw objects, sql> alter user sapsr3 default tablespace psapsr3usr, br1120e sql statement 'create table' longer
Related Notes :
| 1269911 | FAQ: Chained Rows |
| 988336 | ORACLE: Inconsistencies occur with large objects |
| 835552 | Oracle Database 10g: LONG-LOB migration |
| 828268 | Oracle Database 10g: New functions |
| 806554 | FAQ: I/O-intensive database operations |
| 771191 | Copying BW objects to new tablespaces |
| 748434 | New BRSPACE function "dbcreate" - recreate database |
| 741478 | FAQ: Materialized views |
| 692745 | Termination of table online reorganization with ORA-31600 |
| 686546 | New values for option "-d" of BRSPACE function "-f tbreorg" |
| 680046 | Corrections in BR*Tools Version 6.40 |
| 662900 | Using LMTS in R/3 releases 3.1I-4.6B |
| 647697 | BRSPACE - New tool for Oracle database administration |
| 620803 | Oracle 9i: Automatic Segment Space Management |
| 541538 | FAQ: Reorganization |
| 355771 | Oracle: Explanation of the new tablespace layout |
| 214995 | Oracle locally managed tablespaces in the SAP environment |
| 489690 | CC INFO: Copying large production clients |