Space is going to be full, temporarily unable to increase the room, just thinking of one of the server does not use the system data, search on the Internet a lot of methods, finally couldn't release the space,
After delete all 18 years of table partitioning, delete query table space utilization
The utilization ratio of this thinking will resize table space data files, but still hint contains files outside of the
See
Found index take up the space is large

To ask how to solve

CodePudding user response:

1, delete or partition table, will release the space to the table space, but will not release OS, if you resize the file released into the OS, can in theory, but actual operation is more tedious, involves the movement of the block of data in the table.
2, the commonly used method, the table move and exp/imp or expdp/impdp,

CodePudding user response:

reference 1st floor lhdz_bj response:

1, delete or partition table, will release the space to the table space, but will not release OS, if through the resize the file released into the OS, can in theory, but actual operation is more tedious, involves the movement of the block of data in the table;
2, the commonly used method, the table move and exp/imp or expdp/impdp,

The table move will affect the original table index,?

CodePudding user response:

refer to the second floor zqt153954 response:

Quote: refer to 1st floor lhdz_bj response:

1, delete or partition table, will release the space to the table space, but will not release OS, if you resize the file released into the OS, can in theory, but actual operation is more tedious, involves the movement of the block of data in the table.
2, the commonly used method, the table move and exp/imp or expdp/impdp,

The table move will affect the original table index,

Will, because move, after the rowid of table data has changed, and the index is dependent on the rowid positioning, therefore, affect,

CodePudding user response:

Index directly deleted, built again should not affect the data

CodePudding user response:

reference 4 floor aurealhuang response:

index directly deleted, built again should not affect the data

So I'm going to deal with

CodePudding user response:

To perform the delete after continue to execute the alter table table_name move;

CodePudding user response:

To execute the alter index index_name rebuild; This is the release of the space