Skip to main content

Search

Welcome to Tibero GTS!

Prohibition of Adding Files Different from Tablespace Attributes

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.

 

 

 

Related to