oracle ora-14404,分区表的分区表空间不同引起的删除表空间错误

最新推荐文章于 2021-04-14 11:24:18 发布

weixin_39738152

最新推荐文章于 2021-04-14 11:24:18 发布

阅读量134

点赞数

文章标签： oracle ora-14404

确实user_segment要快一点

SQL> col s for 999999999999999999999

SQL> select sum(bytes) s,segment_name from user_segments where segment_name like 'REN%' group by segment_name;

S SEGMENT_NAME

---------------------- ---------------------------------------------------------------------------------

188284928 REN1

34292826112 RENC

144909860864 REN

已用时间: 00: 00: 00.42

SQL> select sum(bytes) s,segment_name from dba_segments where segment_name like 'REN%' group by segment_name;

S SEGMENT_NAME

---------------------- ---------------------------------------------------------------------------------

34292826112 RENC

188284928 REN1

46068924416 REN_S

7171211264 REN_L

144909860864 REN

已用时间: 00: 00: 00.50

SQL> select sum(bytes) s,segment_name from user_extents where segment_name like 'REN%' group by segment_name;

S SEGMENT_NAME

---------------------- ---------------------------------------------------------------------------------

188284928 REN1

34292826112 RENC

144909860864 REN

已用时间: 00: 00: 01.59

SQL> select sum(bytes) s,segment_name from dba_extents where segment_name like 'REN%' group by segment_name;

S SEGMENT_NAME

---------------------- ---------------------------------------------------------------------------------

34292826112 RENC

188284928 REN1

46068924416 REN_S

7171211264 REN_L

144909860864 REN

已用时间: 00: 00: 01.79

关注