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