Document Type | Troubleshooting
Category | Patch/Upgrade
Applicable Product Versions | 6FS07, 7FS01, 7FS02
Error Code | 7002
Document Number | TPATS010
Issue
When adding a file (temp file) different from the tablespace attributes to the tablespace, it should not execute, but there may be a situation where it is added normally.
Cause
When adding or dropping data/temp files, the system is set to allow all data/temp files to be used regardless of the tablespace attributes, causing this issue.
Solutions
Apply a patch so that data/temp files operate only when matching the attributes of the tablespace.
Scenario
Comparison of results before and after applying the patch when adding a file that does not match the tablespace attributes.
SQL> alter tablespace UNDO add tempfile 't255622.dtf' size 100m; --Before patch applied Tablespace 'UNDO' altered. --After patch applied TBR-7002: Unsupported DDL.
Caution
Apply the patch through technical support provided by Tmax Tibero.