SQL> select identifier, round(filesize/1024/1024,0) as mb from tgeg_mailbox order by identifier; IDENTIFIER MB ------------------ ---------- 000000000003540749 4 000000000003540789 3 000000000003540913 3 000000000003543713 0 000000000003543717 0 000000000003543732 0 000000000003543748 0 000000000003543763 0 000000000003543813 0 9 rows selected. SQL> select identifier, count(*) from tgeg_data group by identifier order by identifier; IDENTIFIER COUNT(*) ------------------ ---------- 000000000001058824 1 000000000002028159 1 000000000002077816 1 000000000002077825 1 000000000002077837 1 000000000002077852 1 000000000002077867 1 000000000002123759 1 000000000002123802 1 000000000002123816 1 000000000002123834 1 000000000002123849 1 000000000002126949 1 000000000002126956 1 000000000002126968 1 000000000002126980 1 000000000002126992 1 000000000002127626 1 000000000002127638 1 000000000002127650 1 000000000002127662 1 000000000002127674 1 000000000002183694 1 000000000002183722 1 000000000002184055 1 000000000002184280 1 000000000002184532 1 000000000002184538 1 000000000002184543 1 000000000002184550 1 000000000002184558 1 000000000002184801 1 000000000002184807 1 000000000002184816 1 000000000002184822 1 000000000002184831 1 000000000002184860 1 000000000002184866 1 000000000002184871 1 000000000002184881 1 000000000002184887 1 000000000002184916 1 000000000002184922 1 000000000002184931 1 000000000002184939 1 000000000002184947 1 000000000002185124 1 000000000002185129 1 000000000002185137 1 000000000002185142 1 000000000002185147 1 000000000002188932 1 000000000002189148 1 000000000002190152 1 000000000002377419 1 000000000002552695 1 000000000002757805 1 000000000003524624 1 000000000003525217 1 000000000003525448 1 000000000003525451 1 000000000003525453 1 000000000003525454 1 000000000003525456 1 000000000003525459 1 000000000003525467 1 000000000003525474 1 000000000003525477 1 000000000003525480 1 000000000003525513 1 000000000003525541 1 000000000003525543 1 000000000003525545 1 000000000003525546 1 000000000003525548 1 000000000003525552 1 000000000003525558 1 000000000003526966 1 000000000003527463 149 000000000003527468 1 000000000003527474 1 000000000003527482 1 000000000003527489 1 000000000003527496 1 000000000003527509 1 000000000003527516 1 000000000003527523 1 000000000003527530 1 000000000003527537 1 000000000003527587 1 000000000003527594 1 000000000003527601 1 000000000003527608 1 000000000003527615 1 000000000003527665 1 000000000003527672 1 000000000003527679 1 000000000003527743 1 000000000003527810 1 000000000003527817 1 000000000003527824 1 000000000003528681 1 000000000003532647 1 000000000003540695 4 000000000003540699 4 000000000003540705 4 000000000003540708 4 000000000003540711 4 000000000003540739 1 000000000003540757 1 000000000003540797 1 000000000003540921 1 000000000003541244 1 000000000003543713 1 000000000003543904 1 000000000003543907 1 000000000003543940 1 000000000003543943 1 118 rows selected.