Solution : https://service.sap.com/sap/support/notes/214995 (SAP Service marketplace login required)
Key words :
LMTS: Locally Managed TablespaceDMTS: Dictionary Managed TablespaceASSM: Automatic Segment Space ManagementDBA_EXTENTS, DBA_FREE_SPACE, DBA_TABLESPACESORA-01575ORA-01631ORA-01632
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 |