select SEGMENT_NAME, BYTES/1024/1024  MB
from user_segments
where segment_name in (
'STG_ADD_CHARGE_RULE',
'STG_ADDRESS_HIST',
'STG_AUTOPAY_WITHDRAW_DAILY',
'STG_BILL',
'STG_BILL_ACCOUNT',
'STG_BILL_DET',
'STG_BILL_ITEM',
'STG_BILL_METHOD_HIST',
'STG_BROADCAST_QUALITY',
'STG_CCC_ZIP_CODE',
'STG_CODE_MAPPING',
'STG_COMMON_CODE',
'STG_COMPANY',
'STG_CONTRACT',
'STG_CONTRACT_BILL_ACCOUNT',
'STG_CONTRACT_DISCOUNT',
'STG_CONTRACT_SERVICE',
'STG_COUNSEL_DET',
'STG_COUNSEL_RESULT',
'STG_COUNSEL_TYPE',
'STG_CUST_DET_TYPE',
'STG_CUSTOMER',
'STG_CUSTOMER_CHANGE_HIST',
'STG_CYBER_COUNSEL_ACCEPT',
'STG_CYBER_COUNSEL_ANSWER',
'STG_CYBER_MEMBER',
'STG_CYBER_MEMBER_CERTIFICATION',
'STG_DAS_RATING',
'STG_DAS_RATING_ERR',
'STG_HANDSET',
'STG_HANDSET_USE_HIST',
'STG_NOPAY_DET',
'STG_NOPAY_SETTLE',
'STG_ONETIME_CHARGE_HIST',
'STG_ORG',
'STG_PAYMENT',
'STG_PAYMENT_RESULT',
'STG_PREPAY_OVERPAY',
'STG_REFUND',
'STG_SCREEN',
'STG_SELF_SERVICE_USE',
'STG_SKT_DUAL_HANDSET_INFO',
'STG_UPPER_ORG',
'D_AGENCY',
'D_BILL_ITEM',
'D_CENTER',
'D_CHNL_DET_VAS',
'D_CHRG_SVC',
'D_COUNSEL_TYPE',
'D_HANDSET_COMP',
'D_HANDSET_MODEL_MAKE_SEQ',
'D_HEAD_OFFICE',
'D_JISA',
'D_PGM_DET_VAS',
'D_PMS_PRG',
'D_POSI_AGENCY',
'D_PRG_SUB_VAS',
'D_PROC_AGENCY',
'D_PROMOTION',
'D_SCHE_DET_VAS',
'D_SCREEN',
'F_BILL',
'F_BILL_ACCOUNT',
'F_BILL_DET',
'F_BROADCAST_QUALITY',
'F_CONTRACT',
'F_CONTRACT_DAILY',
'F_CONTRACT_DAILY_S1',
'F_CONTRACT_EVENT',
'F_CONTRACT_EVENT_S2',
'F_CONTRACT_S1',
'F_CONTRACT_S2',
'F_CONTRACT_SERVICE',
'F_COUNSEL_DET',
'F_CUSTOMER',
'F_CYBER_COUNSEL_ACCEPT',
'F_CYBER_MEMBER_TUMAS',
'F_NOPAY_DET',
'F_ONETIME_CHARGE',
'F_PAYMENT_DET',
'F_PAYMENT_SUM',
'F_SELF_SERVICE_USE',
'F_TARGET',
'L_ACNT_CRD_OWNR_REL',
'L_AGE',
'L_AGE_BAND',
'L_APLY_RULE',
'L_BAD_STAT',
'L_BILL_CYC',
'L_BILL_DONG',
'L_BILL_GB',
'L_BILL_GU_GUN',
'L_BILL_ITEM_GB',
'L_BILL_METH',
'L_BILL_SIDO',
'L_BRK_AMT_PROC',
'L_BUSI_GB',
'L_CAR_KIND',
'L_CNSL_BIG_TYP',
'L_CNSL_DET_GB',
'L_CNSL_MID_TYP',
'L_CNSL_REQ_TYP',
'L_CNSL_SML_TYP',
'L_COLR_GB',
'L_CONT_DAYS',
'L_CONT_DUR',
'L_CONT_TERM',
'L_CONT_TYP',
'L_CUST_DET_TYP',
'L_CUST_TYPE',
'L_DATE_TUMAS',
'L_DEVICE',
'L_ENT_PTH',
'L_ENTAMT_FREE_RSN',
'L_ENTAMT_PAY_TYP',
'L_EVENT',
'L_GOODS_TYP_GB',
'L_HDSET_OWN_GB',
'L_HDSET_TYP',
'L_HDSET_USE_GB',
'L_INVC_ISUE_TYP',
'L_JOB_DET',
'L_LOC_GB',
'L_MADT_BILL_AGENCY',
'L_MADT_BILL_PAY_METH',
'L_MNDT_PAY_RFND_GB',
'L_NOM_PERS_REL',
'L_NOPAY_MONTH',
'L_ONETIME_BILL_ITEM',
'L_ONETIME_STAT_GB',
'L_PAY_METH',
'L_PAY_SRC',
'L_PROC_TYP',
'L_PROD_GB',
'L_QUARTER',
'L_SEL_UPD_GU',
'L_SEX',
'L_STAT',
'L_STAT_DET',
'L_STAT_RSN',
'L_STOP_DAYS',
'L_STOP_RSN',
'L_USE_GB',
'L_USE_STAT',
'L_WEEKDAY_CD',
'L_WELF_DC_TYP',
'L_WORK_GB',
'L_YEAR',
'L_YN')
order by segment_name
/