Solution : https://service.sap.com/sap/support/notes/683075 (SAP Service marketplace login required)
Summary :
This SAP Note focuses on the 'Default Temporary Tablespace' for SAP systems running on Oracle9i, reinforced in SAP Release 6.40 with PSAPTEMP. Main advantages include preventing the SYSTEM tablespace from inadvertent use as a temporary tablespace by assigning it by default, thus ensuring system integrity and reducing unnecessary growth of the SYSTEM tablespace through temporary objects. Enhancements in BR*Tools from Release 6.40 and backup adaptations in BRBACKUP 6.20, which include the exclusion of temporary tablespaces from backups, are also discussed. Methods for management, such as the use of 'ALTER DATABASE' and 'ALTER USER' for tablespace assignments, are detailed.
Key words :
'default temporary tablespace' solution default temporary tablespace - description starting, default temporary tablespace sqlplus sql>select property_value, sql>alter user <username> temporary tablespace <tablespacename>, sqlplus sql>alter database default temporary tablespace, 'alter database default temporary tablespace <tablespace, sqlplus sql>create temporary tablespace, tempfile '<path>' size <size>, sql>select username, default temporary tablespace guarantees, default temporary tablespace means
Related Notes :
| 969674 | Using the Default Permanent Tablespace |
| 905279 | DBUA/Upgrade to 10g: upgrade.xml is not a valid XML file |
| 706625 | Oracle9i: Locally managed SYSTEM tablespace |
| 659946 | FAQ: Temporary tablespaces |
| 635552 | Backing up temporary tablespaces with BRBACKUP |
| 598678 | Oracle 9i: New functions |