| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594 |
- SQL> @cntr.out
- SP2-0042: unknown command "SQL> /" - rest of line ignored.
- SP2-0734: unknown command beginning "'PROMPT---..." - rest of line ignored.
- ------ prompt MDMADM.CI_ACC_GRP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ACC_GRP_DAR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ACC_GRP_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ALG
- CNT
- ----------------
- 997
- ------ prompt MDMADM.CI_ALG_L
- CNT
- ----------------
- 997
- ------ prompt MDMADM.CI_ALG_PARM
- CNT
- ----------------
- 1,586
- ------ prompt MDMADM.CI_ALG_TYPE
- CNT
- ----------------
- 886
- ------ prompt MDMADM.CI_ALG_TYPE_L
- CNT
- ----------------
- 886
- ------ prompt MDMADM.CI_ALG_TYPE_PRM
- CNT
- ----------------
- 1,103
- ------ prompt MDMADM.CI_ALG_TYPE_PRM_L
- CNT
- ----------------
- 1,103
- ------ prompt MDMADM.CI_ALG_VER
- CNT
- ----------------
- 894
- ------ prompt MDMADM.CI_APP_SVC_ACC
- CNT
- ----------------
- 1,887
- ------ prompt MDMADM.CI_APP_SVC_SCTY
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ARC_ROOT_INST
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ARC_ROOT_INST_K
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ARC_ROOT_OBJ
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ARC_ROOT_OBJ_K
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ARC_ROOT_PK
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_AUDIT
- CNT
- ----------------
- 2,430
- ------ prompt MDMADM.CI_AUDIT_K
- CNT
- ----------------
- 2,430
- ------ prompt MDMADM.CI_BATCH_CTRL
- CNT
- ----------------
- 180
- ------ prompt MDMADM.CI_BATCH_CTRL_ALG
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_BATCH_CTRL_L
- CNT
- ----------------
- 180
- ------ prompt MDMADM.CI_BATCH_CTRL_P
- CNT
- ----------------
- 918
- ------ prompt MDMADM.CI_BATCH_CTRL_P_L
- CNT
- ----------------
- 918
- ------ prompt MDMADM.CI_BATCH_INST
- CNT
- ----------------
- 3,839,925
- ------ prompt MDMADM.CI_BATCH_JOB
- CNT
- ----------------
- 1,069
- ------ prompt MDMADM.CI_BATCH_JOB_K
- CNT
- ----------------
- 1,069
- ------ prompt MDMADM.CI_BATCH_JOB_PRM
- CNT
- ----------------
- 6,353
- ------ prompt MDMADM.CI_BATCH_RUN
- CNT
- ----------------
- 334,140
- ------ prompt MDMADM.CI_BATCH_THD
- CNT
- ----------------
- 3,832,490
- ------ prompt MDMADM.CI_CAL_HOL
- CNT
- ----------------
- 62
- ------ prompt MDMADM.CI_CAL_HOL_L
- CNT
- ----------------
- 62
- ------ prompt MDMADM.CI_CAL_WORK
- CNT
- ----------------
- 1
- ------ prompt MDMADM.CI_CAL_WORK_L
- CNT
- ----------------
- 1
- ------ prompt MDMADM.CI_CHAR_ENTITY
- CNT
- ----------------
- 216
- ------ prompt MDMADM.CI_CHAR_TYPE
- CNT
- ----------------
- 122
- ------ prompt MDMADM.CI_CHAR_TYPE_L
- CNT
- ----------------
- 122
- ------ prompt MDMADM.CI_CHAR_VAL
- CNT
- ----------------
- 99
- ------ prompt MDMADM.CI_CHAR_VAL_L
- CNT
- ----------------
- 99
- ------ prompt MDMADM.CI_CHTY_TDTY
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_CNV_DUP_KEY
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_CNV_KEY_TMP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_COUNTRY
- CNT
- ----------------
- 3
- ------ prompt MDMADM.CI_COUNTRY_L
- CNT
- ----------------
- 3
- ------ prompt MDMADM.CI_CURRENCY_CD
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_CURRENCY_CD_L
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_DAR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DAR_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DAR_USR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DATA_DIFF
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DATA_DIFF_PK
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_INSTR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_INSTR_ALG
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_INSTR_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_INST_OVRD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_PROC
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DB_PROC_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_DISP_ICON
- CNT
- ----------------
- 40
- ------ prompt MDMADM.CI_DISP_ICON_L
- CNT
- ----------------
- 40
- ------ prompt MDMADM.CI_DISP_PROF
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_DISP_PROF_L
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_ENV_REF
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ENV_REF_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_FK_REF
- CNT
- ----------------
- 252
- ------ prompt MDMADM.CI_FK_REF_L
- CNT
- ----------------
- 252
- ------ prompt MDMADM.CI_FUNC
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_FUNC_FLD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_FUNC_FLD_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_FUNC_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_GEO_TYPE
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_GEO_TYPE_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_INSTALL_ALG
- CNT
- ----------------
- 1
- ------ prompt MDMADM.CI_INSTALL_MSG
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_INSTALL_MSG_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_INSTALL_PROD
- CNT
- ----------------
- 5
- ------ prompt MDMADM.CI_LANGUAGE
- CNT
- ----------------
- 1
- ------ prompt MDMADM.CI_LOOKUP_FIELD
- CNT
- ----------------
- 620
- ------ prompt MDMADM.CI_LOOKUP_VAL
- CNT
- ----------------
- 2,598
- ------ prompt MDMADM.CI_LOOKUP_VAL_L
- CNT
- ----------------
- 2,598
- ------ prompt MDMADM.CI_MD_ATT_TY
- CNT
- ----------------
- 109
- ------ prompt MDMADM.CI_MD_AT_DTL
- CNT
- ----------------
- 108
- ------ prompt MDMADM.CI_MD_AT_DTL_L
- CNT
- ----------------
- 108
- ------ prompt MDMADM.CI_MD_CONST
- CNT
- ----------------
- 2,255
- ------ prompt MDMADM.CI_MD_CONST_FLD
- CNT
- ----------------
- 3,411
- ------ prompt MDMADM.CI_MD_CTL
- CNT
- ----------------
- 20
- ------ prompt MDMADM.CI_MD_CTL_L
- CNT
- ----------------
- 20
- ------ prompt MDMADM.CI_MD_CTL_TMPL
- CNT
- ----------------
- 225
- ------ prompt MDMADM.CI_MD_ELTY
- CNT
- ----------------
- 36
- ------ prompt MDMADM.CI_MD_ELTY_AT
- CNT
- ----------------
- 489
- ------ prompt MDMADM.CI_MD_ELTY_L
- CNT
- ----------------
- 36
- ------ prompt MDMADM.CI_MD_FLD
- CNT
- ----------------
- 7,828
- ------ prompt MDMADM.CI_MD_FLD_L
- CNT
- ----------------
- 7,809
- ------ prompt MDMADM.CI_MD_LOOKUP_F
- CNT
- ----------------
- 12
- ------ prompt MDMADM.CI_MD_MENU
- CNT
- ----------------
- 64
- ------ prompt MDMADM.CI_MD_MENU_IMOD
- CNT
- ----------------
- 202
- ------ prompt MDMADM.CI_MD_MENU_ITEM
- CNT
- ----------------
- 445
- ------ prompt MDMADM.CI_MD_MENU_ITEM_L
- CNT
- ----------------
- 445
- ------ prompt MDMADM.CI_MD_MENU_L
- CNT
- ----------------
- 64
- ------ prompt MDMADM.CI_MD_MENU_LINE
- CNT
- ----------------
- 311
- ------ prompt MDMADM.CI_MD_MENU_LINE_L
- CNT
- ----------------
- 311
- ------ prompt MDMADM.CI_MD_MENU_MOD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_MO
- CNT
- ----------------
- 185
- ------ prompt MDMADM.CI_MD_MO_ALG
- CNT
- ----------------
- 118
- ------ prompt MDMADM.CI_MD_MO_L
- CNT
- ----------------
- 185
- ------ prompt MDMADM.CI_MD_MO_OPT
- CNT
- ----------------
- 964
- ------ prompt MDMADM.CI_MD_MO_TBL
- CNT
- ----------------
- 696
- ------ prompt MDMADM.CI_MD_MO_WRK
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_MSG
- CNT
- ----------------
- 51
- ------ prompt MDMADM.CI_MD_MSG_L
- CNT
- ----------------
- 51
- ------ prompt MDMADM.CI_MD_NAV
- CNT
- ----------------
- 1,337
- ------ prompt MDMADM.CI_MD_PDF
- CNT
- ----------------
- 18
- ------ prompt MDMADM.CI_MD_PDF_VAL
- CNT
- ----------------
- 58
- ------ prompt MDMADM.CI_MD_PRG_COM
- CNT
- ----------------
- 1,023
- ------ prompt MDMADM.CI_MD_PRG_ELEM
- CNT
- ----------------
- 5,661
- ------ prompt MDMADM.CI_MD_PRG_EL_AT
- CNT
- ----------------
- 2,965
- ------ prompt MDMADM.CI_MD_PRG_LOC
- CNT
- ----------------
- 148
- ------ prompt MDMADM.CI_MD_PRG_MOD
- CNT
- ----------------
- 1
- ------ prompt MDMADM.CI_MD_PRG_SEC
- CNT
- ----------------
- 1,247
- ------ prompt MDMADM.CI_MD_PRG_SQL
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_PRG_TAB
- CNT
- ----------------
- 352
- ------ prompt MDMADM.CI_MD_PRG_VAR
- CNT
- ----------------
- 2,654
- ------ prompt MDMADM.CI_MD_RPT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_RPT_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_RPT_LBL
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_RPT_PARM
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_RPT_PARM_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SO
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SOCG
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SOCG_FLD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SOCG_FLDAT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SOCG_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SOCG_SORT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SO_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SO_RSFLD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SO_RSFLDAT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_SRC_TYPE
- CNT
- ----------------
- 8
- ------ prompt MDMADM.CI_MD_SRC_TYPE_L
- CNT
- ----------------
- 8
- ------ prompt MDMADM.CI_MD_SVC
- CNT
- ----------------
- 845
- ------ prompt MDMADM.CI_MD_SVC_L
- CNT
- ----------------
- 845
- ------ prompt MDMADM.CI_MD_SVC_PRG
- CNT
- ----------------
- 530
- ------ prompt MDMADM.CI_MD_TAB_MOD
- CNT
- ----------------
- 8
- ------ prompt MDMADM.CI_MD_TBL
- CNT
- ----------------
- 780
- ------ prompt MDMADM.CI_MD_TBL_FLD
- CNT
- ----------------
- 5,865
- ------ prompt MDMADM.CI_MD_TBL_FLD_L
- CNT
- ----------------
- 5,867
- ------ prompt MDMADM.CI_MD_TBL_L
- CNT
- ----------------
- 780
- ------ prompt MDMADM.CI_MD_TMPL
- CNT
- ----------------
- 61
- ------ prompt MDMADM.CI_MD_TMPL_ELTY
- CNT
- ----------------
- 409
- ------ prompt MDMADM.CI_MD_TMPL_L
- CNT
- ----------------
- 61
- ------ prompt MDMADM.CI_MD_TMPL_VAR
- CNT
- ----------------
- 2,486
- ------ prompt MDMADM.CI_MD_TMPL_VAR_L
- CNT
- ----------------
- 2,137
- ------ prompt MDMADM.CI_MD_TOOLREP_XML
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_TOOL_REP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_VAR
- CNT
- ----------------
- 559
- ------ prompt MDMADM.CI_MD_VAR_DTL
- CNT
- ----------------
- 602
- ------ prompt MDMADM.CI_MD_VAR_DTL_L
- CNT
- ----------------
- 602
- ------ prompt MDMADM.CI_MD_WRK_TBL
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_WRK_TBLFLD
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MD_WRK_TBL_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MPL_EXC
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_MSG
- CNT
- ----------------
- 3,499
- ------ prompt MDMADM.CI_MSG_CATEGORY
- CNT
- ----------------
- 30
- ------ prompt MDMADM.CI_MSG_CATEGORY_L
- CNT
- ----------------
- 30
- ------ prompt MDMADM.CI_MSG_L
- CNT
- ----------------
- 3,498
- ------ prompt MDMADM.CI_MSG_LOG
- CNT
- ----------------
- 30,258,921
- ------ prompt MDMADM.CI_MSG_LOGPARM
- CNT
- ----------------
- 51,438,463
- ------ prompt MDMADM.CI_MSG_LOG_PK
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NAV_OPT
- CNT
- ----------------
- 684
- ------ prompt MDMADM.CI_NAV_OPT_CTXT
- CNT
- ----------------
- 388
- ------ prompt MDMADM.CI_NAV_OPT_L
- CNT
- ----------------
- 684
- ------ prompt MDMADM.CI_NAV_OPT_USG
- CNT
- ----------------
- 1,128
- ------ prompt MDMADM.CI_NT_DNTY_CTXT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_CHAR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_CTXT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_EXC
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_EXP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_FORM
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_FORM_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_K
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_PROF
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_PROF_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_TYPE
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_DWN_TYPE_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP_CHAR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP_CTXT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP_EXCP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP_XTYPE
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_UP_XTYPE_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_NT_XID
- CNT
- ----------------
- 5
- ------ prompt MDMADM.CI_NT_XID_L
- CNT
- ----------------
- 5
- ------ prompt MDMADM.CI_PHONE_TYPE
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_PHONE_TYPE_L
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_PORTAL
- CNT
- ----------------
- 177
- ------ prompt MDMADM.CI_PORTAL_L
- CNT
- ----------------
- 177
- ------ prompt MDMADM.CI_PORTAL_ZONE
- CNT
- ----------------
- 370
- ------ prompt MDMADM.CI_ROLE
- CNT
- ----------------
- 7
- ------ prompt MDMADM.CI_ROLE_L
- CNT
- ----------------
- 7
- ------ prompt MDMADM.CI_ROLE_USER
- CNT
- ----------------
- 2,686
- ------ prompt MDMADM.CI_ROOT_DIFF
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_INSTR
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_INSTR_K
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_OBJ
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_OBJ_EXC
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_OBJ_EXP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_OBJ_K
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_ROOT_OBJ_PK
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_RPT_OPTION
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SCR
- CNT
- ----------------
- 1,394
- ------ prompt MDMADM.CI_SCR_CRT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SCR_CRT_GRP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SCR_CRT_GRP_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SCR_DA
- CNT
- ----------------
- 5,277
- ------ prompt MDMADM.CI_SCR_FLD_MAP
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SCR_L
- CNT
- ----------------
- 1,392
- ------ prompt MDMADM.CI_SCR_PRMPT
- CNT
- ----------------
- 72
- ------ prompt MDMADM.CI_SCR_PRMPT_L
- CNT
- ----------------
- 72
- ------ prompt MDMADM.CI_SCR_STEP
- CNT
- ----------------
- 4,588
- ------ prompt MDMADM.CI_SCR_STEP_L
- CNT
- ----------------
- 4,588
- ------ prompt MDMADM.CI_SC_AUTH_LVL
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SC_AUTH_LVL_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SC_TYPE
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SC_TYPE_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SEAS_SHIFT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SEAS_TM_SHIFT
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SEAS_TM_SHIFT_L
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_SEQ
- CNT
- ----------------
- 2
- ------ prompt MDMADM.CI_STATE
- CNT
- ----------------
- 58
- ------ prompt MDMADM.CI_STATE_L
- CNT
- ----------------
- 58
- ------ prompt MDMADM.CI_SYSDATA_LOG
- CNT
- ----------------
- 0
- ------ prompt MDMADM.CI_TD_DRLKEY
- select count(*) as "CNT" from MDMADM.CI_TD_DRLKEY
- *
- ERROR at line 1:
- ORA-01013: user requested cancel of current operation
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> connect ccbadm/CCBADM
- Connected.
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> desc user_tables
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- TABLE_NAME NOT NULL VARCHAR2(30)
- TABLESPACE_NAME VARCHAR2(30)
- CLUSTER_NAME VARCHAR2(30)
- IOT_NAME VARCHAR2(30)
- STATUS VARCHAR2(8)
- PCT_FREE NUMBER
- PCT_USED NUMBER
- INI_TRANS NUMBER
- MAX_TRANS NUMBER
- INITIAL_EXTENT NUMBER
- NEXT_EXTENT NUMBER
- MIN_EXTENTS NUMBER
- MAX_EXTENTS NUMBER
- PCT_INCREASE NUMBER
- FREELISTS NUMBER
- FREELIST_GROUPS NUMBER
- LOGGING VARCHAR2(3)
- BACKED_UP VARCHAR2(1)
- NUM_ROWS NUMBER
- BLOCKS NUMBER
- EMPTY_BLOCKS NUMBER
- AVG_SPACE NUMBER
- CHAIN_CNT NUMBER
- AVG_ROW_LEN NUMBER
- AVG_SPACE_FREELIST_BLOCKS NUMBER
- NUM_FREELIST_BLOCKS NUMBER
- DEGREE VARCHAR2(40)
- INSTANCES VARCHAR2(40)
- CACHE VARCHAR2(20)
- TABLE_LOCK VARCHAR2(8)
- SAMPLE_SIZE NUMBER
- LAST_ANALYZED DATE
- PARTITIONED VARCHAR2(3)
- IOT_TYPE VARCHAR2(12)
- TEMPORARY VARCHAR2(1)
- SECONDARY VARCHAR2(1)
- NESTED VARCHAR2(3)
- BUFFER_POOL VARCHAR2(7)
- FLASH_CACHE VARCHAR2(7)
- CELL_FLASH_CACHE VARCHAR2(7)
- ROW_MOVEMENT VARCHAR2(8)
- GLOBAL_STATS VARCHAR2(3)
- USER_STATS VARCHAR2(3)
- DURATION VARCHAR2(15)
- SKIP_CORRUPT VARCHAR2(8)
- MONITORING VARCHAR2(3)
- CLUSTER_OWNER VARCHAR2(30)
- DEPENDENCIES VARCHAR2(8)
- COMPRESSION VARCHAR2(8)
- COMPRESS_FOR VARCHAR2(12)
- DROPPED VARCHAR2(3)
- READ_ONLY VARCHAR2(3)
- SEGMENT_CREATED VARCHAR2(3)
- RESULT_CACHE VARCHAR2(7)
- SQL> select TABLE_NAME,NUM_ROWS from user_tables order by TABLE_NAME;
- TABLE_NAME NUM_ROWS
- ------------------------------ ----------
- C0_INSTALLATION 1
- C1_CALC_GRP 687
- C1_CALC_GRP_CHAR 0
- C1_CALC_GRP_L 687
- C1_CALC_RULE 1780
- C1_CALC_RULE_CHAR 1144
- C1_CALC_RULE_CRT 20
- C1_CALC_RULE_CRT_CHAR 0
- C1_CALC_RULE_CRT_L 20
- C1_CALC_RULE_L 1732
- C1_CALC_RULE_MBR_CAT 1381
- C1_CALC_RULE_TRGT_CAT 76
- C1_CL_CAT_TYPE 3
- C1_CL_CAT_TYPE_CHAR 0
- C1_CL_CAT_TYPE_L 3
- C1_CL_CAT_VAL 3
- C1_CL_CAT_VAL_L 3
- C1_COMM_RTE_TYPE 0
- C1_COMM_RTE_TYPE_CHAR 0
- C1_COMM_RTE_TYPE_DVTYP 0
- C1_COMM_RTE_TYPE_L 0
- C1_INITIATIVE 0
- C1_INITIATIVE_CHAR 0
- C1_INITIATIVE_CRITERIA 0
- C1_INITIATIVE_CRITERIA_CHAR 0
- C1_INITIATIVE_CRITERIA_L 0
- C1_INITIATIVE_L 0
- C1_INITIATIVE_LEAD_DEFN 0
- C1_INITIATIVE_LOG 0
- C1_INITIATIVE_LOG_PARM 0
- C1_INITIATIVE_REL_OBJ 0
- C1_INTV_DATA_GTT
- C1_ISS_CTR 0
- C1_ISS_CTR_CHAR 0
- C1_ISS_CTR_DTL 0
- C1_ISS_CTR_L 0
- C1_ISS_CTR_LOG 0
- C1_ISS_CTR_LOG_PARM 0
- C1_LEAD 0
- C1_LEAD_CHAR 0
- C1_LEAD_EVT 0
- C1_LEAD_EVT_CHAR 0
- C1_LEAD_EVT_K 0
- C1_LEAD_EVT_LOG 0
- C1_LEAD_EVT_LOG_PARM 0
- C1_LEAD_EVT_STEP 0
- C1_LEAD_EVT_STEP_K 0
- C1_LEAD_EVT_TYPE 0
- C1_LEAD_EVT_TYPE_CHAR 0
- C1_LEAD_EVT_TYPE_L 0
- C1_LEAD_K 0
- C1_LEAD_LOG 0
- C1_LEAD_LOG_PARM 0
- C1_LEAD_REL_OBJ 0
- C1_LETY_STEP_TYPE 0
- C1_LETY_STEP_TYPE_L 0
- C1_NTF_PREF 0
- C1_NTF_PREF_CHAR 0
- C1_NTF_PREF_ID 0
- C1_NTF_PREF_K 0
- C1_NTF_PREF_LOG 0
- C1_NTF_PREF_LOG_PARM 0
- C1_NTF_TYPE 0
- C1_NTF_TYPE_ALG 0
- C1_NTF_TYPE_CHAR 0
- C1_NTF_TYPE_COMM_RTE_TYPE 0
- C1_NTF_TYPE_DVTYP 0
- C1_NTF_TYPE_L 0
- C1_OFFCYC_BGEN 1474758
- C1_OFFCYC_BGEN_ADJ 0
- C1_OFFCYC_BGEN_BCHG 0
- C1_OFFCYC_BGEN_CHAR 353739
- C1_OFFCYC_BGEN_K 1474758
- C1_OFFCYC_BGEN_LOG 5901354
- C1_OFFCYC_BGEN_LOG_PARM 6150705
- C1_OFFCYC_BGEN_SA 1474758
- C1_PER_CONTDET 0
- C1_PER_CONT_DET_K 0
- C1_PREM_ACTIVITY_GTT
- C1_RC_CALC_GTT
- C1_RC_CALC_LN_GTT
- C1_RC_CHAR_GTT
- C1_RC_READ_GTT
- C1_RC_SQ_GTT
- C1_RC_TRACE_GTT
- C1_REPRESENTATIVE 0
- C1_REPRESENTATIVE_CHAR 0
- C1_REPRESENTATIVE_L 0
- C1_REPRESENTATIVE_LOG 0
- C1_REPRESENTATIVE_LOG_PARM 0
- C1_REP_GRP_MEM 0
- C1_RS_POST_PROC 464
- C1_RS_POST_PROC_L 464
- C1_RS_PRE_PROC 464
- C1_RS_PRE_PROC_L 464
- C1_RS_RV2 539
- C1_RS_RV2_L 539
- C1_TOU_MAP 0
- C1_TOU_MAP_CHAR 0
- C1_TOU_MAP_DATA 0
- C1_TOU_MAP_DATA_CHAR 0
- C1_TOU_MAP_K 0
- C1_TOU_MAP_L 0
- C1_TOU_MAP_LOG 0
- C1_TOU_MAP_LOG_PARM 0
- C1_TOU_MAP_TMPLT 0
- C1_TOU_MAP_TMPLT_CHAR 0
- C1_TOU_MAP_TMPLT_L 0
- C1_TOU_MAP_TYPE 0
- C1_TOU_MAP_TYPE_CHAR 0
- C1_TOU_MAP_TYPE_L 0
- C1_TOU_MAP_TYPE_TMPLT 0
- C1_USAGE 18760111
- C1_USAGE_CHAR 0
- C1_USAGE_K 18910273
- C1_USAGE_LOG 126851716
- C1_USAGE_LOG_PARM 101139953
- C1_USER_TNDR_SRCE 1
- CCBADM_STATS_1 49929
- CI_ACCT 547069
- CI_ACCT_ALERT 221173
- CI_ACCT_ALERT_190615 25923
- CI_ACCT_APAY 494335
- CI_ACCT_APAY_K 494335
- CI_ACCT_CHAR 6821898
- CI_ACCT_K 546310
- CI_ACCT_MGMT_GR 0
- CI_ACCT_MGMT_GR_L 0
- CI_ACCT_MGRP_RL 0
- CI_ACCT_MSG 1
- CI_ACCT_MSG_PRM 0
- CI_ACCT_PER 631592
- CI_ACCT_REL_TYP 13
- CI_ACCT_REL_TYP_L 13
- CI_ACCT_STG 0
- CI_ACC_GRP 1
- CI_ACC_GRP_DAR 1
- CI_ACC_GRP_L 1
- CI_ADJ 21482258
- CI_ADJT_ADJTPRF 91
- CI_ADJ_APREQ 154535
- CI_ADJ_APREQ_K 154535
- CI_ADJ_CALC_LN 242026
- CI_ADJ_CAN_RSN 4
- CI_ADJ_CAN_RSN_L 4
- CI_ADJ_CHAR 622476
- CI_ADJ_CL_CHAR 0
- CI_ADJ_K 20758780
- CI_ADJ_STG_CTL 50
- CI_ADJ_STG_CTL_CHAR 150
- CI_ADJ_STG_CTL_MSGP 0
- CI_ADJ_STG_UP 330072
- CI_ADJ_STG_UP_CHAR 660144
- CI_ADJ_STG_UP_MSGP 18747
- CI_ADJ_TYPE 92
- CI_ADJ_TYPE_L 92
- CI_ADJ_TYP_PROF 7
- CI_ADJ_TYP_PROF_L 7
- CI_ADJ_TY_ALG 157
- CI_ADJ_TY_CHAR 1
- CI_ADM_RVW_SCH 134131
- CI_ALERT_TYPE 20
- CI_ALERT_TYPE_L 20
- CI_ALG 1323
- CI_ALG_L 1323
- CI_ALG_PARM 3737
- CI_ALG_TYPE 1262
- CI_ALG_TYPE_L 1262
- CI_ALG_TYPE_PRM 3324
- CI_ALG_TYPE_PRM_L 3324
- CI_ALG_VER 1314
- CI_AM_ACTIVITY_TYPE 0
- CI_AM_ACTIVITY_TYPE_L 0
- CI_AM_REQ 0
- CI_AM_REQ_K 0
- CI_AM_REQ_LOG 0
- CI_AM_REQ_LOG_PARM 0
- CI_APAY_CLR_STG 7106348
- CI_APAY_CLR_STG_K 6615481
- CI_APAY_RT_TYPE 2
- CI_APAY_RT_TYPE_L 2
- CI_APAY_SRC 9436
- CI_APAY_SRC_L 9436
- CI_APPR_PROF 4
- CI_APPR_PROF_L 4
- CI_APPR_REQ 172262
- CI_APPR_REQ_CHAR 0
- CI_APPR_REQ_K 172252
- CI_APPR_REQ_LOG 1161469
- CI_APPR_REQ_LOG_PARM 495427
- CI_APP_SVC_ACC 2493
- CI_APP_SVC_SCTY 9
- CI_APREQ_TYPE 5
- CI_APREQ_TYPE_L 5
- CI_ARC_ROOT_INST 0
- CI_ARC_ROOT_INST_K 0
- CI_ARC_ROOT_OBJ 0
- CI_ARC_ROOT_OBJ_K 0
- CI_ARC_ROOT_PK 0
- CI_AUDIT 109443195
- CI_AUDIT_K 109443195
- CI_BAL_CTL_GRP 1
- CI_BAL_CTL_MEM 31
- CI_BAL_CTL_TMP 31
- CI_BANK 1
- CI_BANK_ACCOUNT 5
- CI_BANK_ACCOUNT_L 5
- CI_BANK_L 1
- CI_BATCH_CTRL 773
- CI_BATCH_CTRL_ALG 28
- CI_BATCH_CTRL_L 806
- CI_BATCH_CTRL_P 2167
- CI_BATCH_CTRL_P_L 2167
- CI_BATCH_INST 4130429
- CI_BATCH_JOB 3952
- CI_BATCH_JOB_K 3666
- CI_BATCH_JOB_PRM 17871
- CI_BATCH_RUN 261990
- CI_BATCH_THD 4127816
- CI_BCHG_LINE_UP 0
- CI_BCHG_READ 1
- CI_BCHG_SQ 1
- CI_BCHG_UP 0
- CI_BCHG_UP_EXCP 0
- CI_BCHG_UP_OVRD 0
- CI_BCHG_UP_READ 0
- CI_BCHG_UP_SQ 0
- CI_BCHG_UP_XTYP 0
- CI_BCHG_UP_XTYP_L 0
- CI_BF 560
- CI_BFCH_TOUGRP 0
- CI_BF_CHAR 7058
- CI_BF_CHAR_DST 0
- CI_BF_L 560
- CI_BF_VAL 12559
- CI_BILL 4137500
- CI_BILL_CAN_RSN 8
- CI_BILL_CAN_RSN_L 8
- CI_BILL_CHAR 0
- CI_BILL_CHG 1
- CI_BILL_CHG_K 1
- CI_BILL_CYC 464
- CI_BILL_CYC_L 464
- CI_BILL_CYC_SCH 2084
- CI_BILL_EXCP 13470
- CI_BILL_K 4099205
- CI_BILL_MSG 3
- CI_BILL_MSGS 290
- CI_BILL_MSG_L 3
- CI_BILL_MSG_PRM 273
- CI_BILL_PERIOD 0
- CI_BILL_PERIOD_L 0
- CI_BILL_PER_SCH 0
- CI_BILL_ROUTING 4023879
- CI_BILL_RT_TYPE 6
- CI_BILL_RT_TYPE_L 6
- CI_BILL_RVW_SCH 0
- CI_BILL_SA 12630783
- CI_BILL_SCNR 4
- CI_BILL_SCNR_K 4
- CI_BILL_SCNR_SQ 0
- CI_BILL_SEG_TYP 7
- CI_BILL_SEG_TYP_L 7
- CI_BPRT_GRP 0
- CI_BPRT_GRP_K 0
- CI_BPRT_SGRP_SA 0
- CI_BPRT_SUBGRP 0
- CI_BSEG 8278001
- CI_BSEG_CALC 13601659
- CI_BSEG_CALC_LN 29256233
- CI_BSEG_CL_CHAR 18741402
- CI_BSEG_EXCP 119148
- CI_BSEG_ITEM 0
- CI_BSEG_K 8203383
- CI_BSEG_MSG 3729197
- CI_BSEG_READ 38860920
- CI_BSEG_SQ 19869173
- CI_BUD_PLAN 0
- CI_BUD_PLAN_L 0
- CI_BUD_RVW 0
- CI_B_CHG_LINE 1
- CI_B_CHG_TMPLT 0
- CI_B_CHG_TMPLT_L 0
- CI_B_LN_CHAR 0
- CI_B_LN_UP_CHAR 0
- CI_B_TMPLT_LINE 0
- CI_B_TMPLT_LINE_L 0
- CI_B_TMPLT_SQ 0
- CI_B_TM_LN_CHA 0
- CI_CAL_GL 1
- CI_CAL_GL_L 1
- CI_CAL_HOL 49
- CI_CAL_HOL_L 49
- CI_CAL_PERIOD 97
- CI_CAL_PERIOD_L 97
- CI_CAL_WORK 1
- CI_CAL_WORK_L 1
- CI_CAMPAIGN 0
- CI_CAMPAIGN_L 0
- CI_CAMP_ALG 0
- CI_CAMP_FLD_TYPE 0
- CI_CAMP_FLD_TYPE_L 0
- CI_CASE 564861
- CI_CASE_CHAR 4598271
- CI_CASE_K 555551
- CI_CASE_LOG 6175160
- CI_CASE_LOG_PARM 11785539
- CI_CASE_STATUS 149
- CI_CASE_STATUS_L 149
- CI_CASE_ST_ALG 153
- CI_CASE_ST_CHTY 302
- CI_CASE_TR_RULE 231
- CI_CASE_TR_RULE_L 231
- CI_CASE_TYPE 13
- CI_CASE_TYPE_ALG 1
- CI_CASE_TYPE_L 13
- CI_CC 7183901
- CI_CCL_CTL_ALG 19
- CI_CC_CHAR 8086184
- CI_CC_CL 18
- CI_CC_CL_L 18
- CI_CC_K 7183901
- CI_CC_LOG 1313346
- CI_CC_LOG_K 1313346
- CI_CC_TYPE 167
- CI_CC_TYPE_L 167
- CI_CEVT_CAN_RSN 0
- CI_CEVT_CAN_RSN_L 0
- CI_CHAR_DFLT 0
- CI_CHAR_DFLT_SV 0
- CI_CHAR_ENTITY 563
- CI_CHAR_TYPE 402
- CI_CHAR_TYPE_L 402
- CI_CHAR_VAL 655
- CI_CHAR_VAL_L 655
- CI_CHG_LOG 0
- CI_CHTY_ADJTY 37
- CI_CHTY_CASETY 127
- CI_CHTY_CCTY 204
- CI_CHTY_COPTY 0
- CI_CHTY_COP_ETY 0
- CI_CHTY_DV_TTYP 0
- CI_CHTY_FATY 0
- CI_CHTY_ITTY 0
- CI_CHTY_MTTY 10
- CI_CHTY_SCMTY 1
- CI_CHTY_SPTY 37
- CI_CHTY_TDTY 85
- CI_CHTY_TOSTY 0
- CI_CHTY_UATY 0
- CI_CIS_DIVISION 1
- CI_CIS_DIVISION_L 1
- CI_CIS_DIV_CHAR 0
- CI_CNV_DUP_KEY 0
- CI_CNV_KEY_TMP 0
- CI_COLL_AGY 13
- CI_COLL_AGY_HIS 47198
- CI_COLL_AGY_L 13
- CI_COLL_AGY_REF 30112
- CI_COLL_AGY_REF_K 30112
- CI_COLL_CL 4
- CI_COLL_CL_CNTL 2
- CI_COLL_CL_CNTL_L 2
- CI_COLL_CL_L 4
- CI_COLL_CRIT 2
- CI_COLL_CRIT_CT 2
- CI_COLL_EVT 3802913
- CI_COLL_EVT_CC 741235
- CI_COLL_EVT_TYP 14
- CI_COLL_EVT_TYP_L 14
- CI_COLL_PROC 449414
- CI_COLL_PROC_K 449414
- CI_COLL_PROC_SA 521259
- CI_COLL_PROC_TM 2
- CI_COLL_PROC_TM_L 2
- CI_COLL_RESP 18
- CI_COL_REF 0
- CI_COL_REF_ALG 0
- CI_COL_REF_L 0
- CI_CONSV_PROG 0
- CI_CONSV_PROG_CHAR 0
- CI_CONSV_PROG_L 0
- CI_CONT_QTY_TMP 0
- CI_CONT_QTY_TYP 0
- CI_CONT_QTY_TYP_L 0
- CI_COP 0
- CI_COP_CHAR 0
- CI_COP_EVT 0
- CI_COP_EVT_CHAR 0
- CI_COP_EVT_EXC 0
- CI_COP_EVT_EXP 0
- CI_COP_EVT_K 0
- CI_COP_EVT_TYPE 0
- CI_COP_EVT_TYPE_L 0
- CI_COP_K 0
- CI_COP_L 0
- CI_COP_TYPE 0
- CI_COP_TYPE_ALG 0
- CI_COP_TYPE_L 0
- CI_COUNTRY 1
- CI_COUNTRY_L 1
- CI_CR_RAT_HIST 129
- CI_CR_RAT_HIST_K 129
- CI_CR_UNIT 1
- CI_CR_UNIT_L 1
- CI_CURRENCY_CD 1
- CI_CURRENCY_CD_L 1
- CI_CUST_CL 5
- CI_CUST_CL_CTRL 2
- CI_CUST_CL_L 5
- CI_CUST_CL_MSG 0
- CI_CUT_EVT 0
- CI_CUT_EVT_DEP 0
- CI_CUT_EVT_TYPE 0
- CI_CUT_EVT_TYPE_L 0
- CI_CUT_EVT_TYP_ALG 0
- CI_CUT_PROC 0
- CI_CUT_PROC_K 0
- CI_CUT_PROC_TMP 0
- CI_CUT_PROC_TMP_L 0
- CI_CUT_PROC_TM_ALG 0
- CI_CUT_RESP 0
- CI_CUT_RESP_DEP 0
- CI_CVAL_TMPL 0
- CI_CVAL_TOU_TMP 0
- CI_DAR 1
- CI_DAR_L 1
- CI_DAR_USR 2062
- CI_DATA_DIFF 0
- CI_DATA_DIFF_PK 0
- CI_DB_INSTR 4
- CI_DB_INSTR_ALG 1
- CI_DB_INSTR_L 4
- CI_DB_INST_OVRD 1
- CI_DB_PROC 1
- CI_DB_PROC_L 1
- CI_DCL 0
- CI_DCL_K 0
- CI_DC_ALG 5
- CI_DEBT_CL 5
- CI_DEBT_CL_L 5
- CI_DEG_DAY 0
- CI_DEP_CL 0
- CI_DEP_CL_L 0
- CI_DEP_CTL 2812
- CI_DEP_CTL_CHAR 0
- CI_DEP_CTL_K 2812
- CI_DEP_CTL_ST 2130
- CI_DEP_CTL_ST_091215 1
- CI_DEP_CTL_ST_271015 462
- CI_DEP_CTL_ST_BACKUP 391
- CI_DEP_RVW 0
- CI_DG_APP_SCHED 0
- CI_DG_APP_SCHED_K 0
- CI_DISCON_LOC 1
- CI_DISCON_LOC_L 1
- CI_DISP_GRP 0
- CI_DISP_GRP_ALG 0
- CI_DISP_GRP_L 0
- CI_DISP_GRP_REP 0
- CI_DISP_ICON 61
- CI_DISP_ICON_L 61
- CI_DISP_PROF 2
- CI_DISP_PROF_L 2
- CI_DIV_TD_ROLE 0
- CI_DST_CD_CHAR 5
- CI_DST_CODE 27
- CI_DST_CODE_EFF 27
- CI_DST_CODE_L 27
- CI_DST_RULE 0
- CI_DST_RULE_ALG 0
- CI_DST_RULE_L 0
- CI_DV_TEST 0
- CI_DV_TEST_CHAR 0
- CI_DV_TEST_COMP 0
- CI_DV_TEST_EXCP 0
- CI_DV_TEST_K 0
- CI_DV_TEST_RES 0
- CI_DV_TEST_SEL 0
- CI_DV_TEST_SEL_K 0
- CI_DV_TEST_TYPE 0
- CI_DV_TEST_TYPE_L 0
- CI_DV_TTYP_CHAR 0
- CI_DV_TTYP_COMP 0
- CI_DV_TTYP_ITEM 0
- CI_DV_TTYP_MTR 0
- CI_ENRL 0
- CI_ENRL_ADDR 0
- CI_ENRL_CAN_RSN 0
- CI_ENRL_CAN_RSN_L 0
- CI_ENRL_CBK_RSN 0
- CI_ENRL_CBK_RSN_L 0
- CI_ENRL_FLD 0
- CI_ENRL_K 0
- CI_ENRL_LOG 0
- CI_ENRL_PER_ID 0
- CI_ENRL_PER_NM 0
- CI_ENRL_PER_PHN 0
- CI_ENV_REF 0
- CI_ENV_REF_L 0
- CI_FA 0
- CI_FAC_LVL_1 0
- CI_FAC_LVL_1_2 0
- CI_FAC_LVL_1_L 0
- CI_FAC_LVL_2 0
- CI_FAC_LVL_2_3 0
- CI_FAC_LVL_2_L 0
- CI_FAC_LVL_3 0
- CI_FAC_LVL_3_L 0
- CI_FAC_LVL_NAME 0
- CI_FAC_LVL_NAME_L 0
- CI_FAPR_FATY 0
- CI_FAPR_TMPL 0
- CI_FA_CAN_RSN 0
- CI_FA_CAN_RSN_L 0
- CI_FA_CHAR 0
- CI_FA_CMPL_CTRL 0
- CI_FA_K 0
- CI_FA_LOG 0
- CI_FA_REM 0
- CI_FA_REM_ALG 0
- CI_FA_REM_CD 0
- CI_FA_REM_CD_L 0
- CI_FA_REM_EXC 0
- CI_FA_REM_EXP 0
- CI_FA_RESCHED_RSN 0
- CI_FA_RESCHED_RSN_L 0
- CI_FA_STAGE_UP 0
- CI_FA_STEP 0
- CI_FA_STEP_TYPE 0
- CI_FA_STEP_TYPE_L 0
- CI_FA_STGUP_CHAR 0
- CI_FA_STGUP_EXC 0
- CI_FA_STGUP_REM 0
- CI_FA_STP_STGUP 0
- CI_FA_TYPE 0
- CI_FA_TYPE_CHAR 0
- CI_FA_TYPE_L 0
- CI_FA_TYPE_PROF 0
- CI_FA_TYPE_PROF_L 0
- CI_FK_REF 497
- CI_FK_REF_L 470
- CI_FO 0
- CI_FO_K 0
- CI_FO_STG_DWN 0
- CI_FREQ 6
- CI_FREQ_L 6
- CI_FS_CL 0
- CI_FS_CL_DFLT 0
- CI_FS_CL_L 0
- CI_FS_CTRL 0
- CI_FS_DGRP 0
- CI_FS_OP_AREA 0
- CI_FT 45720323
- CI_FT_GL 88055352
- CI_FT_K 44373229
- CI_FT_PROC 24894544
- CI_FUNC 0
- CI_FUNC_FLD 0
- CI_FUNC_FLD_L 0
- CI_FUNC_L 0
- CI_FUND 0
- CI_FUND_L 0
- CI_GEO_DFLT_SVC 0
- CI_GEO_TYPE 4
- CI_GEO_TYPE_L 4
- CI_GEO_TYP_DFLT 0
- CI_GL_DIVISION 1
- CI_GL_DIVISION_L 1
- CI_HI_LO_FACTOR 0
- CI_ID_TYPE 8
- CI_ID_TYPE_L 8
- CI_INSTALL_ALG 52
- CI_INSTALL_MSG 1
- CI_INSTALL_MSG_L 1
- CI_INSTALL_PROD 3
- CI_INTV_DATA 0
- CI_INTV_DATA_SET 0
- CI_INTV_DATA_SET_K 0
- CI_INTV_DS_EXC 0
- CI_INTV_PF 0
- CI_INTV_PFRELTY 0
- CI_INTV_PFRELTY_L 0
- CI_INTV_PF_ALG 0
- CI_INTV_PF_K 0
- CI_INTV_PF_L 0
- CI_INTV_PF_TYP 0
- CI_INTV_PF_TYP_L 0
- CI_INTV_REG_ALG 0
- CI_INTV_REG_TYP 4
- CI_INTV_REG_TYP_L 4
- CI_INTV_VAL 0
- CI_INTV_VAL_SET 0
- CI_INTV_VAL_SET_K 0
- CI_ITEM 0
- CI_ITEM_CHAR 0
- CI_ITEM_EQ 0
- CI_ITEM_K 0
- CI_ITEM_LOC_HIS 0
- CI_ITEM_LOC_HIS_K 0
- CI_ITEM_SQ_EST 0
- CI_ITEM_STK_LOC 0
- CI_ITEM_TYPE 2
- CI_ITEM_TYPE_EQ 0
- CI_ITEM_TYPE_L 2
- CI_ITEM_TYP_CHA 0
- CI_LANDLORD 0
- CI_LANDLORD_K 0
- CI_LANGUAGE 1
- CI_LETTER_TMPL 109
- CI_LETTER_TMPL_L 109
- CI_LL_DETAIL 0
- CI_LOOKUP_FIELD 1084
- CI_LOOKUP_VAL 5734
- CI_LOOKUP_VAL_L 5743
- CI_MATCH_EVT 0
- CI_MATCH_EVT_K 0
- CI_MATCH_TYPE 0
- CI_MATCH_TYPE_L 0
- CI_MD_ATT_TY 109
- CI_MD_AT_DTL 108
- CI_MD_AT_DTL_L 108
- CI_MD_CONST 4426
- CI_MD_CONST_FLD 6551
- CI_MD_CTL 20
- CI_MD_CTL_L 20
- CI_MD_CTL_TMPL 225
- CI_MD_ELTY 36
- CI_MD_ELTY_AT 489
- CI_MD_ELTY_L 36
- CI_MD_FLD 15399
- CI_MD_FLD_L 15381
- CI_MD_LOOKUP_F 12
- CI_MD_MENU 119
- CI_MD_MENU_IMOD 1218
- CI_MD_MENU_ITEM 1358
- CI_MD_MENU_ITEM_L 1355
- CI_MD_MENU_L 119
- CI_MD_MENU_LINE 997
- CI_MD_MENU_LINE_L 997
- CI_MD_MENU_MOD 0
- CI_MD_MO 396
- CI_MD_MO_ALG 106
- CI_MD_MO_L 396
- CI_MD_MO_OPT 1488
- CI_MD_MO_TBL 1365
- CI_MD_MO_WRK 0
- CI_MD_MSG 51
- CI_MD_MSG_L 51
- CI_MD_NAV 4359
- CI_MD_PDF 18
- CI_MD_PDF_VAL 58
- CI_MD_PRG_COM 10875
- CI_MD_PRG_ELEM 33446
- CI_MD_PRG_EL_AT 17706
- CI_MD_PRG_LOC 652
- CI_MD_PRG_MOD 487
- CI_MD_PRG_SEC 6325
- CI_MD_PRG_SQL 18174
- CI_MD_PRG_TAB 885
- CI_MD_PRG_VAR 71386
- CI_MD_RPT 0
- CI_MD_RPT_L 0
- CI_MD_RPT_LBL 0
- CI_MD_RPT_PARM 0
- CI_MD_RPT_PARM_L 0
- CI_MD_SO 14
- CI_MD_SOCG 36
- CI_MD_SOCG_FLD 60
- CI_MD_SOCG_FLDAT 12
- CI_MD_SOCG_L 36
- CI_MD_SOCG_SORT 20
- CI_MD_SO_L 14
- CI_MD_SO_RSFLD 79
- CI_MD_SO_RSFLDAT 8
- CI_MD_SRC_TYPE 8
- CI_MD_SRC_TYPE_L 8
- CI_MD_SVC 2574
- CI_MD_SVC_L 2565
- CI_MD_SVC_PRG 2237
- CI_MD_TAB_MOD 52
- CI_MD_TBL 1741
- CI_MD_TBL_FLD 11994
- CI_MD_TBL_FLD_L 11994
- CI_MD_TBL_L 1693
- CI_MD_TMPL 61
- CI_MD_TMPL_ELTY 409
- CI_MD_TMPL_L 61
- CI_MD_TMPL_VAR 2484
- CI_MD_TMPL_VAR_L 2135
- CI_MD_TOOLREP_XML 0
- CI_MD_TOOL_REP 0
- CI_MD_VAR 557
- CI_MD_VAR_DTL 600
- CI_MD_VAR_DTL_L 600
- CI_MD_WRK_TBL 0
- CI_MD_WRK_TBLFLD 0
- CI_MD_WRK_TBL_L 0
- CI_MEVT_CAN_RSN 0
- CI_MEVT_CAN_RSN_L 0
- CI_MFG 1
- CI_MFG_L 1
- CI_MKTMSG_TYPE 0
- CI_MKTMSG_TYPE_ALG 0
- CI_MKTMSG_TYPE_CHAR 0
- CI_MKTMSG_TYPE_L 0
- CI_MODEL 2
- CI_MODEL_L 2
- CI_MPL_EXC 0
- CI_MR 906997
- CI_MRR_STGE_UP 0
- CI_MR_CHAR 0
- CI_MR_CYC 457
- CI_MR_CYC_L 457
- CI_MR_INSTR 0
- CI_MR_INSTR_L 0
- CI_MR_K 906971
- CI_MR_REM 0
- CI_MR_REM_ACTN 0
- CI_MR_REM_BMSG 0
- CI_MR_REM_EXCP 0
- CI_MR_RTE 457
- CI_MR_RTE_CHAR 0
- CI_MR_RTE_L 457
- CI_MR_RTE_TYPE 1
- CI_MR_RTE_TYPE_L 1
- CI_MR_SCHED 0
- CI_MR_SCHED_RTE 0
- CI_MR_SOURCE 0
- CI_MR_SOURCE_L 0
- CI_MR_STAGE_DWN 0
- CI_MR_STAGE_UP 0
- CI_MR_STGUP_CHAR 0
- CI_MR_STGUP_EXC 0
- CI_MR_WARN 0
- CI_MR_WARN_L 0
- CI_MSG 13279
- CI_MSG_CATEGORY 66
- CI_MSG_CATEGORY_L 66
- CI_MSG_L 13278
- CI_MSG_LOG 19265217
- CI_MSG_LOGPARM 42509464
- CI_MSG_LOG_PK 11
- CI_MTR 864260
- CI_MTR_CFGTY_RL 31
- CI_MTR_CHAR 0
- CI_MTR_CONFIG 864032
- CI_MTR_CONFIG_K 864035
- CI_MTR_CONFIG_TY 19
- CI_MTR_CONFIG_TY_L 19
- CI_MTR_EQ 0
- CI_MTR_ID 2
- CI_MTR_ID_TYPE 1
- CI_MTR_ID_TYPE_L 1
- CI_MTR_K 864260
- CI_MTR_LOC 0
- CI_MTR_LOC_HIS 0
- CI_MTR_LOC_HIS_K 0
- CI_MTR_LOC_L 0
- CI_MTR_STK_LOC 0
- CI_MTR_TYPE 7
- CI_MTR_TYPE_EQ 0
- CI_MTR_TYPE_L 7
- CI_MTR_TYP_CHAR 2
- CI_MTR_TY_CFGTY 18
- CI_MULT_ITEM 0
- CI_NAV_OPT 2324
- CI_NAV_OPT_CTXT 1767
- CI_NAV_OPT_L 2324
- CI_NAV_OPT_USG 3044
- CI_NB_RULE 3
- CI_NB_RULE_L 3
- CI_NB_RULE_PARM 17
- CI_NB_RULE_VER 3
- CI_NB_SA 476989
- CI_NB_SCHED_PAY 1088268
- CI_NB_SCHED_PAY_261115 874
- CI_NB_SCHED_PAY_K 1292438
- CI_NB_SCHED_PAY_K_261115 770
- CI_NCD 0
- CI_NCD_TYPE 0
- CI_NCD_TYPE_L 0
- CI_NT_DNTY_CTXT 0
- CI_NT_DWN 0
- CI_NT_DWN_CHAR 0
- CI_NT_DWN_CTXT 0
- CI_NT_DWN_EXC 0
- CI_NT_DWN_EXP 0
- CI_NT_DWN_FORM 0
- CI_NT_DWN_FORM_L 0
- CI_NT_DWN_K 0
- CI_NT_DWN_PROF 0
- CI_NT_DWN_PROF_L 0
- CI_NT_DWN_TYPE 0
- CI_NT_DWN_TYPE_L 0
- CI_NT_UP 0
- CI_NT_UP_CHAR 0
- CI_NT_UP_CTXT 0
- CI_NT_UP_EXCP 0
- CI_NT_UP_XSPL 0
- CI_NT_UP_XTYPE 0
- CI_NT_UP_XTYPE_L 0
- CI_NT_XID 15
- CI_NT_XID_L 15
- CI_OD_EVT 0
- CI_OD_EVT_DEP 0
- CI_OD_EVT_TYPE 0
- CI_OD_EVT_TYPE_ALG 0
- CI_OD_EVT_TYPE_L 0
- CI_OD_PROC 0
- CI_OD_PROC_K 0
- CI_OD_PROC_LOG 0
- CI_OD_PROC_LOGPARM 0
- CI_OD_PROC_OBJ 0
- CI_OD_PROC_TMP 0
- CI_OD_PROC_TMP_ALG 0
- CI_OD_PROC_TMP_L 0
- CI_OD_RESP 0
- CI_OD_RESP_DEP 0
- CI_OD_RULE_ALG 0
- CI_OEVT_CAN_RSN 0
- CI_OEVT_CAN_RSN_L 0
- CI_OP_AREA 0
- CI_OP_AREA_L 0
- CI_PAY 11166029
- CI_PAY_CAN_RSN 8
- CI_PAY_CAN_RSN_L 8
- CI_PAY_CHAR 17225
- CI_PAY_EVENT 11168287
- CI_PAY_EVENT_K 10604446
- CI_PAY_EVT_CHAR 0
- CI_PAY_EVT_EXCP 4193
- CI_PAY_EXCP 811
- CI_PAY_K 10602188
- CI_PAY_METH 2
- CI_PAY_METH_L 2
- CI_PAY_SEG 13912035
- CI_PAY_SEG_K 13912922
- CI_PAY_SEG_TYPE 1
- CI_PAY_SEG_TYPE_L 1
- CI_PAY_ST 0
- CI_PAY_TMPL 0
- CI_PAY_TMPL_L 0
- CI_PAY_TNDR 10604507
- CI_PAY_TNDR_CHAR 0
- CI_PAY_TNDR_K 10604507
- CI_PAY_TNDR_ST 413558
- CI_PAY_TNDR_ST_091215 114
- CI_PAY_TNDR_ST_271015 87408
- CI_PAY_TNDR_ST_BACKUP 77959
- CI_PAY_TNDR_ST_CHAR 17073
- CI_PER 625987
- CI_PER_ADDR_OVRD 11811
- CI_PER_ADDR_SEAS 9
- CI_PER_CHAR 487822
- CI_PER_ID 1170837
- CI_PER_K 625987
- CI_PER_NAME 629751
- CI_PER_PER 0
- CI_PER_PHONE 754675
- CI_PER_REL_TYPE 0
- CI_PER_REL_TYPE_L 0
- CI_PEVT_DST_DTL 0
- CI_PEVT_DTL_ST 0
- CI_PFRELTY_PFTY 0
- CI_PHONE_TYPE 2
- CI_PHONE_TYPE_L 2
- CI_PKG 0
- CI_PKG_CRT 0
- CI_PKG_CRT_GRP 0
- CI_PKG_CRT_GRP_L 0
- CI_PKG_FLD_OVRD 0
- CI_PKG_FLD_OVRD_L 0
- CI_PKG_INSTR 0
- CI_PKG_INSTR_L 0
- CI_PKG_K 0
- CI_PKG_L 0
- CI_PKG_SA_TYPE 0
- CI_PORTAL 169
- CI_PORTAL_L 169
- CI_PORTAL_ZONE 376
- CI_POST_DFLT 0
- CI_PP 22013
- CI_PP_K 22013
- CI_PP_SCHED_PAY 144054
- CI_PP_TYPE 1
- CI_PP_TYPE_L 1
- CI_PREM 459500
- CI_PREM_CHAR 1
- CI_PREM_GEO 53
- CI_PREM_K 459500
- CI_PREM_TYPE 2
- CI_PREM_TYPE_L 2
- CI_PRM_ALT_ADDR 0
- CI_PRM_ALT_ADDR_K 0
- CI_PROP_DCL_RSN 0
- CI_PROP_DCL_RSN_L 0
- CI_PROTOCOL 0
- CI_PROTOCOL_L 0
- CI_QTE_RTE_TYPE 0
- CI_QTE_RTE_TYPE_L 0
- CI_QUOTE 0
- CI_QUOTE_DTL 0
- CI_QUOTE_DTL_K 0
- CI_QUOTE_K 0
- CI_QUOTE_RTG 0
- CI_RC 0
- CI_RC_CHAR 0
- CI_RC_CRT 0
- CI_RC_CRT_GRP 0
- CI_RC_CRT_GRP_L 0
- CI_RC_GL_DST 0
- CI_RC_L 0
- CI_RC_XREF 0
- CI_RDR_TMPL 0
- CI_READER_REM 0
- CI_READER_REM_L 0
- CI_READ_OUT_TYP 1
- CI_READ_OUT_TYP_L 1
- CI_REBATE_CLAIM 0
- CI_REBATE_CLAIM_CHAR 0
- CI_REBATE_CLAIM_K 0
- CI_REBATE_CLAIM_LOG 0
- CI_REBATE_CLAIM_LOG_PARM 0
- CI_REBATE_DEFN 0
- CI_REBATE_DEFN_L 0
- CI_REBATE_LINE 0
- CI_REBATE_LINE_CHAR 0
- CI_REG 924545
- CI_REG_CHAR 1410611
- CI_REG_DATA 0
- CI_REG_DATA_SET 0
- CI_REG_DATA_SET_K 0
- CI_REG_DS_EXC 0
- CI_REG_DS_EXP 0
- CI_REG_K 924545
- CI_REG_READ 963930
- CI_REG_READ_K 963995
- CI_REG_RULE 0
- CI_REG_RULE_L 0
- CI_REP 0
- CI_REPL_ACCT 0
- CI_REPL_CNTL 0
- CI_REP_L 0
- CI_RETIRE_RSN 1
- CI_RETIRE_RSN_L 1
- CI_REV_CL 3
- CI_REV_CL_L 3
- CI_ROLE 56
- CI_ROLE_L 54
- CI_ROLE_USER 13163
- CI_ROOT_DIFF 0
- CI_ROOT_INSTR 0
- CI_ROOT_INSTR_K 0
- CI_ROOT_OBJ 0
- CI_ROOT_OBJ_EXC 0
- CI_ROOT_OBJ_EXP 0
- CI_ROOT_OBJ_K 0
- CI_ROOT_OBJ_PK 0
- CI_RPT_OPTION 0
- CI_RR_STAGE_UP 0
- CI_RS 479
- CI_RS_BMSG 0
- CI_RS_L 469
- CI_RS_MTR_CFGTY 779
- CI_RS_REG_RULE 0
- CI_RS_SQ_RULE 0
- CI_RS_SUB_RS 0
- CI_RV 0
- CI_RV_L 0
- CI_SA 2514839
- CI_SATY_ALG 67
- CI_SATY_COPTY 0
- CI_SATY_SARELTY 0
- CI_SATY_TMAPRTY 0
- CI_SAT_ADJ_PROF 41
- CI_SAT_NB_RULE 3
- CI_SAT_PFRELTY 0
- CI_SA_CHAR 3546452
- CI_SA_CHAR_TMP 1173
- CI_SA_CONTERM 61337
- CI_SA_CONT_QTY 0
- CI_SA_COP 0
- CI_SA_COP_K 0
- CI_SA_COP_OVRD 0
- CI_SA_INTV_PF 0
- CI_SA_K 2514839
- CI_SA_MSG 0
- CI_SA_NB_PARM 2274455
- CI_SA_RCHG_HIST 0
- CI_SA_REL 0
- CI_SA_REL_K 0
- CI_SA_REL_TYPE 0
- CI_SA_REL_TYPE_L 0
- CI_SA_RS_HIST 1898567
- CI_SA_SP 1895397
- CI_SA_SP_CHAR 0
- CI_SA_SP_FA 0
- CI_SA_SP_K 1895403
- CI_SA_SP_TYPE 8
- CI_SA_TC 0
- CI_SA_TOU_MAP 0
- CI_SA_TYPE 18
- CI_SA_TYPE_BC 0
- CI_SA_TYPE_CHAR 15
- CI_SA_TYPE_L 18
- CI_SA_TYPE_RS 466
- CI_SCM 338125
- CI_SCMTY_SATY 0
- CI_SCMTY_SUBCAT 0
- CI_SCMTY_SUBCAT_L 0
- CI_SCM_ACCT 338127
- CI_SCM_CHAR 56612
- CI_SCM_K 338125
- CI_SCM_NCTV_RSN 5
- CI_SCM_NCTV_RSN_L 5
- CI_SCM_TYPE 1
- CI_SCM_TYPE_ALG 0
- CI_SCM_TYPE_L 1
- CI_SCR 1645
- CI_SCR_CRT 0
- CI_SCR_CRT_GRP 0
- CI_SCR_CRT_GRP_L 0
- CI_SCR_DA 8183
- CI_SCR_FLD_MAP 0
- CI_SCR_L 1645
- CI_SCR_PRMPT 145
- CI_SCR_PRMPT_L 145
- CI_SCR_STEP 7835
- CI_SCR_STEP_L 7835
- CI_SC_AUTH_LVL 14
- CI_SC_AUTH_LVL_L 14
- CI_SC_EVT 9837022
- CI_SC_EVTTY_ALG 2
- CI_SC_EVT_FT 4257866
- CI_SC_EVT_FT_K 4257866
- CI_SC_EVT_K 9589361
- CI_SC_EVT_TYPE 8
- CI_SC_EVT_TYPE_L 8
- CI_SC_TYPE 8
- CI_SC_TYPE_L 8
- CI_SEAS_SHIFT 0
- CI_SEAS_TM_SHIFT 0
- CI_SEAS_TM_SHIFT_L 0
- CI_SEQ 5
- CI_SEV_CRIT 0
- CI_SEV_EVT 0
- CI_SEV_EVT_CC 0
- CI_SEV_EVT_DEP 0
- CI_SEV_EVT_FA 0
- CI_SEV_EVT_TYPE 1
- CI_SEV_EVT_TYPE_L 1
- CI_SEV_PROC 0
- CI_SEV_PROC_K 0
- CI_SEV_PROC_TMP 1
- CI_SEV_PROC_TMP_L 1
- CI_SEV_RESP 1
- CI_SEV_RESP_DEP 0
- CI_SIC 0
- CI_SIC_L 0
- CI_SP 863471
- CI_SPR 0
- CI_SPR_BMSG 0
- CI_SPR_L 0
- CI_SPR_POST 0
- CI_SPR_SARELTY 0
- CI_SPR_VALID 0
- CI_SPTY_ITEMTY 0
- CI_SPTY_MTRTY 7
- CI_SP_CHAR 6427022
- CI_SP_EQ 0
- CI_SP_GEO 856588
- CI_SP_ITEM_EVT 0
- CI_SP_ITEM_HIST 0
- CI_SP_ITEM_HIST_K 0
- CI_SP_K 863471
- CI_SP_MTR_EVT 890921
- CI_SP_MTR_HIST 860962
- CI_SP_MTR_HIST_K 863508
- CI_SP_MULT_ITEM 9
- CI_SP_OP_AREA 0
- CI_SP_RTE 0
- CI_SP_RTE_CFG 0
- CI_SP_TYPE 2
- CI_SP_TYPE_CHAR 0
- CI_SP_TYPE_EQ 0
- CI_SP_TYPE_L 2
- CI_SQI 8
- CI_SQI_L 8
- CI_SQ_RULE 0
- CI_SQ_RULE_L 0
- CI_SS_ADDR_OVRD 836
- CI_SS_OPT 391
- CI_SS_OPT_COP 0
- CI_SS_OPT_IP 0
- CI_SS_OPT_L 391
- CI_SS_OPT_TC 0
- CI_SS_OPT_TMAP 0
- CI_SS_PHONE_OVRD 722
- CI_STATE 0
- CI_STATE_L 0
- CI_STK_LOC 0
- CI_STK_LOC_CHAR 0
- CI_STK_LOC_L 0
- CI_STM 335601
- CI_STM_CNST 762494
- CI_STM_CNST_DTL 1558524
- CI_STM_CNST_DTL_K 1558524
- CI_STM_CNST_K 762494
- CI_STM_CYC 376
- CI_STM_CYC_L 376
- CI_STM_CYC_SCH 511
- CI_STM_DTL 1686667
- CI_STM_DTL_K 1686667
- CI_STM_K 335718
- CI_STM_RTE_TY 6
- CI_STM_RTE_TY_L 6
- CI_SVC_RTE_STG_DWN 0
- CI_SVC_RTE_STG_DWN_K 0
- CI_SVC_TYPE 3
- CI_SVC_TYPE_L 3
- CI_SVC_TYP_DFLT 0
- CI_SYSDATA_LOG 0
- CI_TAX_EX_TYPE 0
- CI_TAX_EX_TYPE_L 0
- CI_TC 0
- CI_TC_L 0
- CI_TD_DRLKEY 7320555
- CI_TD_DRLKEY_TY 405
- CI_TD_ENTRY 7182251
- CI_TD_ENTRY_CHA 9053903
- CI_TD_ENTRY_K 7050341
- CI_TD_EX_LIST 2
- CI_TD_LOG 10940691
- CI_TD_MSG_PARM 9799603
- CI_TD_SRTKEY 18233902
- CI_TD_SRTKEY_TY 796
- CI_TD_SRTKEY_TY_L 796
- CI_TD_TYPE 381
- CI_TD_TYPE_ALG 2
- CI_TD_TYPE_CHAR 3
- CI_TD_TYPE_L 381
- CI_TD_VAL_ROLE 537
- CI_TENDER_TYPE 18
- CI_TENDER_TYPE_L 18
- CI_THRD_PTY 0
- CI_THRD_PTY_L 0
- CI_TIME_ZONE 1
- CI_TIME_ZONE_L 1
- CI_TMAP_COM_CAL 0
- CI_TMAP_COM_DAY 0
- CI_TMAP_COM_WK 0
- CI_TMAP_REL 0
- CI_TMAP_RELTY 0
- CI_TMAP_RELTY_L 0
- CI_TMAP_TMPL 0
- CI_TMAP_TMPL_L 0
- CI_TMAP_TYPE 0
- CI_TMAP_TYPE_L 0
- CI_TMAP_TYP_ALG 0
- CI_TNDR_CTL 2812
- CI_TNDR_CTL_CHAR 0
- CI_TNDR_CTL_K 2812
- CI_TNDR_CTL_ST 2143
- CI_TNDR_CTL_ST_091215 1
- CI_TNDR_CTL_ST_271015 462
- CI_TNDR_CTL_ST_BACKUP 391
- CI_TNDR_DEP 5988
- CI_TNDR_DEP_K 5988
- CI_TNDR_END_BAL 3508
- CI_TNDR_SRCE 10
- CI_TNDR_SRCE_L 10
- CI_TNDR_ST_EXCP 40
- CI_TOS 0
- CI_TOS_CAN_RSN 0
- CI_TOS_CAN_RSN_L 0
- CI_TOS_CE 0
- CI_TOS_CHAR 0
- CI_TOS_K 0
- CI_TOS_SA 0
- CI_TOS_TYPE 0
- CI_TOS_TYPE_CE 0
- CI_TOS_TYPE_L 0
- CI_TOU 5
- CI_TOU_BF_VAL 0
- CI_TOU_CONT_VAL 0
- CI_TOU_DATA 0
- CI_TOU_DATA_SET 0
- CI_TOU_DATA_SET_K 0
- CI_TOU_DS_EXC 0
- CI_TOU_DS_EXP 0
- CI_TOU_GRP 0
- CI_TOU_GRP_L 0
- CI_TOU_GRP_TOU 0
- CI_TOU_L 5
- CI_TOU_MAP 0
- CI_TOU_MAP_K 0
- CI_TOU_MAP_L 0
- CI_TREND 0
- CI_TREND_AREA 1
- CI_TREND_AREA_L 1
- CI_TREND_CL 1
- CI_TREND_CL_L 1
- CI_TRG 0
- CI_TRG_FLD 0
- CI_TST_COMP_TYP 0
- CI_TST_COMP_TYP_L 0
- CI_TST_RES_TYP 0
- CI_TST_RES_TYP_L 0
- CI_TURN_IN 0
- CI_TURN_IN_K 0
- CI_UA 0
- CI_UATY_TOSTY 0
- CI_UA_CHAR 0
- CI_UA_K 0
- CI_UA_PER 0
- CI_UA_TYPE 0
- CI_UA_TYPE_ALG 0
- CI_UA_TYPE_L 0
- CI_UI_ZONE 66
- CI_UOM 7
- CI_UOM_L 7
- CI_USR_GRP_SC 68
- CI_USR_NAV_LINK 30
- CI_USR_PORTAL 113
- CI_USR_SCR 0
- CI_USR_ZONE 315
- CI_UT_INSTL 547
- CI_UT_INSTL_DTL 1067
- CI_VAL_ERR 4359
- CI_VAL_FK_ERR 44351
- CI_VAL_SUB_SATY 0
- CI_WFM 26
- CI_WFM_L 26
- CI_WFM_MSG 0
- CI_WFM_OPT 569
- CI_WF_EVT 0
- CI_WF_EVT_CHAR 0
- CI_WF_EVT_CTXT 0
- CI_WF_EVT_DEP 0
- CI_WF_EVT_EXC 0
- CI_WF_EVT_EXP 0
- CI_WF_EVT_TYPE 0
- CI_WF_EVT_TYPE_L 0
- CI_WF_PP 0
- CI_WF_PP_L 0
- CI_WF_PP_NT 0
- CI_WF_PP_NT_CRT 0
- CI_WF_PROC 0
- CI_WF_PROC_CHAR 0
- CI_WF_PROC_CTXT 0
- CI_WF_PROC_K 0
- CI_WF_PROC_MSGP 0
- CI_WF_PROC_SCHED 0
- CI_WF_PROC_SCHED_K 0
- CI_WF_PROC_TMPL 0
- CI_WF_PROC_TMPL_L 0
- CI_WF_RESP 0
- CI_WF_RESP_DEP 0
- CI_WO_CNTL 1
- CI_WO_CNTL_L 1
- CI_WO_CRIT 4
- CI_WO_DEBT_CL 2
- CI_WO_DEBT_CL_L 2
- CI_WO_EVT 1234736
- CI_WO_EVT_CC 191604
- CI_WO_EVT_TYP 12
- CI_WO_EVT_TYP_L 13
- CI_WO_PROC 892945
- CI_WO_PROC_K 892945
- CI_WO_PROC_SA 1351733
- CI_WO_PROC_TMPL 4
- CI_WO_PROC_TMPL_L 4
- CI_WO_RESP 13
- CI_XAI_ADAPTER 10
- CI_XAI_ADAPTER_L 10
- CI_XAI_CLASS 27
- CI_XAI_CLASS_L 27
- CI_XAI_DWN 0
- CI_XAI_DWN_EXC 0
- CI_XAI_DWN_EXP 0
- CI_XAI_ENV_HNDL 6
- CI_XAI_ENV_HNDL_L 6
- CI_XAI_EXECUTER 4
- CI_XAI_EXECUTER_L 4
- CI_XAI_FORMAT 21
- CI_XAI_FORMAT_L 21
- CI_XAI_IN_SVC 199
- CI_XAI_IN_SVC_L 204
- CI_XAI_JDBC_CON 0
- CI_XAI_JDBC_CON_L 0
- CI_XAI_JMS_CON 11
- CI_XAI_JMS_CON_L 11
- CI_XAI_JMS_Q 19
- CI_XAI_JMS_Q_L 19
- CI_XAI_JMS_TPC 0
- CI_XAI_JMS_TPC_L 0
- CI_XAI_JNDI_SVR 6
- CI_XAI_JNDI_SVR_L 6
- CI_XAI_OPTION 38
- CI_XAI_RCVR 4
- CI_XAI_RCVR_CTX 0
- CI_XAI_RCVR_L 4
- CI_XAI_RCVR_RGRP 0
- CI_XAI_RCVR_RSP 4
- CI_XAI_RGRP 0
- CI_XAI_RGRP_ATT 0
- CI_XAI_RGRP_L 0
- CI_XAI_ROUTING 0
- CI_XAI_RT_TYPE 0
- CI_XAI_RT_TYPE_L 0
- CI_XAI_RULE 0
- CI_XAI_SENDER 56
- CI_XAI_SENDER_L 54
- CI_XAI_SNDR_CTX 236
- CI_XAI_SVC_PARM 0
- CI_XML_STGCTL_P 0
- CI_XML_STGUP 231668
- CI_XML_STGUPEXP 233794
- CI_XML_STGUP_EX 231666
- CI_XML_STG_CTL 231668
- CI_ZONE 1195
- CI_ZONE_HDL 17
- CI_ZONE_HDL_L 17
- CI_ZONE_HDL_PRM 1277
- CI_ZONE_HDL_PRM_L 1277
- CI_ZONE_L 1195
- CI_ZONE_PRM 190964
- CMP3$115009 47928
- CMP3$115075 53452
- CMP3$115148 26731
- CMP3$115175 36199
- CMP3$217931 81391
- CMP3$218053 27503
- CMP3$218094 32082
- CMP3$218112 59626
- CMP3$218130 5378
- CMP3$218183 43413
- CM_ACCT_STG 1071
- CM_APAY_CLR_STG_BACK 562
- CM_APAY_CLR_STG_K_BACK 562
- CM_BILL_EXCP_BACKUP 774
- CM_BILL_ROUTING 22081
- CM_BSEG_BACKUP_PENDING 774
- CM_CASE_CHAR_28SEP15 5379
- CM_COLL_PROC_SA_TMP 22562
- CM_CUST_TIL 8907978
- CM_CUST_TIL_K 9014754
- CM_DD_FILE 643771
- CM_DD_FILE_CHAR 0
- CM_DD_FILE_K 643771
- CM_DD_FILE_LOG 1758190
- CM_DD_FILE_LOG_PARM 1818767
- CM_DEP_CTL_ST_28SEP15 1
- CM_DEP_CTL_ST_F0979098 9
- CM_DEP_CTL_ST_F0979098_2 3
- CM_FT_BACKUP_COMPLETED 860
- CM_JUL_END_BILL_CYC_TMP 12890
- CM_LOSS_BILLS 16746
- CM_LOSS_FLW_ACCTS 24311
- CM_LOSS_FLW_AC_BILL_CYC_TMP 11600
- CM_MAR_END_BILL_CYC_TMP 10050
- CM_MAY_END_BILL_CYC_TMP 5561
- CM_MOVED_SA 0
- CM_NB_SCHED_PAY 28501
- CM_NB_SCHED_PAY_BACK 29458
- CM_NB_SCHED_PAY_LOG 556
- CM_NB_SCHED_PAY_LOG_BACK 127
- CM_PAY_BACK 562
- CM_PAY_EVT_BACK 562
- CM_PAY_EVT_K_BACK 562
- CM_PAY_EVT_ROLLBACK 0
- CM_PAY_K_BACK 562
- CM_PAY_TNDR_BACK 562
- CM_PAY_TNDR_K_BACK 562
- CM_PAY_TNDR_ST_28SEP15 487
- CM_PAY_TNDR_ST_F0979098 1325
- CM_PAY_TNDR_ST_F0979098_2 679
- CM_PROD_TIL 467
- CM_PROD_TIL_CHAR 1371
- CM_PROD_TIL_DETAILS 10480
- CM_PROD_TIL_DETAILS_291015 4676
- CM_PROD_TIL_DETAILS_K 10726
- CM_PROD_TIL_DETAILS_K_291015 4907
- CM_PROD_TIL_K 457
- CM_PROD_TIL_LOG 3961
- CM_PROD_TIL_LOG_291015 1853
- CM_PROD_TIL_LOG_PARM 4428
- CM_PROD_TIL_LOG_PARM_291015 2345
- CM_RESEND_OUTMSG 540
- CM_RESET_NBB_RENEW_EXPIRE_DATE 2483
- CM_SP_MTR_HIST_16102015 3
- CM_SYNC_ID 370000
- CM_TMP_ACCT_BALANCES 597780
- CM_TMP_ACCT_ISSUES 124498
- CM_TMP_ACCT_NOT_BILLABLE_IT15 22560
- CM_TMP_CRM_CCB_BALANCE 241932
- CM_TMP_CRM_CCB_BALANCE_2 241943
- CM_TMP_PSEG_NOSA 738
- CM_TMP_REMOVED_NB_SA 220507
- CM_TMP_UNASSIGNED_AD 0
- CM_TMP_UNBAL_AMI_FINDINGS 5039
- CM_TMP_UNDISTRIBUTED_PS 0
- CM_TMP_VAL_ERR 48898
- CM_TNDR_CTL_ST_28SEP15 1
- CM_TNDR_CTL_ST_F0979098 9
- CM_TNDR_CTL_ST_F0979098_2 3
- CRM_COLLECTIONS 0
- DATA_CLEANSE_CRM 1553
- DATA_CLEANSE_ZOMG 1366
- DUP_SP_ACCT 2157
- DUP_SP_ACCTS 0
- F1_ATTACHMENT 85828
- F1_ATTACHMENT_CHAR 282712
- F1_BKT_CONFIG 11
- F1_BKT_CONFIG_L 11
- F1_BKT_CONFIG_REL_OBJ 0
- F1_BKT_CONFIG_VAL 45
- F1_BKT_CONFIG_VAL_L 45
- F1_BNDL 3
- F1_BNDL_CHAR 0
- F1_BNDL_ENTITY 21
- F1_BNDL_K 3
- F1_BNDL_LOG 6
- F1_BNDL_LOG_PARM 6
- F1_BUS_EVT_LOG 0
- F1_BUS_EVT_LOG_CHAR 0
- F1_BUS_EVT_LOG_K 0
- F1_BUS_EVT_LOG_MSG_PARM 0
- F1_BUS_OBJ 906
- F1_BUS_OBJ_ALG 216
- F1_BUS_OBJ_L 906
- F1_BUS_OBJ_OPT 746
- F1_BUS_OBJ_STATUS 566
- F1_BUS_OBJ_STATUS_ALG 632
- F1_BUS_OBJ_STATUS_L 566
- F1_BUS_OBJ_STATUS_OPT 168
- F1_BUS_OBJ_STATUS_RSN 10
- F1_BUS_OBJ_STATUS_RSN_CHAR 2
- F1_BUS_OBJ_STATUS_RSN_L 10
- F1_BUS_OBJ_TR_RULE 857
- F1_BUS_OBJ_TR_RULE_L 871
- F1_BUS_SVC 1010
- F1_BUS_SVC_L 1009
- F1_DATA_AREA 545
- F1_DATA_AREA_L 545
- F1_DB_OBJECTS_REPO 3954
- F1_EXTSYS_OUTMSG_PROF 51
- F1_EXT_LOOKUP_VAL 1471
- F1_EXT_LOOKUP_VAL_L 1472
- F1_FACT 949980
- F1_FACT_CHAR 5674922
- F1_FACT_K 949817
- F1_FACT_LOG 13704165
- F1_FACT_LOG_PARM 17002307
- F1_GENERIC_GTT
- F1_GEN_PROC 0
- F1_GEN_PROC_K 0
- F1_GNRL_AUDIT 0
- F1_GNRL_AUDIT_CHAR 0
- F1_GNRL_AUDIT_K 0
- F1_GNRL_AUDIT_VAL 0
- F1_INSTALLATION 1
- F1_IWS_ANN 1
- F1_IWS_ANN_CHAR 0
- F1_IWS_ANN_L 1
- F1_IWS_ANN_PARM 2
- F1_IWS_ANN_TYPE 1
- F1_IWS_ANN_TYPE_CHAR 0
- F1_IWS_ANN_TYPE_L 1
- F1_IWS_ANN_TYPE_PARM 2
- F1_IWS_ANN_TYPE_PARM_L 2
- F1_IWS_SVC 5
- F1_IWS_SVC_ANN 0
- F1_IWS_SVC_CHAR 0
- F1_IWS_SVC_L 5
- F1_IWS_SVC_LOG 0
- F1_IWS_SVC_LOG_PARM 0
- F1_IWS_SVC_OPER 5
- F1_IWS_SVC_OPER_L 0
- F1_KEY_HASH 0
- F1_MANAG_CONTENT 15
- F1_MANAG_CONTENT_L 15
- F1_MAP 724
- F1_MAP_L 723
- F1_MAP_OVRD 0
- F1_MD_DB_OBJ 6
- F1_MIGR_DATA_ST 260
- F1_MIGR_DATA_ST_ALG 0
- F1_MIGR_DATA_ST_K 237
- F1_MIGR_DATA_ST_LOG 1480
- F1_MIGR_DATA_ST_LOG_PARM 1334
- F1_MIGR_DATA_ST_TBL 0
- F1_MIGR_OBJ 320650
- F1_MIGR_OBJ_ALG 295
- F1_MIGR_OBJ_CLOB 2350
- F1_MIGR_OBJ_K 318237
- F1_MIGR_OBJ_LOG 334382
- F1_MIGR_OBJ_LOG_PARM 333635
- F1_MIGR_OBJ_SQL 35576
- F1_MIGR_PLAN 231
- F1_MIGR_PLAN_INSTR 545
- F1_MIGR_PLAN_INSTR_ALG 1
- F1_MIGR_PLAN_INSTR_L 544
- F1_MIGR_PLAN_L 233
- F1_MIGR_REQ 25
- F1_MIGR_REQ_INSTR 437
- F1_MIGR_REQ_INSTR_ENTITY 6
- F1_MIGR_REQ_INSTR_L 437
- F1_MIGR_REQ_L 24
- F1_MIGR_TRANS 19142
- F1_MIGR_TRANS_K 17521
- F1_MIGR_TRANS_LOG 16
- F1_MIGR_TRANS_LOG_PARM 0
- F1_MST_CONFIG 5
- F1_OBJ_REV 0
- F1_OBJ_REV_CHAR 0
- F1_OBJ_REV_LOG 0
- F1_OBJ_REV_LOG_PARM 0
- F1_OUTMSG 13359768
- F1_OUTMSG_ERRPARM 1994045
- F1_OUTMSG_K 13147326
- F1_OUTMSG_TYPE 43
- F1_OUTMSG_TYPE_L 43
- F1_REQ 0
- F1_REQ_CHAR 0
- F1_REQ_K 0
- F1_REQ_LOG 0
- F1_REQ_LOG_PARM 0
- F1_REQ_TYPE 0
- F1_REQ_TYPE_L 0
- F1_REQ_TYPE_LOG 0
- F1_REQ_TYPE_LOG_PARM 0
- F1_SCHEMA 4226
- F1_SVC_TASK 2499086
- F1_SVC_TASK_CHAR 5417377
- F1_SVC_TASK_K 2438188
- F1_SVC_TASK_LOG 10400727
- F1_SVC_TASK_LOG_PARM 9146684
- F1_SVC_TASK_REL_OBJ 4553866
- F1_SVC_TASK_TYPE 23
- F1_SVC_TASK_TYPE_CHAR 8
- F1_SVC_TASK_TYPE_L 23
- F1_SYNC_REQ 29307741
- F1_SYNC_REQ_CHAR 0
- F1_SYNC_REQ_EXTRACT 0
- F1_SYNC_REQ_IN 0
- F1_SYNC_REQ_IN_CHAR 0
- F1_SYNC_REQ_IN_EXCP 0
- F1_SYNC_REQ_IN_EXCP_PARM 0
- F1_SYNC_REQ_IN_K 0
- F1_SYNC_REQ_IN_LOG 0
- F1_SYNC_REQ_IN_LOG_PARM 0
- F1_SYNC_REQ_IN_REL_OBJ 0
- F1_SYNC_REQ_K 32288859
- F1_SYNC_REQ_LOG 128127323
- F1_SYNC_REQ_LOG_PARM 100495681
- F1_TSPACE_ENTRY 5712
- F1_WEB_SVC 0
- F1_WEB_SVC_CHAR 0
- F1_WEB_SVC_GTT
- F1_WEB_SVC_L 0
- F1_WEB_SVC_LOG 0
- F1_WEB_SVC_LOG_PARM 0
- F1_WEB_SVC_OPERATIONS 0
- FACT_TEST 137296
- FI_TEST 3803212
- GTT_CLBDSYNC
- JAM_FT_BAL_OLD_ACCT_GOLIVE_STG 215850
- JAM_FT_OLD_ACCT_GOLIVE_STG 10290107
- JP_WO_ACCTS 0
- JP_WO_EXC_NULL_ARSDT 0
- JP_WO_INC_NULL_ARSDT 0
- NON_DD_CUSTS 2045
- NON_DD_CUSTS_MAR 2034
- REWRITE_TABLE 0
- SC_ACCESS_CNTL 10550
- SC_APP_SERVICE 679
- SC_APP_SERVICE_L 679
- SC_USER 2044
- SC_USER_CHAR 1
- SC_USER_GROUP 36
- SC_USER_GROUP_L 35
- SC_USR_GRP_PROF 4432
- SC_USR_GRP_USR 8498
- TMP_DOCUMAKER_BILL_REGRESSION 118
- TMP_DOCUMAKER_REGRESSION 13
- TMP_GS 294085
- TMP_GS1 1
- TMP_STATEMENT_TD 48225
- TM_BSEG_SQ_FIX 2233964
- TM_BSEG_SQ_OLD 4904484
- TM_FIX_SA_NBB 66933
- TM_SCHED_PAY_MAR_03 9059
- UN_BAL_ACCT 13273
- UN_BAL_ACCT_CRM 13273
- XX_ACCT_BILL_CYC 5193
- XX_NBB_SCHED 85367
- XX_NBB_SCHED_251115_05 78201
- XX_NBB_SCHED_251115_15 53697
- XX_NBB_SCHED_261115 78201
- XX_NBB_SCHED_261115_15 53697
- XX_NB_SCHED_PAY 1028537
- XX_NB_SCHED_PAY_K 1029400
- 1604 rows selected.
- SQL> l
- 1* select TABLE_NAME,NUM_ROWS from user_tables order by TABLE_NAME
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> select instance_name form v$instance;
- select instance_name form v$instance
- *
- ERROR at line 1:
- ORA-00923: FROM keyword not found where expected
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> select instance_name from v$instance;
- INSTANCE_NAME
- ----------------
- SIT3
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> desc mdmadm.D1_CONS_EXT_TYPE
- Name Null? Type
- ----------------------------------------- -------- ----------------------------
- CONS_EXT_TYPE_CD NOT NULL VARCHAR2(30)
- BUS_OBJ_CD NOT NULL CHAR(30)
- D1_CONS_EXT_TYPE_STAT_FLG NOT NULL CHAR(4)
- D1_UOM_CD VARCHAR2(30)
- D1_TOU_MAP_ID CHAR(12)
- SEC_PER_INTRVL NUMBER(5)
- EXT_THROUGH_DTTM DATE
- EXT_CUTOFF_TM NOT NULL DATE
- D1_CONS_EXT_TYPE_FREQ_FLG CHAR(4)
- INITIAL_LOAD_BATCH_CTRL_CD NOT NULL CHAR(8)
- HIST_CORR_BATCH_CTRL_CD NOT NULL CHAR(8)
- REQ_TYPE_CD VARCHAR2(30)
- SUBSCRIPTION_TYPE_FLG NOT NULL CHAR(4)
- VERSION NOT NULL NUMBER(5)
- BO_DATA_AREA CLOB
- TOU_MAP_TMPLT_CD VARCHAR2(30)
- D1_CONS_RET_METHOD_FLG NOT NULL CHAR(4)
- D1_MULT_COND_RES_MODE_FLG CHAR(4)
- MSRMT_COND_FLG CHAR(6)
- SQL> select count(*) from mdmadm.D1_CONS_EXT_TYPE;
- COUNT(*)
- ----------
- 0
- SQL> set lines 260 pages 99
- SQL>
- SQL> col Table_Name format a18
- SQL> col Index_Name format a18
- SQL> col Col_Name format a35
- SQL>
- SQL> break on table_name skip 1
- SQL>
- SQL> select c.instance_name,
- 2 a.TABLE_NAME "Table_Name",
- 3 a.INDEX_NAME "Index_Name",
- 4 a.COLUMN_NAME "Col_Name",
- 5 a.COLUMN_POSITION "Col_Position",
- 6 to_char(b.created, 'DD-MON-YYYY HH24:MI') "Created_Date",
- 7 b.object_type "Object_type"
- 8 from dba_ind_columns a, dba_objects b, v$instance c
- 9 where a.TABLE_OWNER='MDMADM'
- 10 and a.TABLE_NAME in ('D1_CONS_EXT_TYPE')
- 11 and a.index_name=b.object_name
- 12 order by a.table_name,a.index_name,a.column_position
- 13 /
- INSTANCE_NAME Table_Name Index_Name Col_Name Col_Position Created_Date Object_type
- ---------------- ------------------ ------------------ ----------------------------------- ------------ -------------------------- -------------------
- SIT3 D1_CONS_EXT_TYPE D1C410P0 CONS_EXT_TYPE_CD 1 08-MAR-2018 14:41 INDEX
- SIT3 D1C410S0 INITIAL_LOAD_BATCH_CTRL_CD 1 08-MAR-2018 14:41 INDEX
- SIT3 D1C410S1 HIST_CORR_BATCH_CTRL_CD 1 08-MAR-2018 14:41 INDEX
-
- SQL>
- SQL> desc dba_indexes
- Name Null? Type
- ----------------------------------------------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------------------------------
- OWNER NOT NULL VARCHAR2(30)
- INDEX_NAME NOT NULL VARCHAR2(30)
- INDEX_TYPE VARCHAR2(27)
- TABLE_OWNER NOT NULL VARCHAR2(30)
- TABLE_NAME NOT NULL VARCHAR2(30)
- TABLE_TYPE VARCHAR2(11)
- UNIQUENESS VARCHAR2(9)
- COMPRESSION VARCHAR2(8)
- PREFIX_LENGTH NUMBER
- TABLESPACE_NAME VARCHAR2(30)
- INI_TRANS NUMBER
- MAX_TRANS NUMBER
- INITIAL_EXTENT NUMBER
- NEXT_EXTENT NUMBER
- MIN_EXTENTS NUMBER
- MAX_EXTENTS NUMBER
- PCT_INCREASE NUMBER
- PCT_THRESHOLD NUMBER
- INCLUDE_COLUMN NUMBER
- FREELISTS NUMBER
- FREELIST_GROUPS NUMBER
- PCT_FREE NUMBER
- LOGGING VARCHAR2(3)
- BLEVEL NUMBER
- LEAF_BLOCKS NUMBER
- DISTINCT_KEYS NUMBER
- AVG_LEAF_BLOCKS_PER_KEY NUMBER
- AVG_DATA_BLOCKS_PER_KEY NUMBER
- CLUSTERING_FACTOR NUMBER
- STATUS VARCHAR2(8)
- NUM_ROWS NUMBER
- SAMPLE_SIZE NUMBER
- LAST_ANALYZED DATE
- DEGREE VARCHAR2(40)
- INSTANCES VARCHAR2(40)
- PARTITIONED VARCHAR2(3)
- TEMPORARY VARCHAR2(1)
- GENERATED VARCHAR2(1)
- SECONDARY VARCHAR2(1)
- BUFFER_POOL VARCHAR2(7)
- FLASH_CACHE VARCHAR2(7)
- CELL_FLASH_CACHE VARCHAR2(7)
- USER_STATS VARCHAR2(3)
- DURATION VARCHAR2(15)
- PCT_DIRECT_ACCESS NUMBER
- ITYP_OWNER VARCHAR2(30)
- ITYP_NAME VARCHAR2(30)
- PARAMETERS VARCHAR2(1000)
- GLOBAL_STATS VARCHAR2(3)
- DOMIDX_STATUS VARCHAR2(12)
- DOMIDX_OPSTATUS VARCHAR2(6)
- FUNCIDX_STATUS VARCHAR2(8)
- JOIN_INDEX VARCHAR2(3)
- IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
- DROPPED VARCHAR2(3)
- VISIBILITY VARCHAR2(9)
- DOMIDX_MANAGEMENT VARCHAR2(14)
- SEGMENT_CREATED VARCHAR2(3)
- SQL> set lines 99
- SQL> desc dba_indexes ;
- Name Null? Type
- ---------------------------------------------------- -------- ------------------------------------
- OWNER NOT NULL VARCHAR2(30)
- INDEX_NAME NOT NULL VARCHAR2(30)
- INDEX_TYPE VARCHAR2(27)
- TABLE_OWNER NOT NULL VARCHAR2(30)
- TABLE_NAME NOT NULL VARCHAR2(30)
- TABLE_TYPE VARCHAR2(11)
- UNIQUENESS VARCHAR2(9)
- COMPRESSION VARCHAR2(8)
- PREFIX_LENGTH NUMBER
- TABLESPACE_NAME VARCHAR2(30)
- INI_TRANS NUMBER
- MAX_TRANS NUMBER
- INITIAL_EXTENT NUMBER
- NEXT_EXTENT NUMBER
- MIN_EXTENTS NUMBER
- MAX_EXTENTS NUMBER
- PCT_INCREASE NUMBER
- PCT_THRESHOLD NUMBER
- INCLUDE_COLUMN NUMBER
- FREELISTS NUMBER
- FREELIST_GROUPS NUMBER
- PCT_FREE NUMBER
- LOGGING VARCHAR2(3)
- BLEVEL NUMBER
- LEAF_BLOCKS NUMBER
- DISTINCT_KEYS NUMBER
- AVG_LEAF_BLOCKS_PER_KEY NUMBER
- AVG_DATA_BLOCKS_PER_KEY NUMBER
- CLUSTERING_FACTOR NUMBER
- STATUS VARCHAR2(8)
- NUM_ROWS NUMBER
- SAMPLE_SIZE NUMBER
- LAST_ANALYZED DATE
- DEGREE VARCHAR2(40)
- INSTANCES VARCHAR2(40)
- PARTITIONED VARCHAR2(3)
- TEMPORARY VARCHAR2(1)
- GENERATED VARCHAR2(1)
- SECONDARY VARCHAR2(1)
- BUFFER_POOL VARCHAR2(7)
- FLASH_CACHE VARCHAR2(7)
- CELL_FLASH_CACHE VARCHAR2(7)
- USER_STATS VARCHAR2(3)
- DURATION VARCHAR2(15)
- PCT_DIRECT_ACCESS NUMBER
- ITYP_OWNER VARCHAR2(30)
- ITYP_NAME VARCHAR2(30)
- PARAMETERS VARCHAR2(1000)
- GLOBAL_STATS VARCHAR2(3)
- DOMIDX_STATUS VARCHAR2(12)
- DOMIDX_OPSTATUS VARCHAR2(6)
- FUNCIDX_STATUS VARCHAR2(8)
- JOIN_INDEX VARCHAR2(3)
- IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
- DROPPED VARCHAR2(3)
- VISIBILITY VARCHAR2(9)
- DOMIDX_MANAGEMENT VARCHAR2(14)
- SEGMENT_CREATED VARCHAR2(3)
- SQL> desc dba_constraints
- Name Null? Type
- ---------------------------------------------------- -------- ------------------------------------
- OWNER VARCHAR2(120)
- CONSTRAINT_NAME NOT NULL VARCHAR2(30)
- CONSTRAINT_TYPE VARCHAR2(1)
- TABLE_NAME NOT NULL VARCHAR2(30)
- SEARCH_CONDITION LONG
- R_OWNER VARCHAR2(120)
- R_CONSTRAINT_NAME VARCHAR2(30)
- DELETE_RULE VARCHAR2(9)
- STATUS VARCHAR2(8)
- DEFERRABLE VARCHAR2(14)
- DEFERRED VARCHAR2(9)
- VALIDATED VARCHAR2(13)
- GENERATED VARCHAR2(14)
- BAD VARCHAR2(3)
- RELY VARCHAR2(4)
- LAST_CHANGE DATE
- INDEX_OWNER VARCHAR2(30)
- INDEX_NAME VARCHAR2(30)
- INVALID VARCHAR2(7)
- VIEW_RELATED VARCHAR2(14)
- SQL> select * from dba_constraints where CONSTRAINT_NAME='D1C410P0';
- no rows selected
- SQL> desc dba_indexes
- Name Null? Type
- ---------------------------------------------------- -------- ------------------------------------
- OWNER NOT NULL VARCHAR2(30)
- INDEX_NAME NOT NULL VARCHAR2(30)
- INDEX_TYPE VARCHAR2(27)
- TABLE_OWNER NOT NULL VARCHAR2(30)
- TABLE_NAME NOT NULL VARCHAR2(30)
- TABLE_TYPE VARCHAR2(11)
- UNIQUENESS VARCHAR2(9)
- COMPRESSION VARCHAR2(8)
- PREFIX_LENGTH NUMBER
- TABLESPACE_NAME VARCHAR2(30)
- INI_TRANS NUMBER
- MAX_TRANS NUMBER
- INITIAL_EXTENT NUMBER
- NEXT_EXTENT NUMBER
- MIN_EXTENTS NUMBER
- MAX_EXTENTS NUMBER
- PCT_INCREASE NUMBER
- PCT_THRESHOLD NUMBER
- INCLUDE_COLUMN NUMBER
- FREELISTS NUMBER
- FREELIST_GROUPS NUMBER
- PCT_FREE NUMBER
- LOGGING VARCHAR2(3)
- BLEVEL NUMBER
- LEAF_BLOCKS NUMBER
- DISTINCT_KEYS NUMBER
- AVG_LEAF_BLOCKS_PER_KEY NUMBER
- AVG_DATA_BLOCKS_PER_KEY NUMBER
- CLUSTERING_FACTOR NUMBER
- STATUS VARCHAR2(8)
- NUM_ROWS NUMBER
- SAMPLE_SIZE NUMBER
- LAST_ANALYZED DATE
- DEGREE VARCHAR2(40)
- INSTANCES VARCHAR2(40)
- PARTITIONED VARCHAR2(3)
- TEMPORARY VARCHAR2(1)
- GENERATED VARCHAR2(1)
- SECONDARY VARCHAR2(1)
- BUFFER_POOL VARCHAR2(7)
- FLASH_CACHE VARCHAR2(7)
- CELL_FLASH_CACHE VARCHAR2(7)
- USER_STATS VARCHAR2(3)
- DURATION VARCHAR2(15)
- PCT_DIRECT_ACCESS NUMBER
- ITYP_OWNER VARCHAR2(30)
- ITYP_NAME VARCHAR2(30)
- PARAMETERS VARCHAR2(1000)
- GLOBAL_STATS VARCHAR2(3)
- DOMIDX_STATUS VARCHAR2(12)
- DOMIDX_OPSTATUS VARCHAR2(6)
- FUNCIDX_STATUS VARCHAR2(8)
- JOIN_INDEX VARCHAR2(3)
- IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
- DROPPED VARCHAR2(3)
- VISIBILITY VARCHAR2(9)
- DOMIDX_MANAGEMENT VARCHAR2(14)
- SEGMENT_CREATED VARCHAR2(3)
- SQL> select * from dba_indexes where index_name='D1C410P0';
- OWNER INDEX_NAME INDEX_TYPE
- ------------------------------ ------------------ ---------------------------
- TABLE_OWNER TABLE_NAME TABLE_TYPE UNIQUENES COMPRESS PREFIX_LENGTH
- ------------------------------ ------------------ ----------- --------- -------- -------------
- TABLESPACE_NAME INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
- ------------------------------ ---------- ---------- -------------- ----------- -----------
- MAX_EXTENTS PCT_INCREASE PCT_THRESHOLD INCLUDE_COLUMN FREELISTS FREELIST_GROUPS PCT_FREE LOG
- ----------- ------------ ------------- -------------- ---------- --------------- ---------- ---
- BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY
- ---------- ----------- ------------- ----------------------- -----------------------
- CLUSTERING_FACTOR STATUS NUM_ROWS SAMPLE_SIZE LAST_ANAL
- ----------------- -------- ---------- ----------- ---------
- DEGREE INSTANCES PAR T G S BUFFER_
- ---------------------------------------- ---------------------------------------- --- - - - -------
- FLASH_C CELL_FL USE DURATION PCT_DIRECT_ACCESS ITYP_OWNER
- ------- ------- --- --------------- ----------------- ------------------------------
- ITYP_NAME
- ------------------------------
- PARAMETERS
- ---------------------------------------------------------------------------------------------------
- GLO DOMIDX_STATU DOMIDX FUNCIDX_ JOI IOT DRO VISIBILIT DOMIDX_MANAGEM SEG
- --- ------------ ------ -------- --- --- --- --------- -------------- ---
- MDMADM D1C410P0 NORMAL
- MDMADM D1_CONS_EXT_TYPE TABLE UNIQUE DISABLED
- MDMIS_01 2 255
- 10 YES
- 0 0 0 0 0
- 0 VALID 0 0 08-MAR-18
- 1 1 NO N N N DEFAULT
- DEFAULT DEFAULT NO
-
-
- YES NO NO NO VISIBLE NO
-
-
- SQL> desc dba_indexes
- Name Null? Type
- ---------------------------------------------------- -------- ------------------------------------
- OWNER NOT NULL VARCHAR2(30)
- INDEX_NAME NOT NULL VARCHAR2(30)
- INDEX_TYPE VARCHAR2(27)
- TABLE_OWNER NOT NULL VARCHAR2(30)
- TABLE_NAME NOT NULL VARCHAR2(30)
- TABLE_TYPE VARCHAR2(11)
- UNIQUENESS VARCHAR2(9)
- COMPRESSION VARCHAR2(8)
- PREFIX_LENGTH NUMBER
- TABLESPACE_NAME VARCHAR2(30)
- INI_TRANS NUMBER
- MAX_TRANS NUMBER
- INITIAL_EXTENT NUMBER
- NEXT_EXTENT NUMBER
- MIN_EXTENTS NUMBER
- MAX_EXTENTS NUMBER
- PCT_INCREASE NUMBER
- PCT_THRESHOLD NUMBER
- INCLUDE_COLUMN NUMBER
- FREELISTS NUMBER
- FREELIST_GROUPS NUMBER
- PCT_FREE NUMBER
- LOGGING VARCHAR2(3)
- BLEVEL NUMBER
- LEAF_BLOCKS NUMBER
- DISTINCT_KEYS NUMBER
- AVG_LEAF_BLOCKS_PER_KEY NUMBER
- AVG_DATA_BLOCKS_PER_KEY NUMBER
- CLUSTERING_FACTOR NUMBER
- STATUS VARCHAR2(8)
- NUM_ROWS NUMBER
- SAMPLE_SIZE NUMBER
- LAST_ANALYZED DATE
- DEGREE VARCHAR2(40)
- INSTANCES VARCHAR2(40)
- PARTITIONED VARCHAR2(3)
- TEMPORARY VARCHAR2(1)
- GENERATED VARCHAR2(1)
- SECONDARY VARCHAR2(1)
- BUFFER_POOL VARCHAR2(7)
- FLASH_CACHE VARCHAR2(7)
- CELL_FLASH_CACHE VARCHAR2(7)
- USER_STATS VARCHAR2(3)
- DURATION VARCHAR2(15)
- PCT_DIRECT_ACCESS NUMBER
- ITYP_OWNER VARCHAR2(30)
- ITYP_NAME VARCHAR2(30)
- PARAMETERS VARCHAR2(1000)
- GLOBAL_STATS VARCHAR2(3)
- DOMIDX_STATUS VARCHAR2(12)
- DOMIDX_OPSTATUS VARCHAR2(6)
- FUNCIDX_STATUS VARCHAR2(8)
- JOIN_INDEX VARCHAR2(3)
- IOT_REDUNDANT_PKEY_ELIM VARCHAR2(3)
- DROPPED VARCHAR2(3)
- VISIBILITY VARCHAR2(9)
- DOMIDX_MANAGEMENT VARCHAR2(14)
- SEGMENT_CREATED VARCHAR2(3)
- SQL> select OWNER,INDEX_NAME,INDEX_TYPE,TABLE_NAME,UNIQUENESS,STATUS from dba_indexes where INDEX_NAME='D1C410P0';
- OWNER INDEX_NAME INDEX_TYPE TABLE_NAME
- ------------------------------ ------------------ --------------------------- ------------------
- UNIQUENES STATUS
- --------- --------
- MDMADM D1C410P0 NORMAL D1_CONS_EXT_TYPE
- UNIQUE VALID
-
-
- SQL> set lines 999
- SQL> /
- OWNER INDEX_NAME INDEX_TYPE TABLE_NAME UNIQUENES STATUS
- ------------------------------ ------------------ --------------------------- ------------------ --------- --------
- MDMADM D1C410P0 NORMAL D1_CONS_EXT_TYPE UNIQUE VALID
-
- SQL> select count(*) from MDMADM.D1_CONS_EXT_TYPE;
- COUNT(*)
- ----------
- 0
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> set timing on
- SQL> set trimspool off
- SQL> set linesize 32000
- SQL> set long 20000000
- SQL> set pagesize 0
- SQL> column ddl format a50000
- SQL> set longchunksize 20000000
- SQL> select dbms_metadata.get_ddl('INDEX','D1_CONS_EXT_TYPE','MDMADM') from dual
- 2 /
- ERROR:
- ORA-31603: object "D1_CONS_EXT_TYPE" of type INDEX not found in schema "MDMADM"
- ORA-06512: at "SYS.DBMS_METADATA", line 5805
- ORA-06512: at "SYS.DBMS_METADATA", line 8344
- ORA-06512: at line 1
- no rows selected
- Elapsed: 00:00:00.67
- SQL>
- SQL>
- SQL> D1_CONS_EXT_TYPE
- SP2-0734: unknown command beginning "D1_CONS_EX..." - rest of line ignored.
- SQL>
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> set lines 260 pages 99
- SQL>
- SQL> col Table_Name format a18
- SQL> col Index_Name format a18
- SQL> col Col_Name format a35
- SQL>
- SQL> break on table_name skip 1
- SQL>
- SQL> select c.instance_name,
- 2 a.TABLE_NAME "Table_Name",
- 3 a.INDEX_NAME "Index_Name",
- 4 a.COLUMN_NAME "Col_Name",
- 5 a.COLUMN_POSITION "Col_Position",
- 6 to_char(b.created, 'DD-MON-YYYY HH24:MI') "Created_Date",
- 7 b.object_type "Object_type"
- 8 from dba_ind_columns a, dba_objects b, v$instance c
- 9 where a.TABLE_OWNER='MDMADM'
- 10 and a.TABLE_NAME in ('D1C410P0')
- 11 and a.index_name=b.object_name
- 12 order by a.table_name,a.index_name,a.column_position
- 13 /
- no rows selected
- Elapsed: 00:00:00.07
- SQL>
- SQL>
- SQL>
- SQL>
- SQL> set timing on
- SQL> set trimspool off
- SQL> set linesize 32000
- SQL> set long 20000000
- SQL> set pagesize 0
- SQL> column ddl format a50000
- SQL> set longchunksize 20000000
- SQL> select dbms_metadata.get_ddl('INDEX','D1C410P0','MDMADM') from dual
- 2 /
-
- CREATE UNIQUE INDEX "MDMADM"."D1C410P0" ON "MDMADM"."D1_CONS_EXT_TYPE" ("CONS_EXT_TYPE_CD")
- PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- TABLESPACE "MDMIS_01"
-
- Elapsed: 00:00:00.24
- SQL>
- SQL>
- SQL>
- SQL> !
- SQL>
|
