EXPORT:V11.02.00 DSYSTEM RTABLES 2048 0 64 0  Thu Mar 3 19:11:18 2011EXPDAT.DMPd`$     #G###A#d`$     #G###A#+00:00BYTEUNUSED2 INTERPRETED DISABLE:ALL METRICST CONNECT SYS TABLE "USER$" CREATE TABLE "USER$" ("USER#" NUMBER NOT NULL ENABLE, "NAME" VARCHAR2(30) NOT NULL ENABLE, "TYPE#" NUMBER NOT NULL ENABLE, "PASSWORD" VARCHAR2(30), "DATATS#" NUMBER NOT NULL ENABLE, "TEMPTS#" NUMBER NOT NULL ENABLE, "CTIME" DATE NOT NULL ENABLE, "PTIME" DATE, "EXPTIME" DATE, "LTIME" DATE, "RESOURCE$" NUMBER NOT NULL ENABLE, "AUDIT$" VARCHAR2(38), "DEFROLE" NUMBER NOT NULL ENABLE, "DEFGRP#" NUMBER, "DEFGRP_SEQ#" NUMBER, "ASTATUS" NUMBER NOT NULL ENABLE, "LCOUNT" NUMBER NOT NULL ENABLE, "DEFSCHCLASS" VARCHAR2(30), "EXT_USERNAME" VARCHAR2(4000), "SPARE1" NUMBER, "SPARE2" NUMBER, "SPARE3" NUMBER, "SPARE4" VARCHAR2(1000), "SPARE5" VARCHAR2(1000), "SPARE6" DATE) STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING NOCOMPRESS ALTER TABLE "USER$" MODIFY DEFAULT 1ALTER TABLE "USER$" MODIFY ("ASTATUS" DEFAULT 0 ) ALTER TABLE "USER$" MODIFY DEFAULT 0ALTER TABLE "USER$" MODIFY ("LCOUNT" DEFAULT 0 ) INSERT INTO "USER$" ("USER#", "NAME", "TYPE#", "PASSWORD", "DATATS#", "TEMPTS#", "CTIME", "PTIME", "EXPTIME", "LTIME", "RESOURCE$", "AUDIT$", "DEFROLE", "DEFGRP#", "DEFGRP_SEQ#", "ASTATUS", "LCOUNT", "DEFSCHCLASS", "EXT_USERNAME", "SPARE1", "SPARE2", "SPARE3", "SPARE4", "SPARE5", "SPARE6") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25)     & SYS057742A58276827Exn,xo9"xnxnDEFAULT_CONSUMER_GROUP>S:1F7C9384AF8F0B497E0EAB09A0141D96012DC5FC5227DA6CEF7AEB0D423FPUBLICxn,DEFAULT_CONSUMER_GROUPCONNECTxn,DEFAULT_CONSUMER_GROUPRESOURCExn,DEFAULT_CONSUMER_GROUPDBAxn,DEFAULT_CONSUMER_GROUPSYSTEM1089A2DF2B0C76AAxn,xoxnxnDEFAULT_CONSUMER_GROUP>S:26D848B7ED72F141CF31DDD137DD70C4839FEA45A78230C3977D6895936FSELECT_CATALOG_ROLExn,DEFAULT_CONSUMER_GROUPEXECUTE_CATALOG_ROLExn,DEFAULT_CONSUMER_GROUP DELETE_CATALOG_ROLExn,DEFAULT_CONSUMER_GROUP OUTLN4A3BA55E08595C81xn.xn.xn"xn" DEFAULT_CONSUMER_GROUP>S:F285F171FAB253B97A735DC4F1A446206DA91706093E2542675E9C302B3D EXP_FULL_DATABASExn1DEFAULT_CONSUMER_GROUP IMP_FULL_DATABASExn1DEFAULT_CONSUMER_GROUP LOGSTDBY_ADMINISTRATORxn DEFAULT_CONSUMER_GROUP DBFS_ROLExn DEFAULT_CONSUMER_GROUPDIPCE4A36B8E06CA59Cxnxnxnxn DEFAULT_CONSUMER_GROUP>S:51C0606CD08192EF543678519467E3320A44603F68E04BF2D6C97B881FA7AQ_ADMINISTRATOR_ROLExnDEFAULT_CONSUMER_GROUP AQ_USER_ROLExnDEFAULT_CONSUMER_GROUPDATAPUMP_EXP_FULL_DATABASExn!DEFAULT_CONSUMER_GROUPDATAPUMP_IMP_FULL_DATABASExn!DEFAULT_CONSUMER_GROUPADM_PARALLEL_EXECUTE_TASKxnDEFAULT_CONSUMER_GROUPGATHER_SYSTEM_STATISTICSxn DEFAULT_CONSUMER_GROUP* JAVA_DEPLOYxn#%DEFAULT_CONSUMER_GROUP ORACLE_OCM5A2E026A9157958Cxnxnxnxn DEFAULT_CONSUMER_GROUP>S:6941CCB899BB7942430303992C93C0A4F5E736593E0295F91DC6C9641940RECOVERY_CATALOG_OWNERxn.DEFAULT_CONSUMER_GROUPSCHEDULER_ADMINxn+DEFAULT_CONSUMER_GROUPHS_ADMIN_SELECT_ROLExn8DEFAULT_CONSUMER_GROUPHS_ADMIN_EXECUTE_ROLExn8DEFAULT_CONSUMER_GROUP HS_ADMIN_ROLExn8DEFAULT_CONSUMER_GROUPGLOBAL_AQ_USER_ROLEGLOBALxnDEFAULT_CONSUMER_GROUP OEM_ADVISORxn!DEFAULT_CONSUMER_GROUP OEM_MONITORxn!DEFAULT_CONSUMER_GROUPDBSNMPAED81394CBE28993xn!xo:xn!xn!DEFAULT_CONSUMER_GROUP>S:12ABB669E515B3516B234D95DF70C8EDC3530F5E2A4ECD58F529174D9857 APPQOSSYS519D632B7EE7F63Axn#xn#xn#xn# DEFAULT_CONSUMER_GROUP>S:61363257D2305C2394DF7007D032F1E4FAD561C970A3A02BEACEB27AAFE5!WMSYS7C9BA362F8314299xnxnxnxn DEFAULT_CONSUMER_GROUP>S:02BDC2DF6D4CB467A3A14FDCAB7A8866B391D763B015790CC1CC71388D29" WM_ADMIN_ROLExn&DEFAULT_CONSUMER_GROUP# JAVAUSERPRIVxnDEFAULT_CONSUMER_GROUP$ JAVAIDPRIVxnDEFAULT_CONSUMER_GROUP% JAVASYSPRIVxnDEFAULT_CONSUMER_GROUP& JAVADEBUGPRIVxnDEFAULT_CONSUMER_GROUP' EJBCLIENTxnDEFAULT_CONSUMER_GROUP( JMXSERVERxnDEFAULT_CONSUMER_GROUP) JAVA_ADMINxn#%DEFAULT_CONSUMER_GROUP01%'XS$NULLDC4FCC8CB69A6733xn'xn'xn'xn' DEFAULT_CONSUMER_GROUP>S:83229D58E6078739D6D10E137483961414CCE81C0C323CBCB250DCFC38C9+EXFSYS33C758A8E388DEE5xn$4xn$4xn$4xn$4 DEFAULT_CONSUMER_GROUP>S:EF6CF13A0D77F5C695AA2089647EFDD414D7F23D72F13AD6AB827C4F75D9,CTXSYS71E687F036AD56E5xn%xn%xn"xn" DEFAULT_CONSUMER_GROUP>S:4F601A86E17A30A841C7758BED33F696D0DB448A912BEA91F78E55462EC0-CTXAPPxn%DEFAULT_CONSUMER_GROUP.XDB88D8364765FCE6AFxn%6xn%6xn%6xn%6 DEFAULT_CONSUMER_GROUP>S:1E2B151D8A3345D58E8D597AF2EF498CA964B338A0A2931F50C6BFC245A2/ ANONYMOUS anonymousxn%6xn%6xn"xn" DEFAULT_CONSUMER_GROUP0XDBADMINxn%6DEFAULT_CONSUMER_GROUP1XDB_SET_INVOKERxn&DEFAULT_CONSUMER_GROUP2AUTHENTICATEDUSERxn&DEFAULT_CONSUMER_GROUP3XDB_WEBSERVICESxn&DEFAULT_CONSUMER_GROUP4XDB_WEBSERVICES_WITH_PUBLICxn&DEFAULT_CONSUMER_GROUP5XDB_WEBSERVICES_OVER_HTTPxn&DEFAULT_CONSUMER_GROUP>OLAPSYS4AC23CC3B15E2208xn,8xn,8xn,8xn,8 DEFAULT_CONSUMER_GROUP>S:4542DC38EBBF0A1D76F80D2C748B9D7A27CB022C4BEC2DC226D5C2FA2A156ORDSYS7EFA02EC7EA6B86Fxn'*xn'*xn'*xn'* DEFAULT_CONSUMER_GROUP>S:33BDDFA7A1F2AFB3AAC82F56E57BA7AFCE8820510DBD1DF8CA94EA19087D7ORDDATAA93EC937FCD1DC2Axn'*xn'*xn'*xn'* DEFAULT_CONSUMER_GROUP>S:1DD713366F74C3C50EE788472C538B30E96E1D993253573202667D1462BC8 ORDPLUGINS88A2B2C183431F00xn'*xn'*xn'*xn'* DEFAULT_CONSUMER_GROUP>S:EDC4BDA52D8EF3100E8F5E14AC44313ACA7D95973A7CE87CCC7381F2AB4D9SI_INFORMTN_SCHEMA84B8CBCA4D477FA3xn'*xn'*xn'+xn'+ DEFAULT_CONSUMER_GROUP>S:FC6FA1549854FA169C3E4E7637BAE62631BAA15A3AE8E2534A408AE24896:MDSYS72979A94BAD2AF80xn'+xn'+xn'+xn'+ DEFAULT_CONSUMER_GROUP>S:1BB48C9A4DF80EBF6CB29795D04869FA42B4A4DFAB6BA38049279563A230;ORDADMINxn':DEFAULT_CONSUMER_GROUP<OLAPI_TRACE_USERxn,+DEFAULT_CONSUMER_GROUP= OLAP_XS_ADMINxn,,DEFAULT_CONSUMER_GROUPSOWB_USERxnDEFAULT_CONSUMER_GROUP?OLAP_DBAxn,9DEFAULT_CONSUMER_GROUP@CWM_USERxn,9DEFAULT_CONSUMER_GROUPA OLAP_USERxn,9DEFAULT_CONSUMER_GROUPBMDDATADF02A496267DEE66xn-1xn-1xn"xn" DEFAULT_CONSUMER_GROUP>S:CC653BF2D267642D9E797B8020540903F52B11AE43745A4FB3A48C221863CSPATIAL_WFS_ADMINxn21DEFAULT_CONSUMER_GROUP>S:5CD9BA92CACEDE47BA8AC49519C33F3B3F0A6B3D0BA8105AB540B2DE3B38DSPATIAL_WFS_ADMIN_USR7117215D6BEE6E82xn21xn21xn21xn21 DEFAULT_CONSUMER_GROUP>S:CAB7CB03EF55180ECD926284C01188C97081472752FB0F53E9BB07D090F0E WFS_USR_ROLE094C14AA84362687xn21DEFAULT_CONSUMER_GROUP>S:85DE77D1F7A8C3FAB68EDC1B97BD0E642D0BFDD00CE998325E94836D12A8FSPATIAL_CSW_ADMIN093913703800E437xn27DEFAULT_CONSUMER_GROUP>S:57DAE60F8F8D5FACC0A5EF72DA328254CF231BDB9A796D1B42B61F11784CGSPATIAL_CSW_ADMIN_USR1B290858DD14107Exn27xn27xn27xn27 DEFAULT_CONSUMER_GROUP>S:7E593FE684C6BB610C29D85C1A4C4C44D010BD54488F2B389C0F461D9701H CSW_USR_ROLEF79FD2B778DEA3AAxn27DEFAULT_CONSUMER_GROUP>S:664FCD67C55BBDACCF02945AD51FB624A727802F48A8EC22F01C07000B9FISYSMANC2147EAFA86C5A27xn3xo: xn"xn"DEFAULT_CONSUMER_GROUP>S:71974569DA24DA8939C214C32138F06F9D0E33F97A7C5A72A601D78B0CCEJ MGMT_USERxn3DEFAULT_CONSUMER_GROUPK MGMT_VIEW2C00E5C8EE0A1FECxn8xo:$xn"xn"DEFAULT_CONSUMER_GROUP>S:5669B08706AAC21251DA71EC10097D4FD2B28819908A9E6C0785DBE7592AL FLOWS_FILESF1DE72E8D6A89019xn:xn:xn"xn" DEFAULT_CONSUMER_GROUP>S:F0E136A03CA5FB5AC072A648C887108DB6F2D9E2420370BF385B6E3ED358MAPEX_PUBLIC_USERC6BBF8681ABCED93xn:xn:xn"xn" DEFAULT_CONSUMER_GROUP>S:B2461445EDCC80CCFDDAF7AF11C0A8A6C8AF2594A947504C1325D19715A5NAPEX_ADMINISTRATOR_ROLExn:DEFAULT_CONSUMER_GROUPO APEX_030200A0A4E8B39539FE33xn:xn:xn"xn" DEFAULT_CONSUMER_GROUP>S:3DCBBF4760D3B60611CCDA2BB389235D0FC895BF0ADC5EC6E27A0800DCADPOWBSYS610A3C38F301776Fxnxnxn"xn" DEFAULT_CONSUMER_GROUP>S:FAD76A3F3404B34ACA14498F9E8FF0A641E4B0BB875CBF65057329430150Q OWB$CLIENT13D492A4459DFE0DxnDEFAULT_CONSUMER_GROUP>S:EDD08A386D961B35E097E9153DF2CACA69E3CCFE22DD64218AF9433DAAA1ROWB_DESIGNCENTER_VIEWxnDEFAULT_CONSUMER_GROUP] _NEXT_USERxn,DEFAULT_CONSUMER_GROUPT OWBSYS_AUDITFD8C3D14F6B60015xnxnxn"xn" DEFAULT_CONSUMER_GROUP>S:8E57625F640B315CA7F9219F2C536DBD63219779021D3ADEE00624F453DEUSCOTTF894844C34402B67xnxnxo9(xo9( DEFAULT_CONSUMER_GROUP>S:45184B84D44775C31633B8DF0DC5DE2C5153E23F21A2EB73B44881843220VHR6399F3B38EDF3288xo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:E7F719243B356BD7C7E30FF6BABEE3C8D88636FBA54E5F3272D7BC5B4DDDWOE9C30855E7E0CB02Dxo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:C7B43F127A4B2E159B82E1AB44F5A999CD143BE0A536FF4B70661D7B7708XIX2BE6F80744E08FEBxo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:D1A1F92931BE2A8606BB413884FF29BACB84B35D2F49485888D5487EE5E4YSH9793B3777CD3BD1Axo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:598EF92F764C90E139CA398584C6C9F96CD509BE00D8C778651A10F73A6EZPM72E382A52E89575Axo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:97BCAA614FD1684C5D1FA9D01C9CDC1CDAB95FAA384382F9BF92D5060DB2[BIFA1D2B85B70213F3xo7xo7xo9(xo9( DEFAULT_CONSUMER_GROUP>S:7A8D1C6044A92BCBE4FC7D28EE393D12788A8C56A3A90E670C3E269E39A7\PRONEERB92AC55EB38FD923xo)xo)DEFAULT_CONSUMER_GROUP>S:EA094B23FE444D11C230C341F7BD7D250907647C84B6F0334D4FB52A1901 GRANT SELECT ON "USER$" TO "APEX_030200" CREATE UNIQUE INDEX "I_USER1" ON "USER$" ("NAME" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "USER$" [BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"I_USER1"',NULL,NULL,NULL,33,1,33,1,1,13,0,6); END; CREATE UNIQUE INDEX "I_USER2" ON "USER$" ("USER#" , "TYPE#" , "SPARE1" , "SPARE2" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "SYSTEM" LOGGING ANALSTATS IS "USER$" ZBEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"I_USER2"',NULL,NULL,NULL,33,1,33,1,1,3,0,6); END; ANALSTATS TS "USER$" PBEGIN DBMS_STATS.SET_TABLE_STATS(NULL,'"USER$"',NULL,NULL,NULL,33,2,92,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C121'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,32&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"USER#"', NULL ,NULL,NULL,33,.0303030303030303,0,srec,3,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '41444D5F504152414C4C454C5F455845435554455F5441534B'; SREC.MAXVAL := '5F4E4558545F55534552'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I338884629724424000000000000000000000,494855723589788000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"NAME"', NULL ,NULL,NULL,33,.0303030303030303,0,srec,16,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C102'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,1&); SREC.BKVALS := DBMS_STATS.NUMARRAY(26,33}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"TYPE#"', NULL ,NULL,NULL,2,.0151515151515152,0,srec,3,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '34413342413535453038353935433831'; SREC.MAXVAL := '474C4F42414C'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I271321854409179000000000000000000000,370200819615639000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"PASSWORD"', NULL ,NULL,NULL,8,.125,25,srec,5,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C105'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,1,4&); SREC.BKVALS := DBMS_STATS.NUMARRAY(29,31,33); SREC.EPC := 3; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"DATATS#"', NULL ,NULL,NULL,3,.0151515151515152,0,srec,3,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C104'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,3&); SREC.BKVALS := DBMS_STATS.NUMARRAY(26,33); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"TEMPTS#"', NULL ,NULL,NULL,2,.0151515151515152,0,srec,3,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786E04020E132C'; SREC.MAXVAL := '786E04020E1C23'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2455289.55466435,2455289.56081019&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1~); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"CTIME"', NULL ,NULL,NULL,17,.0588235294117647,0,srec,8,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786E04020E132C'; SREC.MAXVAL := '786E04020E1C23'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2455289.55466435,2455289.56081019&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1}); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"PTIME"', NULL ,NULL,NULL,6,.166666666666667,26,srec,3,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786E04020E1514'; SREC.MAXVAL := '786E04020E1C23'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2455289.55577546,2455289.56081019&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1r); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"EXPTIME"', NULL ,NULL,NULL,4,.25,29,srec,2,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '786E04020E1514'; SREC.MAXVAL := '786E04020E1C23'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(!2455289.55577546,2455289.56081019&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"LTIME"', NULL ,NULL,NULL,4,.25,29,srec,2,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := '80'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1q); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"RESOURCE$"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"AUDIT$"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C102'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,1&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"DEFROLE"', NULL ,NULL,NULL,2,.5,0,srec,3,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"DEFGRP#"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"DEFGRP_SEQ#"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" yDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := 'C10A'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,9&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1p); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"ASTATUS"', NULL ,NULL,NULL,2,.5,0,srec,3,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := '80'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1n); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"LCOUNT"', NULL ,NULL,NULL,1,1,0,srec,2,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '44454641554C545F434F4E53554D45525F47524F5550'; SREC.MAXVAL := '44454641554C545F434F4E53554D45525F47524F5550'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I354481238834041000000000000000000000,354481238834041000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1t); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"DEFSCHCLASS"', NULL ,NULL,NULL,1,1,0,srec,23,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1u); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"EXT_USERNAME"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '80'; SREC.MAXVAL := '80'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(33~); SREC.EPC := 1; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE1"', NULL ,NULL,NULL,1,.0151515151515152,0,srec,2,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE2"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE3"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '533A303645464632313539443044423646354344333241344532344637453945'; SREC.MAXVAL := '533A463238354631373146414232353342393741373335444334463141343436'; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(I432140838763142000000000000000000000,432142580528981000000000000000000000&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE4"', NULL ,NULL,NULL,7,.142857142857143,26,srec,15,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE5"', NULL ,NULL,NULL,0,0,33,srec,0,6); END; ANALSTATS TS "USER$" wDECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := NULL; SREC.MAXVAL := NULL; SREC.EAVS := 0; SREC.CHVALS := NULL; #SREC.NOVALS := DBMS_STATS.NUMARRAY(0,0&); SREC.BKVALS := DBMS_STATS.NUMARRAY(0,1o); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NULL,'"USER$"','"SPARE6"', NULL ,NULL,NULL,0,0,33,srec,1,6); END; CONNECT SYSTEM CONNECT SYS METRICSTreferential integrity constraints METRICET 94 METRICSTtriggers METRICET 94 METRICSTbitmap, functional and extensible indexes METRICET 94 METRICSTposttables actions METRICET 94 METRICSTPost-inst procedural actions METRICET 94 METRICSTDeferred analyze commands TABLE "USER$" ANALCOMPUTE TS "USER$" ANALYZE TABLE "USER$" ESTIMATE STATISTICS ENDTABLE METRICET 95 METRICETG0 EXIT EXIT