Solution : https://service.sap.com/sap/support/notes/214995 (SAP Service marketplace login required)
Key words :
tablespace_name contents extent_man allocatio next_extent----------------- --------- ---------- --------- -----------system permanent dictionary user 16384temp temporary local uniform 1048576rollback_dict permanent dictionary user 40960lmts_auto permanent local systemlmts_uniform permanent local uniform 1048576lmts_dict2local permanent local user 40960explanatory notes, sql> create tablespace local_man_uniform_ts datafile '<path>' size 100m reuse extent management local uniform [size 500k], sql> create tablespace dict_man_ts datafile '<path>' size 100m reuse <storage clause> [extent management dictionary], sql> create tablespace dict_man_ts datafile '<path>' size 100m reuse <storage clause> extent management dictionary, sql> create tablespace local_man_auto_ts datafile '<path>' size 100m reuse extent management local autoallocate, sql> create tablespace local_man_uniform_ts datafile '<path>' size 100m reuse uniform, sql> create tablespace local_man_auto_ts datafile '<path>' size 100m reuse, alter table <table> shrink space create index <indexname> parallel <, sql> create tablespace <tsname> datafile '<path>' size <[, coalesce operations fewer recursive sql calls faster access
Related Notes :
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 787533 | Bad performance/ system lockup due to enqueue waits |
| 745639 | FAQ: Oracle enqueues |
| 706625 | Oracle9i: Locally managed SYSTEM tablespace |
| 682926 | Composite SAP note: Problems with "create/rebuild index" |
| 662900 | Using LMTS in R/3 releases 3.1I-4.6B |
| 659946 | FAQ: Temporary tablespaces |
| 659487 | CC-ERROR: Resource analysis terminates on ORACLE |
| 647697 | BRSPACE - New tool for Oracle database administration |
| 646681 | Reorganization of tables with BRSPACE |
| 626628 | ALE: No release of temporary segments |
| 620803 | Oracle 9i: Automatic Segment Space Management |
| 572060 | Options in the Oracle database during archiving |
| 541538 | FAQ: Reorganization |
| 521264 | Hang situations |
| 515853 | BR905W No tables found to adjust NEXT extent |
| 485755 | ORA-03232: unable to allocate an extent of blocks |
| 483856 | Description of the alerts for Oracle database monitoring |
| 435290 | Description of BRCONNECT 6.10 DB check conditions |
| 416772 | General tablespace types, temporary tablespace parameters |
| 409376 | Use of locally managed tablespaces for SAP R/3 |
| 395943 | exp with compress=y and locally managed tablespaces |