Solution : https://service.sap.com/sap/support/notes/666061 (SAP Service marketplace login required)
Summary :
This SAP Note addresses various aspects of database management and performance issues related to Oracle and SAP systems, focusing on database object types, extents, segments, and related functionalities. Key contents include the identification and management of different database object types such as CLUSTER, INDEX, LOB, PACKAGE, and TABLE, among others. The note explains how the type of database objects can be determined using the OBJECT_TYPE field in the DBA_OBJECTS view. It details the definitions, characteristics, and management of extents and segments, including their size configuration and the consequences of insufficient tablespace. Solutions are provided for managing space allocation issues and adjusting storage parameters to prevent system errors like those caused by reaching the MAXEXTENTS limit.
Key words :
alter user <user_name> default tablespace <new_default_tablespace>, system temporarily stores ddl statements, modify default attributes tablespace <tablespace_name>, modify default attributes tablespace <tablespace_name>, frequently asked questions solution 1, alter tablespace <tsp> default storage, pct_increasefrom dba_tablespaceswhere tablespace_name = '<tablespace_name>', modify default attributes storage, dba_free_spacewhere tablespace_name = '<tablespace>'order, table partitions table partitions subdivide
Related Notes :
| 1619092 | STORAGE_NOT_DETERMINATED during Infocube index activation |
| 1570366 | ORA-02220 during transport |
| 855187 | Maintaining the NEXT extents with BR*Tools |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 778784 | Inconsistencies between data class and database container |
| 777615 | Incorrect data class/database container assignment |
| 771191 | Copying BW objects to new tablespaces |
| 745639 | FAQ: Oracle enqueues |
| 722188 | FAQ: Oracle partitioning |
| 599694 | LMTS autoallocate: Extent allocation |
| 588668 | FAQ: Database statistics |
| 568632 | Problems with Disk Storage with temporary tables in BW |
| 541538 | FAQ: Reorganization |
| 539757 | ADD_PARTITION_FAILED |
| 533455 | Terminations due to higher number of extents |
| 500340 | FAQ: LOBS |
| 443767 | Size category for fact and dimension tables (InfoCube) |
| 400241 | Problems with ops$ or sapr3 connect to Oracle |
| 214995 | Oracle locally managed tablespaces in the SAP environment |
| 173910 | Cluster: Termination due to TABLESPACE over-run |
| 154193 | SAPDBA: Reorganizations and ABAP-DDIC |
| 46272 | Implement new data class in technical settings |
| 3807 | Error messages regarding rollback and undo segments |
| 3155 | Termination due to tablespace overflow |