Get the App
SLTechnology News&Howtos  ›  Database  › 

Query whether the tablespace is set to augment

Shulou Source: shulou.com Published: 2022-06-01 12:41:12 09月30日 Update

After logging in to the database table

Enter select TABLESPACE_NAME, AUTOEXTENSIBLE from dba_data_files

The YES field in AUT indicates that the table space sets the self-increment policy, while the display NO indicates that the table space does not have a self-increment policy.

If you need to modify its self-increment, the command is as follows:

Alter database datafile'+ SZCG_ASM_GROUP/szcg/datafile/tbs_dxpt.dbf' autoextend on next 20m

Tags: Space policy command size field data database login input query table query Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Docker Shulou Technology OPPO Reno Xiaomi