| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268 |
- SQL> /
- 'PROMPT-------'||CHR(10)||'PROMPT'||OWNER||'.'||TABLE_NAME||';'||CHR(10)||'SELEC
- --------------------------------------------------------------------------------
- prompt -------
- prompt MDMADM.CI_ACC_GRP;
- select count(*) as "CNT" from MDMADM.CI_ACC_GRP;
-
- prompt -------
- prompt MDMADM.CI_ACC_GRP_DAR;
- select count(*) as "CNT" from MDMADM.CI_ACC_GRP_DAR;
-
- prompt -------
- prompt MDMADM.CI_ACC_GRP_L;
- select count(*) as "CNT" from MDMADM.CI_ACC_GRP_L;
-
- prompt -------
- prompt MDMADM.CI_ALG;
- select count(*) as "CNT" from MDMADM.CI_ALG;
-
- prompt -------
- prompt MDMADM.CI_ALG_L;
- select count(*) as "CNT" from MDMADM.CI_ALG_L;
-
- prompt -------
- prompt MDMADM.CI_ALG_PARM;
- select count(*) as "CNT" from MDMADM.CI_ALG_PARM;
-
- prompt -------
- prompt MDMADM.CI_ALG_TYPE;
- select count(*) as "CNT" from MDMADM.CI_ALG_TYPE;
-
- prompt -------
- prompt MDMADM.CI_ALG_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_ALG_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_ALG_TYPE_PRM;
- select count(*) as "CNT" from MDMADM.CI_ALG_TYPE_PRM;
-
- prompt -------
- prompt MDMADM.CI_ALG_TYPE_PRM_L;
- select count(*) as "CNT" from MDMADM.CI_ALG_TYPE_PRM_L;
-
- prompt -------
- prompt MDMADM.CI_ALG_VER;
- select count(*) as "CNT" from MDMADM.CI_ALG_VER;
-
- prompt -------
- prompt MDMADM.CI_APP_SVC_ACC;
- select count(*) as "CNT" from MDMADM.CI_APP_SVC_ACC;
-
- prompt -------
- prompt MDMADM.CI_APP_SVC_SCTY;
- select count(*) as "CNT" from MDMADM.CI_APP_SVC_SCTY;
-
- prompt -------
- prompt MDMADM.CI_ARC_ROOT_INST;
- select count(*) as "CNT" from MDMADM.CI_ARC_ROOT_INST;
-
- prompt -------
- prompt MDMADM.CI_ARC_ROOT_INST_K;
- select count(*) as "CNT" from MDMADM.CI_ARC_ROOT_INST_K;
-
- prompt -------
- prompt MDMADM.CI_ARC_ROOT_OBJ;
- select count(*) as "CNT" from MDMADM.CI_ARC_ROOT_OBJ;
-
- prompt -------
- prompt MDMADM.CI_ARC_ROOT_OBJ_K;
- select count(*) as "CNT" from MDMADM.CI_ARC_ROOT_OBJ_K;
-
- prompt -------
- prompt MDMADM.CI_ARC_ROOT_PK;
- select count(*) as "CNT" from MDMADM.CI_ARC_ROOT_PK;
-
- prompt -------
- prompt MDMADM.CI_AUDIT;
- select count(*) as "CNT" from MDMADM.CI_AUDIT;
-
- prompt -------
- prompt MDMADM.CI_AUDIT_K;
- select count(*) as "CNT" from MDMADM.CI_AUDIT_K;
-
- prompt -------
- prompt MDMADM.CI_BATCH_CTRL;
- select count(*) as "CNT" from MDMADM.CI_BATCH_CTRL;
-
- prompt -------
- prompt MDMADM.CI_BATCH_CTRL_ALG;
- select count(*) as "CNT" from MDMADM.CI_BATCH_CTRL_ALG;
-
- prompt -------
- prompt MDMADM.CI_BATCH_CTRL_L;
- select count(*) as "CNT" from MDMADM.CI_BATCH_CTRL_L;
-
- prompt -------
- prompt MDMADM.CI_BATCH_CTRL_P;
- select count(*) as "CNT" from MDMADM.CI_BATCH_CTRL_P;
-
- prompt -------
- prompt MDMADM.CI_BATCH_CTRL_P_L;
- select count(*) as "CNT" from MDMADM.CI_BATCH_CTRL_P_L;
-
- prompt -------
- prompt MDMADM.CI_BATCH_INST;
- select count(*) as "CNT" from MDMADM.CI_BATCH_INST;
-
- prompt -------
- prompt MDMADM.CI_BATCH_JOB;
- select count(*) as "CNT" from MDMADM.CI_BATCH_JOB;
-
- prompt -------
- prompt MDMADM.CI_BATCH_JOB_K;
- select count(*) as "CNT" from MDMADM.CI_BATCH_JOB_K;
-
- prompt -------
- prompt MDMADM.CI_BATCH_JOB_PRM;
- select count(*) as "CNT" from MDMADM.CI_BATCH_JOB_PRM;
-
- prompt -------
- prompt MDMADM.CI_BATCH_RUN;
- select count(*) as "CNT" from MDMADM.CI_BATCH_RUN;
-
- prompt -------
- prompt MDMADM.CI_BATCH_THD;
- select count(*) as "CNT" from MDMADM.CI_BATCH_THD;
-
- prompt -------
- prompt MDMADM.CI_CAL_HOL;
- select count(*) as "CNT" from MDMADM.CI_CAL_HOL;
-
- prompt -------
- prompt MDMADM.CI_CAL_HOL_L;
- select count(*) as "CNT" from MDMADM.CI_CAL_HOL_L;
-
- prompt -------
- prompt MDMADM.CI_CAL_WORK;
- select count(*) as "CNT" from MDMADM.CI_CAL_WORK;
-
- prompt -------
- prompt MDMADM.CI_CAL_WORK_L;
- select count(*) as "CNT" from MDMADM.CI_CAL_WORK_L;
-
- prompt -------
- prompt MDMADM.CI_CHAR_ENTITY;
- select count(*) as "CNT" from MDMADM.CI_CHAR_ENTITY;
-
- prompt -------
- prompt MDMADM.CI_CHAR_TYPE;
- select count(*) as "CNT" from MDMADM.CI_CHAR_TYPE;
-
- prompt -------
- prompt MDMADM.CI_CHAR_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_CHAR_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_CHAR_VAL;
- select count(*) as "CNT" from MDMADM.CI_CHAR_VAL;
-
- prompt -------
- prompt MDMADM.CI_CHAR_VAL_L;
- select count(*) as "CNT" from MDMADM.CI_CHAR_VAL_L;
-
- prompt -------
- prompt MDMADM.CI_CHTY_TDTY;
- select count(*) as "CNT" from MDMADM.CI_CHTY_TDTY;
-
- prompt -------
- prompt MDMADM.CI_CNV_DUP_KEY;
- select count(*) as "CNT" from MDMADM.CI_CNV_DUP_KEY;
-
- prompt -------
- prompt MDMADM.CI_CNV_KEY_TMP;
- select count(*) as "CNT" from MDMADM.CI_CNV_KEY_TMP;
-
- prompt -------
- prompt MDMADM.CI_COUNTRY;
- select count(*) as "CNT" from MDMADM.CI_COUNTRY;
-
- prompt -------
- prompt MDMADM.CI_COUNTRY_L;
- select count(*) as "CNT" from MDMADM.CI_COUNTRY_L;
-
- prompt -------
- prompt MDMADM.CI_CURRENCY_CD;
- select count(*) as "CNT" from MDMADM.CI_CURRENCY_CD;
-
- prompt -------
- prompt MDMADM.CI_CURRENCY_CD_L;
- select count(*) as "CNT" from MDMADM.CI_CURRENCY_CD_L;
-
- prompt -------
- prompt MDMADM.CI_DAR;
- select count(*) as "CNT" from MDMADM.CI_DAR;
-
- prompt -------
- prompt MDMADM.CI_DAR_L;
- select count(*) as "CNT" from MDMADM.CI_DAR_L;
-
- prompt -------
- prompt MDMADM.CI_DAR_USR;
- select count(*) as "CNT" from MDMADM.CI_DAR_USR;
-
- prompt -------
- prompt MDMADM.CI_DATA_DIFF;
- select count(*) as "CNT" from MDMADM.CI_DATA_DIFF;
-
- prompt -------
- prompt MDMADM.CI_DATA_DIFF_PK;
- select count(*) as "CNT" from MDMADM.CI_DATA_DIFF_PK;
-
- prompt -------
- prompt MDMADM.CI_DB_INSTR;
- select count(*) as "CNT" from MDMADM.CI_DB_INSTR;
-
- prompt -------
- prompt MDMADM.CI_DB_INSTR_ALG;
- select count(*) as "CNT" from MDMADM.CI_DB_INSTR_ALG;
-
- prompt -------
- prompt MDMADM.CI_DB_INSTR_L;
- select count(*) as "CNT" from MDMADM.CI_DB_INSTR_L;
-
- prompt -------
- prompt MDMADM.CI_DB_INST_OVRD;
- select count(*) as "CNT" from MDMADM.CI_DB_INST_OVRD;
-
- prompt -------
- prompt MDMADM.CI_DB_PROC;
- select count(*) as "CNT" from MDMADM.CI_DB_PROC;
-
- prompt -------
- prompt MDMADM.CI_DB_PROC_L;
- select count(*) as "CNT" from MDMADM.CI_DB_PROC_L;
-
- prompt -------
- prompt MDMADM.CI_DISP_ICON;
- select count(*) as "CNT" from MDMADM.CI_DISP_ICON;
-
- prompt -------
- prompt MDMADM.CI_DISP_ICON_L;
- select count(*) as "CNT" from MDMADM.CI_DISP_ICON_L;
-
- prompt -------
- prompt MDMADM.CI_DISP_PROF;
- select count(*) as "CNT" from MDMADM.CI_DISP_PROF;
-
- prompt -------
- prompt MDMADM.CI_DISP_PROF_L;
- select count(*) as "CNT" from MDMADM.CI_DISP_PROF_L;
-
- prompt -------
- prompt MDMADM.CI_ENV_REF;
- select count(*) as "CNT" from MDMADM.CI_ENV_REF;
-
- prompt -------
- prompt MDMADM.CI_ENV_REF_L;
- select count(*) as "CNT" from MDMADM.CI_ENV_REF_L;
-
- prompt -------
- prompt MDMADM.CI_FK_REF;
- select count(*) as "CNT" from MDMADM.CI_FK_REF;
-
- prompt -------
- prompt MDMADM.CI_FK_REF_L;
- select count(*) as "CNT" from MDMADM.CI_FK_REF_L;
-
- prompt -------
- prompt MDMADM.CI_FUNC;
- select count(*) as "CNT" from MDMADM.CI_FUNC;
-
- prompt -------
- prompt MDMADM.CI_FUNC_FLD;
- select count(*) as "CNT" from MDMADM.CI_FUNC_FLD;
-
- prompt -------
- prompt MDMADM.CI_FUNC_FLD_L;
- select count(*) as "CNT" from MDMADM.CI_FUNC_FLD_L;
-
- prompt -------
- prompt MDMADM.CI_FUNC_L;
- select count(*) as "CNT" from MDMADM.CI_FUNC_L;
-
- prompt -------
- prompt MDMADM.CI_GEO_TYPE;
- select count(*) as "CNT" from MDMADM.CI_GEO_TYPE;
-
- prompt -------
- prompt MDMADM.CI_GEO_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_GEO_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_INSTALL_ALG;
- select count(*) as "CNT" from MDMADM.CI_INSTALL_ALG;
-
- prompt -------
- prompt MDMADM.CI_INSTALL_MSG;
- select count(*) as "CNT" from MDMADM.CI_INSTALL_MSG;
-
- prompt -------
- prompt MDMADM.CI_INSTALL_MSG_L;
- select count(*) as "CNT" from MDMADM.CI_INSTALL_MSG_L;
-
- prompt -------
- prompt MDMADM.CI_INSTALL_PROD;
- select count(*) as "CNT" from MDMADM.CI_INSTALL_PROD;
-
- prompt -------
- prompt MDMADM.CI_LANGUAGE;
- select count(*) as "CNT" from MDMADM.CI_LANGUAGE;
-
- prompt -------
- prompt MDMADM.CI_LOOKUP_FIELD;
- select count(*) as "CNT" from MDMADM.CI_LOOKUP_FIELD;
-
- prompt -------
- prompt MDMADM.CI_LOOKUP_VAL;
- select count(*) as "CNT" from MDMADM.CI_LOOKUP_VAL;
-
- prompt -------
- prompt MDMADM.CI_LOOKUP_VAL_L;
- select count(*) as "CNT" from MDMADM.CI_LOOKUP_VAL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_ATT_TY;
- select count(*) as "CNT" from MDMADM.CI_MD_ATT_TY;
-
- prompt -------
- prompt MDMADM.CI_MD_AT_DTL;
- select count(*) as "CNT" from MDMADM.CI_MD_AT_DTL;
-
- prompt -------
- prompt MDMADM.CI_MD_AT_DTL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_AT_DTL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_CONST;
- select count(*) as "CNT" from MDMADM.CI_MD_CONST;
-
- prompt -------
- prompt MDMADM.CI_MD_CONST_FLD;
- select count(*) as "CNT" from MDMADM.CI_MD_CONST_FLD;
-
- prompt -------
- prompt MDMADM.CI_MD_CTL;
- select count(*) as "CNT" from MDMADM.CI_MD_CTL;
-
- prompt -------
- prompt MDMADM.CI_MD_CTL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_CTL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_CTL_TMPL;
- select count(*) as "CNT" from MDMADM.CI_MD_CTL_TMPL;
-
- prompt -------
- prompt MDMADM.CI_MD_ELTY;
- select count(*) as "CNT" from MDMADM.CI_MD_ELTY;
-
- prompt -------
- prompt MDMADM.CI_MD_ELTY_AT;
- select count(*) as "CNT" from MDMADM.CI_MD_ELTY_AT;
-
- prompt -------
- prompt MDMADM.CI_MD_ELTY_L;
- select count(*) as "CNT" from MDMADM.CI_MD_ELTY_L;
-
- prompt -------
- prompt MDMADM.CI_MD_FLD;
- select count(*) as "CNT" from MDMADM.CI_MD_FLD;
-
- prompt -------
- prompt MDMADM.CI_MD_FLD_L;
- select count(*) as "CNT" from MDMADM.CI_MD_FLD_L;
-
- prompt -------
- prompt MDMADM.CI_MD_LOOKUP_F;
- select count(*) as "CNT" from MDMADM.CI_MD_LOOKUP_F;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_IMOD;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_IMOD;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_ITEM;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_ITEM;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_ITEM_L;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_ITEM_L;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_L;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_L;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_LINE;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_LINE;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_LINE_L;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_LINE_L;
-
- prompt -------
- prompt MDMADM.CI_MD_MENU_MOD;
- select count(*) as "CNT" from MDMADM.CI_MD_MENU_MOD;
-
- prompt -------
- prompt MDMADM.CI_MD_MO;
- select count(*) as "CNT" from MDMADM.CI_MD_MO;
-
- prompt -------
- prompt MDMADM.CI_MD_MO_ALG;
- select count(*) as "CNT" from MDMADM.CI_MD_MO_ALG;
-
- prompt -------
- prompt MDMADM.CI_MD_MO_L;
- select count(*) as "CNT" from MDMADM.CI_MD_MO_L;
-
- prompt -------
- prompt MDMADM.CI_MD_MO_OPT;
- select count(*) as "CNT" from MDMADM.CI_MD_MO_OPT;
-
- prompt -------
- prompt MDMADM.CI_MD_MO_TBL;
- select count(*) as "CNT" from MDMADM.CI_MD_MO_TBL;
-
- prompt -------
- prompt MDMADM.CI_MD_MO_WRK;
- select count(*) as "CNT" from MDMADM.CI_MD_MO_WRK;
-
- prompt -------
- prompt MDMADM.CI_MD_MSG;
- select count(*) as "CNT" from MDMADM.CI_MD_MSG;
-
- prompt -------
- prompt MDMADM.CI_MD_MSG_L;
- select count(*) as "CNT" from MDMADM.CI_MD_MSG_L;
-
- prompt -------
- prompt MDMADM.CI_MD_NAV;
- select count(*) as "CNT" from MDMADM.CI_MD_NAV;
-
- prompt -------
- prompt MDMADM.CI_MD_PDF;
- select count(*) as "CNT" from MDMADM.CI_MD_PDF;
-
- prompt -------
- prompt MDMADM.CI_MD_PDF_VAL;
- select count(*) as "CNT" from MDMADM.CI_MD_PDF_VAL;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_COM;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_COM;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_ELEM;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_ELEM;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_EL_AT;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_EL_AT;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_LOC;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_LOC;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_MOD;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_MOD;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_SEC;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_SEC;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_SQL;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_SQL;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_TAB;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_TAB;
-
- prompt -------
- prompt MDMADM.CI_MD_PRG_VAR;
- select count(*) as "CNT" from MDMADM.CI_MD_PRG_VAR;
-
- prompt -------
- prompt MDMADM.CI_MD_RPT;
- select count(*) as "CNT" from MDMADM.CI_MD_RPT;
-
- prompt -------
- prompt MDMADM.CI_MD_RPT_L;
- select count(*) as "CNT" from MDMADM.CI_MD_RPT_L;
-
- prompt -------
- prompt MDMADM.CI_MD_RPT_LBL;
- select count(*) as "CNT" from MDMADM.CI_MD_RPT_LBL;
-
- prompt -------
- prompt MDMADM.CI_MD_RPT_PARM;
- select count(*) as "CNT" from MDMADM.CI_MD_RPT_PARM;
-
- prompt -------
- prompt MDMADM.CI_MD_RPT_PARM_L;
- select count(*) as "CNT" from MDMADM.CI_MD_RPT_PARM_L;
-
- prompt -------
- prompt MDMADM.CI_MD_SO;
- select count(*) as "CNT" from MDMADM.CI_MD_SO;
-
- prompt -------
- prompt MDMADM.CI_MD_SOCG;
- select count(*) as "CNT" from MDMADM.CI_MD_SOCG;
-
- prompt -------
- prompt MDMADM.CI_MD_SOCG_FLD;
- select count(*) as "CNT" from MDMADM.CI_MD_SOCG_FLD;
-
- prompt -------
- prompt MDMADM.CI_MD_SOCG_FLDAT;
- select count(*) as "CNT" from MDMADM.CI_MD_SOCG_FLDAT;
-
- prompt -------
- prompt MDMADM.CI_MD_SOCG_L;
- select count(*) as "CNT" from MDMADM.CI_MD_SOCG_L;
-
- prompt -------
- prompt MDMADM.CI_MD_SOCG_SORT;
- select count(*) as "CNT" from MDMADM.CI_MD_SOCG_SORT;
-
- prompt -------
- prompt MDMADM.CI_MD_SO_L;
- select count(*) as "CNT" from MDMADM.CI_MD_SO_L;
-
- prompt -------
- prompt MDMADM.CI_MD_SO_RSFLD;
- select count(*) as "CNT" from MDMADM.CI_MD_SO_RSFLD;
-
- prompt -------
- prompt MDMADM.CI_MD_SO_RSFLDAT;
- select count(*) as "CNT" from MDMADM.CI_MD_SO_RSFLDAT;
-
- prompt -------
- prompt MDMADM.CI_MD_SRC_TYPE;
- select count(*) as "CNT" from MDMADM.CI_MD_SRC_TYPE;
-
- prompt -------
- prompt MDMADM.CI_MD_SRC_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_MD_SRC_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_MD_SVC;
- select count(*) as "CNT" from MDMADM.CI_MD_SVC;
-
- prompt -------
- prompt MDMADM.CI_MD_SVC_L;
- select count(*) as "CNT" from MDMADM.CI_MD_SVC_L;
-
- prompt -------
- prompt MDMADM.CI_MD_SVC_PRG;
- select count(*) as "CNT" from MDMADM.CI_MD_SVC_PRG;
-
- prompt -------
- prompt MDMADM.CI_MD_TAB_MOD;
- select count(*) as "CNT" from MDMADM.CI_MD_TAB_MOD;
-
- prompt -------
- prompt MDMADM.CI_MD_TBL;
- select count(*) as "CNT" from MDMADM.CI_MD_TBL;
-
- prompt -------
- prompt MDMADM.CI_MD_TBL_FLD;
- select count(*) as "CNT" from MDMADM.CI_MD_TBL_FLD;
-
- prompt -------
- prompt MDMADM.CI_MD_TBL_FLD_L;
- select count(*) as "CNT" from MDMADM.CI_MD_TBL_FLD_L;
-
- prompt -------
- prompt MDMADM.CI_MD_TBL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_TBL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_TMPL;
- select count(*) as "CNT" from MDMADM.CI_MD_TMPL;
-
- prompt -------
- prompt MDMADM.CI_MD_TMPL_ELTY;
- select count(*) as "CNT" from MDMADM.CI_MD_TMPL_ELTY;
-
- prompt -------
- prompt MDMADM.CI_MD_TMPL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_TMPL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_TMPL_VAR;
- select count(*) as "CNT" from MDMADM.CI_MD_TMPL_VAR;
-
- prompt -------
- prompt MDMADM.CI_MD_TMPL_VAR_L;
- select count(*) as "CNT" from MDMADM.CI_MD_TMPL_VAR_L;
-
- prompt -------
- prompt MDMADM.CI_MD_TOOLREP_XML;
- select count(*) as "CNT" from MDMADM.CI_MD_TOOLREP_XML;
-
- prompt -------
- prompt MDMADM.CI_MD_TOOL_REP;
- select count(*) as "CNT" from MDMADM.CI_MD_TOOL_REP;
-
- prompt -------
- prompt MDMADM.CI_MD_VAR;
- select count(*) as "CNT" from MDMADM.CI_MD_VAR;
-
- prompt -------
- prompt MDMADM.CI_MD_VAR_DTL;
- select count(*) as "CNT" from MDMADM.CI_MD_VAR_DTL;
-
- prompt -------
- prompt MDMADM.CI_MD_VAR_DTL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_VAR_DTL_L;
-
- prompt -------
- prompt MDMADM.CI_MD_WRK_TBL;
- select count(*) as "CNT" from MDMADM.CI_MD_WRK_TBL;
-
- prompt -------
- prompt MDMADM.CI_MD_WRK_TBLFLD;
- select count(*) as "CNT" from MDMADM.CI_MD_WRK_TBLFLD;
-
- prompt -------
- prompt MDMADM.CI_MD_WRK_TBL_L;
- select count(*) as "CNT" from MDMADM.CI_MD_WRK_TBL_L;
-
- prompt -------
- prompt MDMADM.CI_MPL_EXC;
- select count(*) as "CNT" from MDMADM.CI_MPL_EXC;
-
- prompt -------
- prompt MDMADM.CI_MSG;
- select count(*) as "CNT" from MDMADM.CI_MSG;
-
- prompt -------
- prompt MDMADM.CI_MSG_CATEGORY;
- select count(*) as "CNT" from MDMADM.CI_MSG_CATEGORY;
-
- prompt -------
- prompt MDMADM.CI_MSG_CATEGORY_L;
- select count(*) as "CNT" from MDMADM.CI_MSG_CATEGORY_L;
-
- prompt -------
- prompt MDMADM.CI_MSG_L;
- select count(*) as "CNT" from MDMADM.CI_MSG_L;
-
- prompt -------
- prompt MDMADM.CI_MSG_LOG;
- select count(*) as "CNT" from MDMADM.CI_MSG_LOG;
-
- prompt -------
- prompt MDMADM.CI_MSG_LOGPARM;
- select count(*) as "CNT" from MDMADM.CI_MSG_LOGPARM;
-
- prompt -------
- prompt MDMADM.CI_MSG_LOG_PK;
- select count(*) as "CNT" from MDMADM.CI_MSG_LOG_PK;
-
- prompt -------
- prompt MDMADM.CI_NAV_OPT;
- select count(*) as "CNT" from MDMADM.CI_NAV_OPT;
-
- prompt -------
- prompt MDMADM.CI_NAV_OPT_CTXT;
- select count(*) as "CNT" from MDMADM.CI_NAV_OPT_CTXT;
-
- prompt -------
- prompt MDMADM.CI_NAV_OPT_L;
- select count(*) as "CNT" from MDMADM.CI_NAV_OPT_L;
-
- prompt -------
- prompt MDMADM.CI_NAV_OPT_USG;
- select count(*) as "CNT" from MDMADM.CI_NAV_OPT_USG;
-
- prompt -------
- prompt MDMADM.CI_NT_DNTY_CTXT;
- select count(*) as "CNT" from MDMADM.CI_NT_DNTY_CTXT;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_CHAR;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_CHAR;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_CTXT;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_CTXT;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_EXC;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_EXC;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_EXP;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_EXP;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_FORM;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_FORM;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_FORM_L;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_FORM_L;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_K;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_K;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_PROF;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_PROF;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_PROF_L;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_PROF_L;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_TYPE;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_TYPE;
-
- prompt -------
- prompt MDMADM.CI_NT_DWN_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_NT_DWN_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_NT_UP;
- select count(*) as "CNT" from MDMADM.CI_NT_UP;
-
- prompt -------
- prompt MDMADM.CI_NT_UP_CHAR;
- select count(*) as "CNT" from MDMADM.CI_NT_UP_CHAR;
-
- prompt -------
- prompt MDMADM.CI_NT_UP_CTXT;
- select count(*) as "CNT" from MDMADM.CI_NT_UP_CTXT;
-
- prompt -------
- prompt MDMADM.CI_NT_UP_EXCP;
- select count(*) as "CNT" from MDMADM.CI_NT_UP_EXCP;
-
- prompt -------
- prompt MDMADM.CI_NT_UP_XTYPE;
- select count(*) as "CNT" from MDMADM.CI_NT_UP_XTYPE;
-
- prompt -------
- prompt MDMADM.CI_NT_UP_XTYPE_L;
- select count(*) as "CNT" from MDMADM.CI_NT_UP_XTYPE_L;
-
- prompt -------
- prompt MDMADM.CI_NT_XID;
- select count(*) as "CNT" from MDMADM.CI_NT_XID;
-
- prompt -------
- prompt MDMADM.CI_NT_XID_L;
- select count(*) as "CNT" from MDMADM.CI_NT_XID_L;
-
- prompt -------
- prompt MDMADM.CI_PHONE_TYPE;
- select count(*) as "CNT" from MDMADM.CI_PHONE_TYPE;
-
- prompt -------
- prompt MDMADM.CI_PHONE_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_PHONE_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_PORTAL;
- select count(*) as "CNT" from MDMADM.CI_PORTAL;
-
- prompt -------
- prompt MDMADM.CI_PORTAL_L;
- select count(*) as "CNT" from MDMADM.CI_PORTAL_L;
-
- prompt -------
- prompt MDMADM.CI_PORTAL_ZONE;
- select count(*) as "CNT" from MDMADM.CI_PORTAL_ZONE;
-
- prompt -------
- prompt MDMADM.CI_ROLE;
- select count(*) as "CNT" from MDMADM.CI_ROLE;
-
- prompt -------
- prompt MDMADM.CI_ROLE_L;
- select count(*) as "CNT" from MDMADM.CI_ROLE_L;
-
- prompt -------
- prompt MDMADM.CI_ROLE_USER;
- select count(*) as "CNT" from MDMADM.CI_ROLE_USER;
-
- prompt -------
- prompt MDMADM.CI_ROOT_DIFF;
- select count(*) as "CNT" from MDMADM.CI_ROOT_DIFF;
-
- prompt -------
- prompt MDMADM.CI_ROOT_INSTR;
- select count(*) as "CNT" from MDMADM.CI_ROOT_INSTR;
-
- prompt -------
- prompt MDMADM.CI_ROOT_INSTR_K;
- select count(*) as "CNT" from MDMADM.CI_ROOT_INSTR_K;
-
- prompt -------
- prompt MDMADM.CI_ROOT_OBJ;
- select count(*) as "CNT" from MDMADM.CI_ROOT_OBJ;
-
- prompt -------
- prompt MDMADM.CI_ROOT_OBJ_EXC;
- select count(*) as "CNT" from MDMADM.CI_ROOT_OBJ_EXC;
-
- prompt -------
- prompt MDMADM.CI_ROOT_OBJ_EXP;
- select count(*) as "CNT" from MDMADM.CI_ROOT_OBJ_EXP;
-
- prompt -------
- prompt MDMADM.CI_ROOT_OBJ_K;
- select count(*) as "CNT" from MDMADM.CI_ROOT_OBJ_K;
-
- prompt -------
- prompt MDMADM.CI_ROOT_OBJ_PK;
- select count(*) as "CNT" from MDMADM.CI_ROOT_OBJ_PK;
-
- prompt -------
- prompt MDMADM.CI_RPT_OPTION;
- select count(*) as "CNT" from MDMADM.CI_RPT_OPTION;
-
- prompt -------
- prompt MDMADM.CI_SCR;
- select count(*) as "CNT" from MDMADM.CI_SCR;
-
- prompt -------
- prompt MDMADM.CI_SCR_CRT;
- select count(*) as "CNT" from MDMADM.CI_SCR_CRT;
-
- prompt -------
- prompt MDMADM.CI_SCR_CRT_GRP;
- select count(*) as "CNT" from MDMADM.CI_SCR_CRT_GRP;
-
- prompt -------
- prompt MDMADM.CI_SCR_CRT_GRP_L;
- select count(*) as "CNT" from MDMADM.CI_SCR_CRT_GRP_L;
-
- prompt -------
- prompt MDMADM.CI_SCR_DA;
- select count(*) as "CNT" from MDMADM.CI_SCR_DA;
-
- prompt -------
- prompt MDMADM.CI_SCR_FLD_MAP;
- select count(*) as "CNT" from MDMADM.CI_SCR_FLD_MAP;
-
- prompt -------
- prompt MDMADM.CI_SCR_L;
- select count(*) as "CNT" from MDMADM.CI_SCR_L;
-
- prompt -------
- prompt MDMADM.CI_SCR_PRMPT;
- select count(*) as "CNT" from MDMADM.CI_SCR_PRMPT;
-
- prompt -------
- prompt MDMADM.CI_SCR_PRMPT_L;
- select count(*) as "CNT" from MDMADM.CI_SCR_PRMPT_L;
-
- prompt -------
- prompt MDMADM.CI_SCR_STEP;
- select count(*) as "CNT" from MDMADM.CI_SCR_STEP;
-
- prompt -------
- prompt MDMADM.CI_SCR_STEP_L;
- select count(*) as "CNT" from MDMADM.CI_SCR_STEP_L;
-
- prompt -------
- prompt MDMADM.CI_SC_AUTH_LVL;
- select count(*) as "CNT" from MDMADM.CI_SC_AUTH_LVL;
-
- prompt -------
- prompt MDMADM.CI_SC_AUTH_LVL_L;
- select count(*) as "CNT" from MDMADM.CI_SC_AUTH_LVL_L;
-
- prompt -------
- prompt MDMADM.CI_SC_TYPE;
- select count(*) as "CNT" from MDMADM.CI_SC_TYPE;
-
- prompt -------
- prompt MDMADM.CI_SC_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_SC_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_SEAS_SHIFT;
- select count(*) as "CNT" from MDMADM.CI_SEAS_SHIFT;
-
- prompt -------
- prompt MDMADM.CI_SEAS_TM_SHIFT;
- select count(*) as "CNT" from MDMADM.CI_SEAS_TM_SHIFT;
-
- prompt -------
- prompt MDMADM.CI_SEAS_TM_SHIFT_L;
- select count(*) as "CNT" from MDMADM.CI_SEAS_TM_SHIFT_L;
-
- prompt -------
- prompt MDMADM.CI_SEQ;
- select count(*) as "CNT" from MDMADM.CI_SEQ;
-
- prompt -------
- prompt MDMADM.CI_STATE;
- select count(*) as "CNT" from MDMADM.CI_STATE;
-
- prompt -------
- prompt MDMADM.CI_STATE_L;
- select count(*) as "CNT" from MDMADM.CI_STATE_L;
-
- prompt -------
- prompt MDMADM.CI_SYSDATA_LOG;
- select count(*) as "CNT" from MDMADM.CI_SYSDATA_LOG;
-
- prompt -------
- prompt MDMADM.CI_TD_DRLKEY;
- select count(*) as "CNT" from MDMADM.CI_TD_DRLKEY;
-
- prompt -------
- prompt MDMADM.CI_TD_DRLKEY_TY;
- select count(*) as "CNT" from MDMADM.CI_TD_DRLKEY_TY;
-
- prompt -------
- prompt MDMADM.CI_TD_ENTRY;
- select count(*) as "CNT" from MDMADM.CI_TD_ENTRY;
-
- prompt -------
- prompt MDMADM.CI_TD_ENTRY_CHA;
- select count(*) as "CNT" from MDMADM.CI_TD_ENTRY_CHA;
-
- prompt -------
- prompt MDMADM.CI_TD_ENTRY_K;
- select count(*) as "CNT" from MDMADM.CI_TD_ENTRY_K;
-
- prompt -------
- prompt MDMADM.CI_TD_EX_LIST;
- select count(*) as "CNT" from MDMADM.CI_TD_EX_LIST;
-
- prompt -------
- prompt MDMADM.CI_TD_LOG;
- select count(*) as "CNT" from MDMADM.CI_TD_LOG;
-
- prompt -------
- prompt MDMADM.CI_TD_MSG_PARM;
- select count(*) as "CNT" from MDMADM.CI_TD_MSG_PARM;
-
- prompt -------
- prompt MDMADM.CI_TD_SRTKEY;
- select count(*) as "CNT" from MDMADM.CI_TD_SRTKEY;
-
- prompt -------
- prompt MDMADM.CI_TD_SRTKEY_TY;
- select count(*) as "CNT" from MDMADM.CI_TD_SRTKEY_TY;
-
- prompt -------
- prompt MDMADM.CI_TD_SRTKEY_TY_L;
- select count(*) as "CNT" from MDMADM.CI_TD_SRTKEY_TY_L;
-
- prompt -------
- prompt MDMADM.CI_TD_TYPE;
- select count(*) as "CNT" from MDMADM.CI_TD_TYPE;
-
- prompt -------
- prompt MDMADM.CI_TD_TYPE_ALG;
- select count(*) as "CNT" from MDMADM.CI_TD_TYPE_ALG;
-
- prompt -------
- prompt MDMADM.CI_TD_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.CI_TD_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.CI_TD_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_TD_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_TD_VAL_ROLE;
- select count(*) as "CNT" from MDMADM.CI_TD_VAL_ROLE;
-
- prompt -------
- prompt MDMADM.CI_TIME_ZONE;
- select count(*) as "CNT" from MDMADM.CI_TIME_ZONE;
-
- prompt -------
- prompt MDMADM.CI_TIME_ZONE_L;
- select count(*) as "CNT" from MDMADM.CI_TIME_ZONE_L;
-
- prompt -------
- prompt MDMADM.CI_UI_ZONE;
- select count(*) as "CNT" from MDMADM.CI_UI_ZONE;
-
- prompt -------
- prompt MDMADM.CI_USR_GRP_SC;
- select count(*) as "CNT" from MDMADM.CI_USR_GRP_SC;
-
- prompt -------
- prompt MDMADM.CI_USR_NAV_LINK;
- select count(*) as "CNT" from MDMADM.CI_USR_NAV_LINK;
-
- prompt -------
- prompt MDMADM.CI_USR_PORTAL;
- select count(*) as "CNT" from MDMADM.CI_USR_PORTAL;
-
- prompt -------
- prompt MDMADM.CI_USR_SCR;
- select count(*) as "CNT" from MDMADM.CI_USR_SCR;
-
- prompt -------
- prompt MDMADM.CI_USR_ZONE;
- select count(*) as "CNT" from MDMADM.CI_USR_ZONE;
-
- prompt -------
- prompt MDMADM.CI_UT_INSTL;
- select count(*) as "CNT" from MDMADM.CI_UT_INSTL;
-
- prompt -------
- prompt MDMADM.CI_UT_INSTL_DTL;
- select count(*) as "CNT" from MDMADM.CI_UT_INSTL_DTL;
-
- prompt -------
- prompt MDMADM.CI_VAL_ERR;
- select count(*) as "CNT" from MDMADM.CI_VAL_ERR;
-
- prompt -------
- prompt MDMADM.CI_VAL_FK_ERR;
- select count(*) as "CNT" from MDMADM.CI_VAL_FK_ERR;
-
- prompt -------
- prompt MDMADM.CI_WFM;
- select count(*) as "CNT" from MDMADM.CI_WFM;
-
- prompt -------
- prompt MDMADM.CI_WFM_L;
- select count(*) as "CNT" from MDMADM.CI_WFM_L;
-
- prompt -------
- prompt MDMADM.CI_WFM_MSG;
- select count(*) as "CNT" from MDMADM.CI_WFM_MSG;
-
- prompt -------
- prompt MDMADM.CI_WFM_OPT;
- select count(*) as "CNT" from MDMADM.CI_WFM_OPT;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_CHAR;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_CHAR;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_CTXT;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_CTXT;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_DEP;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_DEP;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_EXC;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_EXC;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_EXP;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_EXP;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_TYPE;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_TYPE;
-
- prompt -------
- prompt MDMADM.CI_WF_EVT_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_WF_EVT_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_WF_PP;
- select count(*) as "CNT" from MDMADM.CI_WF_PP;
-
- prompt -------
- prompt MDMADM.CI_WF_PP_L;
- select count(*) as "CNT" from MDMADM.CI_WF_PP_L;
-
- prompt -------
- prompt MDMADM.CI_WF_PP_NT;
- select count(*) as "CNT" from MDMADM.CI_WF_PP_NT;
-
- prompt -------
- prompt MDMADM.CI_WF_PP_NT_CRT;
- select count(*) as "CNT" from MDMADM.CI_WF_PP_NT_CRT;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_CHAR;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_CHAR;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_CTXT;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_CTXT;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_K;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_K;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_MSGP;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_MSGP;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_SCHED;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_SCHED;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_SCHED_K;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_SCHED_K;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_TMPL;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_TMPL;
-
- prompt -------
- prompt MDMADM.CI_WF_PROC_TMPL_L;
- select count(*) as "CNT" from MDMADM.CI_WF_PROC_TMPL_L;
-
- prompt -------
- prompt MDMADM.CI_WF_RESP;
- select count(*) as "CNT" from MDMADM.CI_WF_RESP;
-
- prompt -------
- prompt MDMADM.CI_WF_RESP_DEP;
- select count(*) as "CNT" from MDMADM.CI_WF_RESP_DEP;
-
- prompt -------
- prompt MDMADM.CI_XAI_ADAPTER;
- select count(*) as "CNT" from MDMADM.CI_XAI_ADAPTER;
-
- prompt -------
- prompt MDMADM.CI_XAI_ADAPTER_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_ADAPTER_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_CLASS;
- select count(*) as "CNT" from MDMADM.CI_XAI_CLASS;
-
- prompt -------
- prompt MDMADM.CI_XAI_CLASS_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_CLASS_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_DWN;
- select count(*) as "CNT" from MDMADM.CI_XAI_DWN;
-
- prompt -------
- prompt MDMADM.CI_XAI_DWN_EXC;
- select count(*) as "CNT" from MDMADM.CI_XAI_DWN_EXC;
-
- prompt -------
- prompt MDMADM.CI_XAI_DWN_EXP;
- select count(*) as "CNT" from MDMADM.CI_XAI_DWN_EXP;
-
- prompt -------
- prompt MDMADM.CI_XAI_ENV_HNDL;
- select count(*) as "CNT" from MDMADM.CI_XAI_ENV_HNDL;
-
- prompt -------
- prompt MDMADM.CI_XAI_ENV_HNDL_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_ENV_HNDL_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_EXECUTER;
- select count(*) as "CNT" from MDMADM.CI_XAI_EXECUTER;
-
- prompt -------
- prompt MDMADM.CI_XAI_EXECUTER_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_EXECUTER_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_FORMAT;
- select count(*) as "CNT" from MDMADM.CI_XAI_FORMAT;
-
- prompt -------
- prompt MDMADM.CI_XAI_FORMAT_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_FORMAT_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_IN_SVC;
- select count(*) as "CNT" from MDMADM.CI_XAI_IN_SVC;
-
- prompt -------
- prompt MDMADM.CI_XAI_IN_SVC_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_IN_SVC_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_JDBC_CON;
- select count(*) as "CNT" from MDMADM.CI_XAI_JDBC_CON;
-
- prompt -------
- prompt MDMADM.CI_XAI_JDBC_CON_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_JDBC_CON_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_CON;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_CON;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_CON_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_CON_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_Q;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_Q;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_Q_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_Q_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_TPC;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_TPC;
-
- prompt -------
- prompt MDMADM.CI_XAI_JMS_TPC_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_JMS_TPC_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_JNDI_SVR;
- select count(*) as "CNT" from MDMADM.CI_XAI_JNDI_SVR;
-
- prompt -------
- prompt MDMADM.CI_XAI_JNDI_SVR_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_JNDI_SVR_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_OPTION;
- select count(*) as "CNT" from MDMADM.CI_XAI_OPTION;
-
- prompt -------
- prompt MDMADM.CI_XAI_RCVR;
- select count(*) as "CNT" from MDMADM.CI_XAI_RCVR;
-
- prompt -------
- prompt MDMADM.CI_XAI_RCVR_CTX;
- select count(*) as "CNT" from MDMADM.CI_XAI_RCVR_CTX;
-
- prompt -------
- prompt MDMADM.CI_XAI_RCVR_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_RCVR_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_RCVR_RGRP;
- select count(*) as "CNT" from MDMADM.CI_XAI_RCVR_RGRP;
-
- prompt -------
- prompt MDMADM.CI_XAI_RCVR_RSP;
- select count(*) as "CNT" from MDMADM.CI_XAI_RCVR_RSP;
-
- prompt -------
- prompt MDMADM.CI_XAI_RGRP;
- select count(*) as "CNT" from MDMADM.CI_XAI_RGRP;
-
- prompt -------
- prompt MDMADM.CI_XAI_RGRP_ATT;
- select count(*) as "CNT" from MDMADM.CI_XAI_RGRP_ATT;
-
- prompt -------
- prompt MDMADM.CI_XAI_RGRP_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_RGRP_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_ROUTING;
- select count(*) as "CNT" from MDMADM.CI_XAI_ROUTING;
-
- prompt -------
- prompt MDMADM.CI_XAI_RT_TYPE;
- select count(*) as "CNT" from MDMADM.CI_XAI_RT_TYPE;
-
- prompt -------
- prompt MDMADM.CI_XAI_RT_TYPE_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_RT_TYPE_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_RULE;
- select count(*) as "CNT" from MDMADM.CI_XAI_RULE;
-
- prompt -------
- prompt MDMADM.CI_XAI_SENDER;
- select count(*) as "CNT" from MDMADM.CI_XAI_SENDER;
-
- prompt -------
- prompt MDMADM.CI_XAI_SENDER_L;
- select count(*) as "CNT" from MDMADM.CI_XAI_SENDER_L;
-
- prompt -------
- prompt MDMADM.CI_XAI_SNDR_CTX;
- select count(*) as "CNT" from MDMADM.CI_XAI_SNDR_CTX;
-
- prompt -------
- prompt MDMADM.CI_XAI_SVC_PARM;
- select count(*) as "CNT" from MDMADM.CI_XAI_SVC_PARM;
-
- prompt -------
- prompt MDMADM.CI_XML_STGCTL_P;
- select count(*) as "CNT" from MDMADM.CI_XML_STGCTL_P;
-
- prompt -------
- prompt MDMADM.CI_XML_STGUP;
- select count(*) as "CNT" from MDMADM.CI_XML_STGUP;
-
- prompt -------
- prompt MDMADM.CI_XML_STGUPEXP;
- select count(*) as "CNT" from MDMADM.CI_XML_STGUPEXP;
-
- prompt -------
- prompt MDMADM.CI_XML_STGUP_EX;
- select count(*) as "CNT" from MDMADM.CI_XML_STGUP_EX;
-
- prompt -------
- prompt MDMADM.CI_XML_STG_CTL;
- select count(*) as "CNT" from MDMADM.CI_XML_STG_CTL;
-
- prompt -------
- prompt MDMADM.CI_ZONE;
- select count(*) as "CNT" from MDMADM.CI_ZONE;
-
- prompt -------
- prompt MDMADM.CI_ZONE_HDL;
- select count(*) as "CNT" from MDMADM.CI_ZONE_HDL;
-
- prompt -------
- prompt MDMADM.CI_ZONE_HDL_L;
- select count(*) as "CNT" from MDMADM.CI_ZONE_HDL_L;
-
- prompt -------
- prompt MDMADM.CI_ZONE_HDL_PRM;
- select count(*) as "CNT" from MDMADM.CI_ZONE_HDL_PRM;
-
- prompt -------
- prompt MDMADM.CI_ZONE_HDL_PRM_L;
- select count(*) as "CNT" from MDMADM.CI_ZONE_HDL_PRM_L;
-
- prompt -------
- prompt MDMADM.CI_ZONE_L;
- select count(*) as "CNT" from MDMADM.CI_ZONE_L;
-
- prompt -------
- prompt MDMADM.CI_ZONE_PRM;
- select count(*) as "CNT" from MDMADM.CI_ZONE_PRM;
-
- prompt -------
- prompt MDMADM.CMP3$220536;
- select count(*) as "CNT" from MDMADM.CMP3$220536;
-
- prompt -------
- prompt MDMADM.CMP3$95220;
- select count(*) as "CNT" from MDMADM.CMP3$95220;
-
- prompt -------
- prompt MDMADM.CMP3$95317;
- select count(*) as "CNT" from MDMADM.CMP3$95317;
-
- prompt -------
- prompt MDMADM.CMP3$95354;
- select count(*) as "CNT" from MDMADM.CMP3$95354;
-
- prompt -------
- prompt MDMADM.CMP4$220536;
- select count(*) as "CNT" from MDMADM.CMP4$220536;
-
- prompt -------
- prompt MDMADM.CM_ACTIVITY_ID;
- select count(*) as "CNT" from MDMADM.CM_ACTIVITY_ID;
-
- prompt -------
- prompt MDMADM.CM_MSRMT_20825852;
- select count(*) as "CNT" from MDMADM.CM_MSRMT_20825852;
-
- prompt -------
- prompt MDMADM.CM_SYNC_ID;
- select count(*) as "CNT" from MDMADM.CM_SYNC_ID;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_CHAR;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_CHAR;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_K;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_K;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_LOG;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_LOG;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_REL;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_REL;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_REL_OBJ;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_REL_OBJ;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_TYPE;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_TYPE;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_ACTIVITY_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_ACTIVITY_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_CHAR;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_CHAR;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_K;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_K;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_LOG;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_LOG;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_COMM_IN_REL_OBJ;
- select count(*) as "CNT" from MDMADM.D1_COMM_IN_REL_OBJ;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_K;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_K;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_LOG;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_LOG;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_COMM_OUT_REL_OBJ;
- select count(*) as "CNT" from MDMADM.D1_COMM_OUT_REL_OBJ;
-
- prompt -------
- prompt MDMADM.D1_COMM_TYPE;
- select count(*) as "CNT" from MDMADM.D1_COMM_TYPE;
-
- prompt -------
- prompt MDMADM.D1_COMM_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_COMM_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_COMM_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_COMM_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT_K;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT_K;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT_LOG;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT_LOG;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_COMPL_EVT_REL_OBJ;
- select count(*) as "CNT" from MDMADM.D1_COMPL_EVT_REL_OBJ;
-
- prompt -------
- prompt MDMADM.D1_CONS_EXT_TYPE;
- select count(*) as "CNT" from MDMADM.D1_CONS_EXT_TYPE;
-
- prompt -------
- prompt MDMADM.D1_CONS_EXT_TYPE_ALG;
- select count(*) as "CNT" from MDMADM.D1_CONS_EXT_TYPE_ALG;
-
- prompt -------
- prompt MDMADM.D1_CONS_EXT_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_CONS_EXT_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_CONS_EXT_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_CONS_EXT_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_CONS_EXT_TYPE_SP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_CONS_EXT_TYPE_SP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_CONTACT;
- select count(*) as "CNT" from MDMADM.D1_CONTACT;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_EMAIL;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_EMAIL;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_K;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_K;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_NAME;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_NAME;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_PHONE;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_PHONE;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_TYPE;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_TYPE;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_CONTACT_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_CONTACT_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_DVC;
- select count(*) as "CNT" from MDMADM.D1_DVC;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_K;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_K;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_LOG;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_LOG;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_DVC_CFG_TYPE_MC_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DVC_CFG_TYPE_MC_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DVC_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_K;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_K;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_LOG;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_LOG;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_REL_OBJ;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_REL_OBJ;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_EVT_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_DVC_EVT_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_DVC_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_DVC_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_DVC_K;
- select count(*) as "CNT" from MDMADM.D1_DVC_K;
-
- prompt -------
- prompt MDMADM.D1_DVC_LOG;
- select count(*) as "CNT" from MDMADM.D1_DVC_LOG;
-
- prompt -------
- prompt MDMADM.D1_DVC_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_DVC_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_CFG_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_CFG_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_SPR;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_SPR;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_SQ;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_SQ;
-
- prompt -------
- prompt MDMADM.D1_DVC_TYPE_SQ_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DVC_TYPE_SQ_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_EVENT;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_EVENT;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_EVENT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_EVENT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_EVENT_K;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_EVENT_K;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_EVENT_LOG;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_EVENT_LOG;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_EVENT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_EVENT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_K;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_K;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_L;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_L;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_LOG;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_LOG;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_TYPE;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_TYPE;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_DYN_OPT_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_DYN_OPT_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_EXCP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_EXCP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_EXCP_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_EXCP_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_EXCP_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_EXCP_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_FACILITY;
- select count(*) as "CNT" from MDMADM.D1_FACILITY;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_CHAR;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_CHAR;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_K;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_K;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_L;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_L;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_LOG;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_LOG;
-
- prompt -------
- prompt MDMADM.D1_FACILITY_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_FACILITY_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_FACTOR;
- select count(*) as "CNT" from MDMADM.D1_FACTOR;
-
- prompt -------
- prompt MDMADM.D1_FACTOR_CHAR;
- select count(*) as "CNT" from MDMADM.D1_FACTOR_CHAR;
-
- prompt -------
- prompt MDMADM.D1_FACTOR_CHAR_VALUE;
- select count(*) as "CNT" from MDMADM.D1_FACTOR_CHAR_VALUE;
-
- prompt -------
- prompt MDMADM.D1_FACTOR_L;
- select count(*) as "CNT" from MDMADM.D1_FACTOR_L;
-
- prompt -------
- prompt MDMADM.D1_FACTOR_VALUE;
- select count(*) as "CNT" from MDMADM.D1_FACTOR_VALUE;
-
- prompt -------
- prompt MDMADM.D1_FACTOR_VALUE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_FACTOR_VALUE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_GTT1;
- select count(*) as "CNT" from MDMADM.D1_GTT1;
-
- prompt -------
- prompt MDMADM.D1_GTT2;
- select count(*) as "CNT" from MDMADM.D1_GTT2;
-
- prompt -------
- prompt MDMADM.D1_GTT3;
- select count(*) as "CNT" from MDMADM.D1_GTT3;
-
- prompt -------
- prompt MDMADM.D1_GTT4;
- select count(*) as "CNT" from MDMADM.D1_GTT4;
-
- prompt -------
- prompt MDMADM.D1_IMD_CTRL;
- select count(*) as "CNT" from MDMADM.D1_IMD_CTRL;
-
- prompt -------
- prompt MDMADM.D1_IMD_CTRL_18052016;
- select count(*) as "CNT" from MDMADM.D1_IMD_CTRL_18052016;
-
- prompt -------
- prompt MDMADM.D1_INIT_MSRMT_DATA;
- select count(*) as "CNT" from MDMADM.D1_INIT_MSRMT_DATA;
-
- prompt -------
- prompt MDMADM.D1_INIT_MSRMT_DATA_CHAR;
- select count(*) as "CNT" from MDMADM.D1_INIT_MSRMT_DATA_CHAR;
-
- prompt -------
- prompt MDMADM.D1_INIT_MSRMT_DATA_K;
- select count(*) as "CNT" from MDMADM.D1_INIT_MSRMT_DATA_K;
-
- prompt -------
- prompt MDMADM.D1_INIT_MSRMT_DATA_LOG;
- select count(*) as "CNT" from MDMADM.D1_INIT_MSRMT_DATA_LOG;
-
- prompt -------
- prompt MDMADM.D1_INIT_MSRMT_DATA_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_INIT_MSRMT_DATA_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_INSTALL_EVT;
- select count(*) as "CNT" from MDMADM.D1_INSTALL_EVT;
-
- prompt -------
- prompt MDMADM.D1_INSTALL_EVT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_INSTALL_EVT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_INSTALL_EVT_K;
- select count(*) as "CNT" from MDMADM.D1_INSTALL_EVT_K;
-
- prompt -------
- prompt MDMADM.D1_INSTALL_EVT_LOG;
- select count(*) as "CNT" from MDMADM.D1_INSTALL_EVT_LOG;
-
- prompt -------
- prompt MDMADM.D1_INSTALL_EVT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_INSTALL_EVT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_MANUFACTURER;
- select count(*) as "CNT" from MDMADM.D1_MANUFACTURER;
-
- prompt -------
- prompt MDMADM.D1_MANUFACTURER_L;
- select count(*) as "CNT" from MDMADM.D1_MANUFACTURER_L;
-
- prompt -------
- prompt MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER_L;
- select count(*) as "CNT" from MDMADM.D1_MC_TYPE_VALUE_IDENTIFIER_L;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_K;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_K;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_LOG;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_LOG;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_REL;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_REL;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_TYPE_VEE_GRP;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_TYPE_VEE_GRP;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_TYP_FBK_VEE_GRP;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_TYP_FBK_VEE_GRP;
-
- prompt -------
- prompt MDMADM.D1_MEASR_COMP_VEE_GROUP;
- select count(*) as "CNT" from MDMADM.D1_MEASR_COMP_VEE_GROUP;
-
- prompt -------
- prompt MDMADM.D1_MKT;
- select count(*) as "CNT" from MDMADM.D1_MKT;
-
- prompt -------
- prompt MDMADM.D1_MKT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MKT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MKT_FALLBACK_SPR;
- select count(*) as "CNT" from MDMADM.D1_MKT_FALLBACK_SPR;
-
- prompt -------
- prompt MDMADM.D1_MKT_L;
- select count(*) as "CNT" from MDMADM.D1_MKT_L;
-
- prompt -------
- prompt MDMADM.D1_MKT_REL_TYPE;
- select count(*) as "CNT" from MDMADM.D1_MKT_REL_TYPE;
-
- prompt -------
- prompt MDMADM.D1_MKT_VALID_SPR;
- select count(*) as "CNT" from MDMADM.D1_MKT_VALID_SPR;
-
- prompt -------
- prompt MDMADM.D1_MODEL;
- select count(*) as "CNT" from MDMADM.D1_MODEL;
-
- prompt -------
- prompt MDMADM.D1_MODEL_L;
- select count(*) as "CNT" from MDMADM.D1_MODEL_L;
-
- prompt -------
- prompt MDMADM.D1_MSRMT;
- select count(*) as "CNT" from MDMADM.D1_MSRMT;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_L;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_L;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_MCR;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_MCR;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_RTE;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_RTE;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_RTE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_RTE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_RTE_L;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_RTE_L;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_SCHED;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_SCHED;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_SCHED_CHAR;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_SCHED_CHAR;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_CYC_SCHED_RTE;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_CYC_SCHED_RTE;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_LOG;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_LOG;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_MSRMT_TMP;
- select count(*) as "CNT" from MDMADM.D1_MSRMT_TMP;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC_CHAR;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC_CHAR;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC_K;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC_K;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC_LOG;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC_LOG;
-
- prompt -------
- prompt MDMADM.D1_NW_LOC_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_NW_LOC_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_NW_NODE;
- select count(*) as "CNT" from MDMADM.D1_NW_NODE;
-
- prompt -------
- prompt MDMADM.D1_OBIEE_EVENT_POLLING;
- select count(*) as "CNT" from MDMADM.D1_OBIEE_EVENT_POLLING;
-
- prompt -------
- prompt MDMADM.D1_ON_OFF_HIST;
- select count(*) as "CNT" from MDMADM.D1_ON_OFF_HIST;
-
- prompt -------
- prompt MDMADM.D1_PROC_MTHD;
- select count(*) as "CNT" from MDMADM.D1_PROC_MTHD;
-
- prompt -------
- prompt MDMADM.D1_PROC_MTHD_CHAR;
- select count(*) as "CNT" from MDMADM.D1_PROC_MTHD_CHAR;
-
- prompt -------
- prompt MDMADM.D1_PROC_MTHD_L;
- select count(*) as "CNT" from MDMADM.D1_PROC_MTHD_L;
-
- prompt -------
- prompt MDMADM.D1_SNAPSHOT_DL_CTRL;
- select count(*) as "CNT" from MDMADM.D1_SNAPSHOT_DL_CTRL;
-
- prompt -------
- prompt MDMADM.D1_SP;
- select count(*) as "CNT" from MDMADM.D1_SP;
-
- prompt -------
- prompt MDMADM.D1_SPR;
- select count(*) as "CNT" from MDMADM.D1_SPR;
-
- prompt -------
- prompt MDMADM.D1_SPR_CHAR;
- select count(*) as "CNT" from MDMADM.D1_SPR_CHAR;
-
- prompt -------
- prompt MDMADM.D1_SPR_L;
- select count(*) as "CNT" from MDMADM.D1_SPR_L;
-
- prompt -------
- prompt MDMADM.D1_SP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_SP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_SP_CONTACT;
- select count(*) as "CNT" from MDMADM.D1_SP_CONTACT;
-
- prompt -------
- prompt MDMADM.D1_SP_FACILITY;
- select count(*) as "CNT" from MDMADM.D1_SP_FACILITY;
-
- prompt -------
- prompt MDMADM.D1_SP_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_SP_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_SP_K;
- select count(*) as "CNT" from MDMADM.D1_SP_K;
-
- prompt -------
- prompt MDMADM.D1_SP_LOG;
- select count(*) as "CNT" from MDMADM.D1_SP_LOG;
-
- prompt -------
- prompt MDMADM.D1_SP_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_SP_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_SP_MKT_PARTICIPANT;
- select count(*) as "CNT" from MDMADM.D1_SP_MKT_PARTICIPANT;
-
- prompt -------
- prompt MDMADM.D1_SP_MSRMT_CYC_SCHED_RTE;
- select count(*) as "CNT" from MDMADM.D1_SP_MSRMT_CYC_SCHED_RTE;
-
- prompt -------
- prompt MDMADM.D1_SP_REL;
- select count(*) as "CNT" from MDMADM.D1_SP_REL;
-
- prompt -------
- prompt MDMADM.D1_SP_SNAP_DL;
- select count(*) as "CNT" from MDMADM.D1_SP_SNAP_DL;
-
- prompt -------
- prompt MDMADM.D1_SP_SNAP_DL_K;
- select count(*) as "CNT" from MDMADM.D1_SP_SNAP_DL_K;
-
- prompt -------
- prompt MDMADM.D1_SP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_SP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_SP_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_SP_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_SP_TYPE_DEVICE_TYPE;
- select count(*) as "CNT" from MDMADM.D1_SP_TYPE_DEVICE_TYPE;
-
- prompt -------
- prompt MDMADM.D1_SP_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_SP_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_SP_UNR_USG_SNAP_DL;
- select count(*) as "CNT" from MDMADM.D1_SP_UNR_USG_SNAP_DL;
-
- prompt -------
- prompt MDMADM.D1_SP_UNR_USG_SNAP_DL_K;
- select count(*) as "CNT" from MDMADM.D1_SP_UNR_USG_SNAP_DL_K;
-
- prompt -------
- prompt MDMADM.D1_SP_USG_SNAP_DL;
- select count(*) as "CNT" from MDMADM.D1_SP_USG_SNAP_DL;
-
- prompt -------
- prompt MDMADM.D1_SP_USG_SNAP_DL_K;
- select count(*) as "CNT" from MDMADM.D1_SP_USG_SNAP_DL_K;
-
- prompt -------
- prompt MDMADM.D1_SP_VEE_EXCP_SNAP_DL;
- select count(*) as "CNT" from MDMADM.D1_SP_VEE_EXCP_SNAP_DL;
-
- prompt -------
- prompt MDMADM.D1_SP_VEE_EXCP_SNAP_DL_K;
- select count(*) as "CNT" from MDMADM.D1_SP_VEE_EXCP_SNAP_DL_K;
-
- prompt -------
- prompt MDMADM.D1_SQI;
- select count(*) as "CNT" from MDMADM.D1_SQI;
-
- prompt -------
- prompt MDMADM.D1_SQI_L;
- select count(*) as "CNT" from MDMADM.D1_SQI_L;
-
- prompt -------
- prompt MDMADM.D1_SVC_TYPE;
- select count(*) as "CNT" from MDMADM.D1_SVC_TYPE;
-
- prompt -------
- prompt MDMADM.D1_SVC_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_SVC_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_TOU;
- select count(*) as "CNT" from MDMADM.D1_TOU;
-
- prompt -------
- prompt MDMADM.D1_TOU_GRP;
- select count(*) as "CNT" from MDMADM.D1_TOU_GRP;
-
- prompt -------
- prompt MDMADM.D1_TOU_GRP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_TOU_GRP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_TOU_GRP_L;
- select count(*) as "CNT" from MDMADM.D1_TOU_GRP_L;
-
- prompt -------
- prompt MDMADM.D1_TOU_GRP_TOU;
- select count(*) as "CNT" from MDMADM.D1_TOU_GRP_TOU;
-
- prompt -------
- prompt MDMADM.D1_TOU_L;
- select count(*) as "CNT" from MDMADM.D1_TOU_L;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_DATA;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_DATA;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_DATA_CHAR;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_DATA_CHAR;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_DATA_TMP;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_DATA_TMP;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_DATA_TMP2;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_DATA_TMP2;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_DYN_OPT;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_DYN_OPT;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_K;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_K;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_L;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_L;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_LOG;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_LOG;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TMPLT;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TMPLT;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TMPLT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TMPLT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TMPLT_L;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TMPLT_L;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_TOU_MAP_TYPE_TMPLT;
- select count(*) as "CNT" from MDMADM.D1_TOU_MAP_TYPE_TMPLT;
-
- prompt -------
- prompt MDMADM.D1_UOM;
- select count(*) as "CNT" from MDMADM.D1_UOM;
-
- prompt -------
- prompt MDMADM.D1_UOM_L;
- select count(*) as "CNT" from MDMADM.D1_UOM_L;
-
- prompt -------
- prompt MDMADM.D1_US;
- select count(*) as "CNT" from MDMADM.D1_US;
-
- prompt -------
- prompt MDMADM.D1_USAGE;
- select count(*) as "CNT" from MDMADM.D1_USAGE;
-
- prompt -------
- prompt MDMADM.D1_USAGE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_USAGE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_USAGE_K;
- select count(*) as "CNT" from MDMADM.D1_USAGE_K;
-
- prompt -------
- prompt MDMADM.D1_USAGE_LOG;
- select count(*) as "CNT" from MDMADM.D1_USAGE_LOG;
-
- prompt -------
- prompt MDMADM.D1_USAGE_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_USAGE_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_USAGE_PERIOD;
- select count(*) as "CNT" from MDMADM.D1_USAGE_PERIOD;
-
- prompt -------
- prompt MDMADM.D1_USAGE_PERIOD_ITEM_DET;
- select count(*) as "CNT" from MDMADM.D1_USAGE_PERIOD_ITEM_DET;
-
- prompt -------
- prompt MDMADM.D1_USAGE_PERIOD_SQ;
- select count(*) as "CNT" from MDMADM.D1_USAGE_PERIOD_SQ;
-
- prompt -------
- prompt MDMADM.D1_USAGE_PERIOD_SQ_120315;
- select count(*) as "CNT" from MDMADM.D1_USAGE_PERIOD_SQ_120315;
-
- prompt -------
- prompt MDMADM.D1_USAGE_REL;
- select count(*) as "CNT" from MDMADM.D1_USAGE_REL;
-
- prompt -------
- prompt MDMADM.D1_USAGE_SCALAR_DTL;
- select count(*) as "CNT" from MDMADM.D1_USAGE_SCALAR_DTL;
-
- prompt -------
- prompt MDMADM.D1_USG_GRP;
- select count(*) as "CNT" from MDMADM.D1_USG_GRP;
-
- prompt -------
- prompt MDMADM.D1_USG_GRP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_USG_GRP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_USG_GRP_L;
- select count(*) as "CNT" from MDMADM.D1_USG_GRP_L;
-
- prompt -------
- prompt MDMADM.D1_USG_GRP_VAL_DC_TYPE;
- select count(*) as "CNT" from MDMADM.D1_USG_GRP_VAL_DC_TYPE;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE_ELIG_CRIT;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE_ELIG_CRIT;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE_ELIG_CRIT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE_ELIG_CRIT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE_ELIG_CRIT_L;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE_ELIG_CRIT_L;
-
- prompt -------
- prompt MDMADM.D1_USG_RULE_L;
- select count(*) as "CNT" from MDMADM.D1_USG_RULE_L;
-
- prompt -------
- prompt MDMADM.D1_US_CHAR;
- select count(*) as "CNT" from MDMADM.D1_US_CHAR;
-
- prompt -------
- prompt MDMADM.D1_US_CONTACT;
- select count(*) as "CNT" from MDMADM.D1_US_CONTACT;
-
- prompt -------
- prompt MDMADM.D1_US_DYN_OPT;
- select count(*) as "CNT" from MDMADM.D1_US_DYN_OPT;
-
- prompt -------
- prompt MDMADM.D1_US_DYN_OPT_OVRRD;
- select count(*) as "CNT" from MDMADM.D1_US_DYN_OPT_OVRRD;
-
- prompt -------
- prompt MDMADM.D1_US_FACTOR_OVRD;
- select count(*) as "CNT" from MDMADM.D1_US_FACTOR_OVRD;
-
- prompt -------
- prompt MDMADM.D1_US_IDENTIFIER;
- select count(*) as "CNT" from MDMADM.D1_US_IDENTIFIER;
-
- prompt -------
- prompt MDMADM.D1_US_K;
- select count(*) as "CNT" from MDMADM.D1_US_K;
-
- prompt -------
- prompt MDMADM.D1_US_LOG;
- select count(*) as "CNT" from MDMADM.D1_US_LOG;
-
- prompt -------
- prompt MDMADM.D1_US_LOG_PARM;
- select count(*) as "CNT" from MDMADM.D1_US_LOG_PARM;
-
- prompt -------
- prompt MDMADM.D1_US_MC;
- select count(*) as "CNT" from MDMADM.D1_US_MC;
-
- prompt -------
- prompt MDMADM.D1_US_REL;
- select count(*) as "CNT" from MDMADM.D1_US_REL;
-
- prompt -------
- prompt MDMADM.D1_US_SP;
- select count(*) as "CNT" from MDMADM.D1_US_SP;
-
- prompt -------
- prompt MDMADM.D1_US_SP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_US_SP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_FB_USG_GRP;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_FB_USG_GRP;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_L;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_L;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_VAL_DYN_OPT_TYPE;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_VAL_DYN_OPT_TYPE;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_VAL_SPR;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_VAL_SPR;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_VAL_SP_TYPE;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_VAL_SP_TYPE;
-
- prompt -------
- prompt MDMADM.D1_US_TYPE_VAL_USG_GRP;
- select count(*) as "CNT" from MDMADM.D1_US_TYPE_VAL_USG_GRP;
-
- prompt -------
- prompt MDMADM.D1_US_USG_GRP;
- select count(*) as "CNT" from MDMADM.D1_US_USG_GRP;
-
- prompt -------
- prompt MDMADM.D1_US_USG_GRP_DL;
- select count(*) as "CNT" from MDMADM.D1_US_USG_GRP_DL;
-
- prompt -------
- prompt MDMADM.D1_VEE_ELIG_CRIT;
- select count(*) as "CNT" from MDMADM.D1_VEE_ELIG_CRIT;
-
- prompt -------
- prompt MDMADM.D1_VEE_ELIG_CRIT_CHAR;
- select count(*) as "CNT" from MDMADM.D1_VEE_ELIG_CRIT_CHAR;
-
- prompt -------
- prompt MDMADM.D1_VEE_ELIG_CRIT_L;
- select count(*) as "CNT" from MDMADM.D1_VEE_ELIG_CRIT_L;
-
- prompt -------
- prompt MDMADM.D1_VEE_EXCP;
- select count(*) as "CNT" from MDMADM.D1_VEE_EXCP;
-
- prompt -------
- prompt MDMADM.D1_VEE_EXCP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_VEE_EXCP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_VEE_EXCP_K;
- select count(*) as "CNT" from MDMADM.D1_VEE_EXCP_K;
-
- prompt -------
- prompt MDMADM.D1_VEE_EXCP_PARM;
- select count(*) as "CNT" from MDMADM.D1_VEE_EXCP_PARM;
-
- prompt -------
- prompt MDMADM.D1_VEE_GRP;
- select count(*) as "CNT" from MDMADM.D1_VEE_GRP;
-
- prompt -------
- prompt MDMADM.D1_VEE_GRP_CHAR;
- select count(*) as "CNT" from MDMADM.D1_VEE_GRP_CHAR;
-
- prompt -------
- prompt MDMADM.D1_VEE_GRP_L;
- select count(*) as "CNT" from MDMADM.D1_VEE_GRP_L;
-
- prompt -------
- prompt MDMADM.D1_VEE_RULE;
- select count(*) as "CNT" from MDMADM.D1_VEE_RULE;
-
- prompt -------
- prompt MDMADM.D1_VEE_RULE_CHAR;
- select count(*) as "CNT" from MDMADM.D1_VEE_RULE_CHAR;
-
- prompt -------
- prompt MDMADM.D1_VEE_RULE_L;
- select count(*) as "CNT" from MDMADM.D1_VEE_RULE_L;
-
- prompt -------
- prompt MDMADM.F1_ATTACHMENT;
- select count(*) as "CNT" from MDMADM.F1_ATTACHMENT;
-
- prompt -------
- prompt MDMADM.F1_ATTACHMENT_CHAR;
- select count(*) as "CNT" from MDMADM.F1_ATTACHMENT_CHAR;
-
- prompt -------
- prompt MDMADM.F1_BKT_CONFIG;
- select count(*) as "CNT" from MDMADM.F1_BKT_CONFIG;
-
- prompt -------
- prompt MDMADM.F1_BKT_CONFIG_L;
- select count(*) as "CNT" from MDMADM.F1_BKT_CONFIG_L;
-
- prompt -------
- prompt MDMADM.F1_BKT_CONFIG_REL_OBJ;
- select count(*) as "CNT" from MDMADM.F1_BKT_CONFIG_REL_OBJ;
-
- prompt -------
- prompt MDMADM.F1_BKT_CONFIG_VAL;
- select count(*) as "CNT" from MDMADM.F1_BKT_CONFIG_VAL;
-
- prompt -------
- prompt MDMADM.F1_BKT_CONFIG_VAL_L;
- select count(*) as "CNT" from MDMADM.F1_BKT_CONFIG_VAL_L;
-
- prompt -------
- prompt MDMADM.F1_BNDL;
- select count(*) as "CNT" from MDMADM.F1_BNDL;
-
- prompt -------
- prompt MDMADM.F1_BNDL_CHAR;
- select count(*) as "CNT" from MDMADM.F1_BNDL_CHAR;
-
- prompt -------
- prompt MDMADM.F1_BNDL_ENTITY;
- select count(*) as "CNT" from MDMADM.F1_BNDL_ENTITY;
-
- prompt -------
- prompt MDMADM.F1_BNDL_K;
- select count(*) as "CNT" from MDMADM.F1_BNDL_K;
-
- prompt -------
- prompt MDMADM.F1_BNDL_LOG;
- select count(*) as "CNT" from MDMADM.F1_BNDL_LOG;
-
- prompt -------
- prompt MDMADM.F1_BNDL_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_BNDL_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_BUS_EVT_LOG;
- select count(*) as "CNT" from MDMADM.F1_BUS_EVT_LOG;
-
- prompt -------
- prompt MDMADM.F1_BUS_EVT_LOG_CHAR;
- select count(*) as "CNT" from MDMADM.F1_BUS_EVT_LOG_CHAR;
-
- prompt -------
- prompt MDMADM.F1_BUS_EVT_LOG_K;
- select count(*) as "CNT" from MDMADM.F1_BUS_EVT_LOG_K;
-
- prompt -------
- prompt MDMADM.F1_BUS_EVT_LOG_MSG_PARM;
- select count(*) as "CNT" from MDMADM.F1_BUS_EVT_LOG_MSG_PARM;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_ALG;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_ALG;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_L;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_L;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_OPT;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_OPT;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_ALG;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_ALG;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_L;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_L;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_OPT;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_OPT;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_RSN;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_RSN;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_RSN_CHAR;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_RSN_CHAR;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_STATUS_RSN_L;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_STATUS_RSN_L;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_TR_RULE;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_TR_RULE;
-
- prompt -------
- prompt MDMADM.F1_BUS_OBJ_TR_RULE_L;
- select count(*) as "CNT" from MDMADM.F1_BUS_OBJ_TR_RULE_L;
-
- prompt -------
- prompt MDMADM.F1_BUS_SVC;
- select count(*) as "CNT" from MDMADM.F1_BUS_SVC;
-
- prompt -------
- prompt MDMADM.F1_BUS_SVC_L;
- select count(*) as "CNT" from MDMADM.F1_BUS_SVC_L;
-
- prompt -------
- prompt MDMADM.F1_DATA_AREA;
- select count(*) as "CNT" from MDMADM.F1_DATA_AREA;
-
- prompt -------
- prompt MDMADM.F1_DATA_AREA_L;
- select count(*) as "CNT" from MDMADM.F1_DATA_AREA_L;
-
- prompt -------
- prompt MDMADM.F1_DB_OBJECTS_REPO;
- select count(*) as "CNT" from MDMADM.F1_DB_OBJECTS_REPO;
-
- prompt -------
- prompt MDMADM.F1_EXTSYS_OUTMSG_PROF;
- select count(*) as "CNT" from MDMADM.F1_EXTSYS_OUTMSG_PROF;
-
- prompt -------
- prompt MDMADM.F1_EXT_LOOKUP_VAL;
- select count(*) as "CNT" from MDMADM.F1_EXT_LOOKUP_VAL;
-
- prompt -------
- prompt MDMADM.F1_EXT_LOOKUP_VAL_L;
- select count(*) as "CNT" from MDMADM.F1_EXT_LOOKUP_VAL_L;
-
- prompt -------
- prompt MDMADM.F1_FACT;
- select count(*) as "CNT" from MDMADM.F1_FACT;
-
- prompt -------
- prompt MDMADM.F1_FACT_CHAR;
- select count(*) as "CNT" from MDMADM.F1_FACT_CHAR;
-
- prompt -------
- prompt MDMADM.F1_FACT_K;
- select count(*) as "CNT" from MDMADM.F1_FACT_K;
-
- prompt -------
- prompt MDMADM.F1_FACT_LOG;
- select count(*) as "CNT" from MDMADM.F1_FACT_LOG;
-
- prompt -------
- prompt MDMADM.F1_FACT_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_FACT_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_GENERIC_GTT;
- select count(*) as "CNT" from MDMADM.F1_GENERIC_GTT;
-
- prompt -------
- prompt MDMADM.F1_GEN_PROC;
- select count(*) as "CNT" from MDMADM.F1_GEN_PROC;
-
- prompt -------
- prompt MDMADM.F1_GEN_PROC_K;
- select count(*) as "CNT" from MDMADM.F1_GEN_PROC_K;
-
- prompt -------
- prompt MDMADM.F1_INSTALLATION;
- select count(*) as "CNT" from MDMADM.F1_INSTALLATION;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_CHAR;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_CHAR;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_L;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_L;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_PARM;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_PARM;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_TYPE;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_TYPE;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_TYPE_L;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_TYPE_L;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_TYPE_PARM;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_TYPE_PARM;
-
- prompt -------
- prompt MDMADM.F1_IWS_ANN_TYPE_PARM_L;
- select count(*) as "CNT" from MDMADM.F1_IWS_ANN_TYPE_PARM_L;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_ANN;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_ANN;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_CHAR;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_CHAR;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_L;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_L;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_LOG;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_LOG;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_OPER;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_OPER;
-
- prompt -------
- prompt MDMADM.F1_IWS_SVC_OPER_L;
- select count(*) as "CNT" from MDMADM.F1_IWS_SVC_OPER_L;
-
- prompt -------
- prompt MDMADM.F1_KEY_HASH;
- select count(*) as "CNT" from MDMADM.F1_KEY_HASH;
-
- prompt -------
- prompt MDMADM.F1_MANAG_CONTENT;
- select count(*) as "CNT" from MDMADM.F1_MANAG_CONTENT;
-
- prompt -------
- prompt MDMADM.F1_MANAG_CONTENT_L;
- select count(*) as "CNT" from MDMADM.F1_MANAG_CONTENT_L;
-
- prompt -------
- prompt MDMADM.F1_MAP;
- select count(*) as "CNT" from MDMADM.F1_MAP;
-
- prompt -------
- prompt MDMADM.F1_MAP_L;
- select count(*) as "CNT" from MDMADM.F1_MAP_L;
-
- prompt -------
- prompt MDMADM.F1_MAP_OVRD;
- select count(*) as "CNT" from MDMADM.F1_MAP_OVRD;
-
- prompt -------
- prompt MDMADM.F1_MD_DB_OBJ;
- select count(*) as "CNT" from MDMADM.F1_MD_DB_OBJ;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST_ALG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST_ALG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST_K;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST_K;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST_LOG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST_LOG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_MIGR_DATA_ST_TBL;
- select count(*) as "CNT" from MDMADM.F1_MIGR_DATA_ST_TBL;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_ALG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_ALG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_CLOB;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_CLOB;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_K;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_K;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_LOG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_LOG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_MIGR_OBJ_SQL;
- select count(*) as "CNT" from MDMADM.F1_MIGR_OBJ_SQL;
-
- prompt -------
- prompt MDMADM.F1_MIGR_PLAN;
- select count(*) as "CNT" from MDMADM.F1_MIGR_PLAN;
-
- prompt -------
- prompt MDMADM.F1_MIGR_PLAN_INSTR;
- select count(*) as "CNT" from MDMADM.F1_MIGR_PLAN_INSTR;
-
- prompt -------
- prompt MDMADM.F1_MIGR_PLAN_INSTR_ALG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_PLAN_INSTR_ALG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_PLAN_INSTR_L;
- select count(*) as "CNT" from MDMADM.F1_MIGR_PLAN_INSTR_L;
-
- prompt -------
- prompt MDMADM.F1_MIGR_PLAN_L;
- select count(*) as "CNT" from MDMADM.F1_MIGR_PLAN_L;
-
- prompt -------
- prompt MDMADM.F1_MIGR_REQ;
- select count(*) as "CNT" from MDMADM.F1_MIGR_REQ;
-
- prompt -------
- prompt MDMADM.F1_MIGR_REQ_INSTR;
- select count(*) as "CNT" from MDMADM.F1_MIGR_REQ_INSTR;
-
- prompt -------
- prompt MDMADM.F1_MIGR_REQ_INSTR_ENTITY;
- select count(*) as "CNT" from MDMADM.F1_MIGR_REQ_INSTR_ENTITY;
-
- prompt -------
- prompt MDMADM.F1_MIGR_REQ_INSTR_L;
- select count(*) as "CNT" from MDMADM.F1_MIGR_REQ_INSTR_L;
-
- prompt -------
- prompt MDMADM.F1_MIGR_REQ_L;
- select count(*) as "CNT" from MDMADM.F1_MIGR_REQ_L;
-
- prompt -------
- prompt MDMADM.F1_MIGR_TRANS;
- select count(*) as "CNT" from MDMADM.F1_MIGR_TRANS;
-
- prompt -------
- prompt MDMADM.F1_MIGR_TRANS_K;
- select count(*) as "CNT" from MDMADM.F1_MIGR_TRANS_K;
-
- prompt -------
- prompt MDMADM.F1_MIGR_TRANS_LOG;
- select count(*) as "CNT" from MDMADM.F1_MIGR_TRANS_LOG;
-
- prompt -------
- prompt MDMADM.F1_MIGR_TRANS_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_MIGR_TRANS_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_MST_CONFIG;
- select count(*) as "CNT" from MDMADM.F1_MST_CONFIG;
-
- prompt -------
- prompt MDMADM.F1_OBJ_REV;
- select count(*) as "CNT" from MDMADM.F1_OBJ_REV;
-
- prompt -------
- prompt MDMADM.F1_OBJ_REV_CHAR;
- select count(*) as "CNT" from MDMADM.F1_OBJ_REV_CHAR;
-
- prompt -------
- prompt MDMADM.F1_OBJ_REV_LOG;
- select count(*) as "CNT" from MDMADM.F1_OBJ_REV_LOG;
-
- prompt -------
- prompt MDMADM.F1_OBJ_REV_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_OBJ_REV_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_OUTMSG;
- select count(*) as "CNT" from MDMADM.F1_OUTMSG;
-
- prompt -------
- prompt MDMADM.F1_OUTMSG_ERRPARM;
- select count(*) as "CNT" from MDMADM.F1_OUTMSG_ERRPARM;
-
- prompt -------
- prompt MDMADM.F1_OUTMSG_K;
- select count(*) as "CNT" from MDMADM.F1_OUTMSG_K;
-
- prompt -------
- prompt MDMADM.F1_OUTMSG_TYPE;
- select count(*) as "CNT" from MDMADM.F1_OUTMSG_TYPE;
-
- prompt -------
- prompt MDMADM.F1_OUTMSG_TYPE_L;
- select count(*) as "CNT" from MDMADM.F1_OUTMSG_TYPE_L;
-
- prompt -------
- prompt MDMADM.F1_REQ;
- select count(*) as "CNT" from MDMADM.F1_REQ;
-
- prompt -------
- prompt MDMADM.F1_REQ_CHAR;
- select count(*) as "CNT" from MDMADM.F1_REQ_CHAR;
-
- prompt -------
- prompt MDMADM.F1_REQ_K;
- select count(*) as "CNT" from MDMADM.F1_REQ_K;
-
- prompt -------
- prompt MDMADM.F1_REQ_LOG;
- select count(*) as "CNT" from MDMADM.F1_REQ_LOG;
-
- prompt -------
- prompt MDMADM.F1_REQ_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_REQ_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_REQ_TYPE;
- select count(*) as "CNT" from MDMADM.F1_REQ_TYPE;
-
- prompt -------
- prompt MDMADM.F1_REQ_TYPE_L;
- select count(*) as "CNT" from MDMADM.F1_REQ_TYPE_L;
-
- prompt -------
- prompt MDMADM.F1_REQ_TYPE_LOG;
- select count(*) as "CNT" from MDMADM.F1_REQ_TYPE_LOG;
-
- prompt -------
- prompt MDMADM.F1_REQ_TYPE_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_REQ_TYPE_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_SCHEMA;
- select count(*) as "CNT" from MDMADM.F1_SCHEMA;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_CHAR;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_CHAR;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_K;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_K;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_LOG;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_LOG;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_REL_OBJ;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_REL_OBJ;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_TYPE;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_TYPE;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_TYPE_CHAR;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_TYPE_CHAR;
-
- prompt -------
- prompt MDMADM.F1_SVC_TASK_TYPE_L;
- select count(*) as "CNT" from MDMADM.F1_SVC_TASK_TYPE_L;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_CHAR;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_CHAR;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_EXTRACT;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_EXTRACT;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_BASIC;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_BASIC;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_CHAR;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_CHAR;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_EXCP;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_EXCP;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_EXCP_PARM;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_EXCP_PARM;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_K;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_K;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_LOG;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_LOG;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_IN_REL_OBJ;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_IN_REL_OBJ;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_K;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_K;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_LOG;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_LOG;
-
- prompt -------
- prompt MDMADM.F1_SYNC_REQ_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_SYNC_REQ_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_TSPACE_ENTRY;
- select count(*) as "CNT" from MDMADM.F1_TSPACE_ENTRY;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_CHAR;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_CHAR;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_GTT;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_GTT;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_L;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_L;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_LOG;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_LOG;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_LOG_PARM;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_LOG_PARM;
-
- prompt -------
- prompt MDMADM.F1_WEB_SVC_OPERATIONS;
- select count(*) as "CNT" from MDMADM.F1_WEB_SVC_OPERATIONS;
-
- prompt -------
- prompt MDMADM.MDMADM_STATS_1;
- select count(*) as "CNT" from MDMADM.MDMADM_STATS_1;
-
- prompt -------
- prompt MDMADM.MLOG$_D1_INIT_MSRMT_DATA;
- select count(*) as "CNT" from MDMADM.MLOG$_D1_INIT_MSRMT_DATA;
-
- prompt -------
- prompt MDMADM.MLOG$_D1_INIT_MSRMT_DATA_K;
- select count(*) as "CNT" from MDMADM.MLOG$_D1_INIT_MSRMT_DATA_K;
-
- prompt -------
- prompt MDMADM.MLOG$_D1_INIT_MSRMT_DATA_L;
- select count(*) as "CNT" from MDMADM.MLOG$_D1_INIT_MSRMT_DATA_L;
-
- prompt -------
- prompt MDMADM.MLOG$_D1_MEASR_COMP;
- select count(*) as "CNT" from MDMADM.MLOG$_D1_MEASR_COMP;
-
- prompt -------
- prompt MDMADM.MLOG$_D1_MSRMT_LOG;
- select count(*) as "CNT" from MDMADM.MLOG$_D1_MSRMT_LOG;
-
- prompt -------
- prompt MDMADM.RUPD$_D1_INIT_MSRMT_DATA;
- select count(*) as "CNT" from MDMADM.RUPD$_D1_INIT_MSRMT_DATA;
-
- prompt -------
- prompt MDMADM.RUPD$_D1_INIT_MSRMT_DATA_K;
- select count(*) as "CNT" from MDMADM.RUPD$_D1_INIT_MSRMT_DATA_K;
-
- prompt -------
- prompt MDMADM.RUPD$_D1_INIT_MSRMT_DATA_L;
- select count(*) as "CNT" from MDMADM.RUPD$_D1_INIT_MSRMT_DATA_L;
-
- prompt -------
- prompt MDMADM.RUPD$_D1_MEASR_COMP;
- select count(*) as "CNT" from MDMADM.RUPD$_D1_MEASR_COMP;
-
- prompt -------
- prompt MDMADM.RUPD$_D1_MSRMT_LOG;
- select count(*) as "CNT" from MDMADM.RUPD$_D1_MSRMT_LOG;
-
- prompt -------
- prompt MDMADM.SC_ACCESS_CNTL;
- select count(*) as "CNT" from MDMADM.SC_ACCESS_CNTL;
-
- prompt -------
- prompt MDMADM.SC_APP_SERVICE;
- select count(*) as "CNT" from MDMADM.SC_APP_SERVICE;
-
- prompt -------
- prompt MDMADM.SC_APP_SERVICE_L;
- select count(*) as "CNT" from MDMADM.SC_APP_SERVICE_L;
-
- prompt -------
- prompt MDMADM.SC_USER;
- select count(*) as "CNT" from MDMADM.SC_USER;
-
- prompt -------
- prompt MDMADM.SC_USER_CHAR;
- select count(*) as "CNT" from MDMADM.SC_USER_CHAR;
-
- prompt -------
- prompt MDMADM.SC_USER_GROUP;
- select count(*) as "CNT" from MDMADM.SC_USER_GROUP;
-
- prompt -------
- prompt MDMADM.SC_USER_GROUP_L;
- select count(*) as "CNT" from MDMADM.SC_USER_GROUP_L;
-
- prompt -------
- prompt MDMADM.SC_USR_GRP_PROF;
- select count(*) as "CNT" from MDMADM.SC_USR_GRP_PROF;
-
- prompt -------
- prompt MDMADM.SC_USR_GRP_USR;
- select count(*) as "CNT" from MDMADM.SC_USR_GRP_USR;
-
- prompt -------
- prompt MDMADM.TM_REG_CHAR_FIX;
- select count(*) as "CNT" from MDMADM.TM_REG_CHAR_FIX;
-
- prompt -------
- prompt MDMADM.TM_ROLLOVER;
- select count(*) as "CNT" from MDMADM.TM_ROLLOVER;
-
- prompt -------
- prompt MDMADM.XX_PENDING_STOP_SAS;
- select count(*) as "CNT" from MDMADM.XX_PENDING_STOP_SAS;
-
- 815 rows selected.
- SQL> spool off
|
