Menu de navegação

[edersondesouzaParticipante]

SQL> select OWNER, OBJECT_NAME, OBJECT_TYPE from all_objects
where status = ‘INVALID’;

OWNER OBJECT_NAME OBJECT_TYPE
—————————— —————————— ——————-
PUBLIC DBA_REPGROUPED_COLUMN SYNONYM
PUBLIC ALL_REPGROUPED_COLUMN SYNONYM
PUBLIC USER_REPGROUPED_COLUMN SYNONYM
SYS _ALL_REPCOLUMN_GROUP VIEW
SYS _ALL_REPRESOLUTION VIEW
PUBLIC DBA_REPPARAMETER_COLUMN SYNONYM
SYS _ALL_REPPARAMETER_COLUMN VIEW
PUBLIC ALL_REPPARAMETER_COLUMN SYNONYM
PUBLIC USER_REPPARAMETER_COLUMN SYNONYM
SYS _ALL_REPCONFLICT VIEW
PUBLIC CWM_OLAP_HIERARCHY SYNONYM
PUBLIC CWM_OLAP_LEVEL SYNONYM
PUBLIC CWM_OLAP_MEASURE SYNONYM
PUBLIC CWM_OLAP_LEVEL_ATTRIBUTE SYNONYM
PUBLIC CWM_OLAP_DIM_ATTRIBUTE SYNONYM
PUBLIC CWM_OLAP_DIMENSION SYNONYM
PUBLIC CWM_EXCEPTIONS SYNONYM
PUBLIC ALL_OLAP_CATALOG_ENTITY_USES SYNONYM
PUBLIC ALL_OLAP_CUBE_DIM_USES SYNONYM
PUBLIC ALL_OLAP_CUBE_MEASURE_DIM_USES SYNONYM
PUBLIC ALL_OLAP_DIM_ATTR_USES SYNONYM
PUBLIC ALL_OLAP_DIM_ATTRIBUTES SYNONYM
PUBLIC ALL_OLAP_DIM_LEVEL_ATTRIBUTES SYNONYM
PUBLIC ALL_OLAP_ENTITY_DESC_USES SYNONYM
PUBLIC ALL_OLAP_FUNCTION_USAGES SYNONYM
PUBLIC ALL_OLAPMR_DIMENSIONS SYNONYM
PUBLIC ALL_OLAPMR_DIM_ATTRIBUTES SYNONYM
PUBLIC ALL_OLAPMR_ATTRIBUTES SYNONYM
PUBLIC ALL_OLAPMR_DIM_LEVELS SYNONYM
PUBLIC CWM2_OLAP_MANAGER SYNONYM
PUBLIC CWM2_OLAP_UTILITY SYNONYM
PUBLIC CWM2_OLAP_CATALOG SYNONYM
PUBLIC CWM2_OLAP_VALIDATE SYNONYM
PUBLIC CWM2_OLAP_VERIFY_ACCESS SYNONYM
PUBLIC CWM2_SECURITY SYNONYM
PUBLIC CWM2_OLAP_TABLE_MAP SYNONYM
PUBLIC CWM2_OLAP_PC_TRANSFORM SYNONYM
PUBLIC ALL_OLAP2_CUBE_MEAS_DIM_USES SYNONYM
PUBLIC ALL_OLAP2_DIM_LEVELS SYNONYM
PUBLIC ALL_OLAP2_RUFCTTBLKYMAPS SYNONYM
PUBLIC ALL_OLAPMR_DIM_LEVELS_KEYMAPS SYNONYM
PUBLIC ALL_OLAP2_DIM_LEVELS_KEYMAPS SYNONYM
PUBLIC ALL_OLAP2_MR_MEASDIMVIEW SYNONYM
PUBLIC ALL_OLAP9I1_HIER_DIMENSIONS SYNONYM
PUBLIC ALL_OLAP9I2_HIER_DIMENSIONS SYNONYM
PUBLIC ALL_OLAP1_CUBES SYNONYM
PUBLIC ALL_OLAP2_ENTITY_PARAMETERS SYNONYM
PUBLIC ALL_OLAP2_ENTITY_EXT_PARMS SYNONYM
PUBLIC DBA_OLAP2_CUBES SYNONYM
PUBLIC DBA_OLAPMR_FACTTBLKEYMAPS SYNONYM
PUBLIC DBA_OLAP1_CUBES SYNONYM
PUBLIC ALL_AW_LOAD_DIMENSIONS SYNONYM
PUBLIC ALL_AW_LOAD_DIM_FILTERS SYNONYM
PUBLIC ALL_AW_LOAD_CUBE_FILTERS SYNONYM
PUBLIC ALL_AW_LOAD_CUBE_MEASURES SYNONYM
PUBLIC ALL_AW_LOAD_DIM_PARMS SYNONYM
PUBLIC ALL_AW_LOAD_CUBE_DIMS SYNONYM
PUBLIC ALL_AW_LOAD_CUBES SYNONYM
PUBLIC ALL_AW_LOAD_CUBE_PARMS SYNONYM
PUBLIC ALL_OLAP2_MV_CUBE_AGG_MEASURES SYNONYM
PUBLIC ALL_OLAP2_MV_CUBE_AGG_LEVELS SYNONYM
PUBLIC ALL_LOAD_CUBE_SEGWIDTH SYNONYM
PUBLIC ALL_AW_CUBE_AGG_PLANS SYNONYM
PUBLIC ALL_AW_CUBE_AGG_MEASURES SYNONYM
PUBLIC ALL_AW_CUBE_AGG_LEVELS SYNONYM
PUBLIC CWM2_OLAP_MR_SECURITY_INIT SYNONYM
PUBLIC CWM2_OLAP_MR_SESSION_POP SYNONYM
PUBLIC CWM2_OLAP_MR_CHECK_PRIVS SYNONYM
PUBLIC CWM2_OLAP_METADATA_REFRESH SYNONYM
PUBLIC OLAPFACTVIEW SYNONYM
PUBLIC OLAPDIMVIEW SYNONYM
PUBLIC DBMS_ODM SYNONYM
PUBLIC CWM2_OLAP_OLAPAPI_ENABLE SYNONYM
PUBLIC CWM2_OLAP_AW_AWUTIL SYNONYM
PUBLIC DBMS_AW_UTILITIES SYNONYM
PUBLIC DBMS_AWM SYNONYM
WKSYS /56e69815_InsoFilter JAVA CLASS
WKSYS /c6691f0c_InsoFilterTempFileIn JAVA CLASS
WKSYS /b6ea57ea_IsearchResBun JAVA CLASS
WKSYS /5f38c7be_IsearchResBun_ar JAVA CLASS
WKSYS /5dbe7873_IsearchResBun_ca JAVA CLASS
WKSYS /4ea26015_IsearchResBun_iw JAVA CLASS
WKSYS /9037a837_IsearchResBun_fr JAVA CLASS
WKSYS /17bd8727_IsearchResBun_en JAVA CLASS
WKSYS /9037721d_IsearchResBun_de JAVA CLASS
WKSYS /53eead0_IsearchResBun_ja JAVA CLASS
WKSYS /8c17c58b_IsearchResBun_ko JAVA CLASS
WKSYS /63ca093a_IsearchResBun_it JAVA CLASS
WKSYS /6658635a_IsearchResBun_zh_CN JAVA CLASS
WKSYS /b9fa78fc_IsearchResBun_pt_BR JAVA CLASS
WKSYS /cef7bf42_IsearchResBun_es JAVA CLASS
WKSYS /ffbc5195_IsearchResBun_cs JAVA CLASS
WKSYS /2a5c04e7_IsearchResBun_da JAVA CLASS
WKSYS /8548e707_IsearchResBun_el JAVA CLASS
WKSYS /55db34d4_IsearchResBun_fi JAVA CLASS
WKSYS /d1a9d2ef_IsearchResBun_hu JAVA CLASS
WKSYS /abb3ba37_IsearchResBun_nl JAVA CLASS
WKSYS /14d3851b_IsearchResBun_no JAVA CLASS
WKSYS /46f8f375_IsearchResBun_pl JAVA CLASS
WKSYS /452e5304_IsearchResBun_pt JAVA CLASS
WKSYS /bde819b0_IsearchResBun_ro JAVA CLASS
WKSYS /5502171f_IsearchResBun_ru JAVA CLASS
WKSYS /7142ca27_IsearchResBun_sk JAVA CLASS
WKSYS /2a11b71b_IsearchResBun_sv JAVA CLASS
WKSYS /734e2c14_IsearchResBun_th JAVA CLASS
WKSYS /a6c6896d_IsearchResBun_tr JAVA CLASS
WKSYS /14ae6ff6_IsearchResBun_zh_TW JAVA CLASS
WKSYS /2599c15d_IsearchResBun_es_ES JAVA CLASS
WKSYS oracle/context/isearch/GetPage JAVA CLASS
WKSYS /d9b8f667_GetMailPage JAVA CLASS
WKSYS /3cdc11e4_StreamReader JAVA CLASS
WKSYS /5c59e7e4_MailTool JAVA CLASS
WKSYS WK$INST_LIST VIEW
PUBLIC WK$INST_LIST SYNONYM
PUBLIC WK$INST_ADMIN_LIST SYNONYM
WKSYS /f7224e97_GenerateConfig JAVA CLASS
WKSYS /dfe0f68d_IsearchException JAVA CLASS
WKSYS /8ebb2942_LaunchProcess JAVA CLASS
PUBLIC WK$DATA_SOURCE SYNONYM
PUBLIC WK$TDS_LOG SYNONYM
WKSYS WK$SYS_ADMIN_LIST VIEW
PUBLIC WK$SYS_ADMIN_LIST SYNONYM
PUBLIC WK$DATA_SOURCE_TYPE SYNONYM
PUBLIC WK$SOURCE_GROUP SYNONYM
PUBLIC WK$SYS_ADMIN SYNONYM
PUBLIC WK$CRAWLER_CONFIG SYNONYM
PUBLIC WK$CRAWLER_SCHED SYNONYM
PUBLIC WK$GROUP_DS_MAPPING SYNONYM
PUBLIC WK$TRACE SYNONYM
PUBLIC WK$SOURCE_GROUP_TL SYNONYM
PUBLIC WK$SCHED_MAPPING SYNONYM
PUBLIC WK$JOB_INFO SYNONYM
PUBLIC WK$ATTR_MAPPING SYNONYM
PUBLIC WK$DATA_SOURCE_PARAM SYNONYM
PUBLIC WK$SEARCH_ATTR_TL SYNONYM
PUBLIC WK$SEARCH_ATTR SYNONYM
PUBLIC WK$DATA_SOURCE_PARAM_VAL SYNONYM
PUBLIC WK$DOC_ATTR SYNONYM
PUBLIC WK$ATTR_USAGE SYNONYM
PUBLIC WK$AUTHBASIC SYNONYM
PUBLIC WK$PORTAL_DS_MAP SYNONYM
PUBLIC WK$PORTAL SYNONYM
PUBLIC WK$MAILLIST SYNONYM
PUBLIC WK$CRAWLER_STAT SYNONYM
PUBLIC WKDS_ADM SYNONYM
PUBLIC WK_ADM SYNONYM
PUBLIC WK_QUERYAPI SYNONYM
PUBLIC WK_QRY SYNONYM
PUBLIC WK_PORTAL SYNONYM
PUBLIC WK_META SYNONYM
PUBLIC WK_JOB SYNONYM
PUBLIC WK_ERR SYNONYM
PUBLIC WK_DEF SYNONYM
PUBLIC WK_DDL SYNONYM
PUBLIC WK_CRW SYNONYM
PUBLIC WK_UTIL SYNONYM
PUBLIC WK_SNAPSHOT SYNONYM
PUBLIC WK_SGP SYNONYM
PUBLIC WK_QUTIL SYNONYM
PUBLIC WK_QUERY_ADM SYNONYM
PUBLIC CWM2_OLAP_AW_ACCESS SYNONYM
PUBLIC CWM2_OLAP_INSTALLER SYNONYM
OLAPSYS ALL$OLAP2_AW_MAP_DIM_USE VIEW
PUBLIC ALL_OLAP2_AW_MAP_DIM_USE SYNONYM
OLAPSYS ALL$OLAP2_AW_MAP_MEAS_USE VIEW
PUBLIC ALL_OLAP2_AW_MAP_MEAS_USE SYNONYM
OLAPSYS ALL$OLAP2_AW_MAP_ATTR_USE VIEW
PUBLIC ALL_OLAP2_AW_MAP_ATTR_USE SYNONYM
ODM AQ$DMS_QUEUE_TABLE VIEW
WKSYS WK$IS_ADMIN FUNCTION
ODM /10b943ec_CompoundPredicate JAVA CLASS
ODM /110fa163_ClassificationTestRe JAVA CLASS
ODM /15b25e32_UtilBundleKeys JAVA CLASS
ODM /1959812d_PMMLARModelImport JAVA CLASS
ODM /19c69108_ODMBundle_zh_TW JAVA CLASS
ODM /19ef54ec_MiningFunctionSettin JAVA CLASS
ODM /1a2b8fc3_ClusterCentroid JAVA CLASS
ODM /1b202de9_CombinationNaiveBaye JAVA CLASS
ODM /1c7228f5_UtilBundle_zh_TW JAVA CLASS
ODM /1ce53e92_Data JAVA CLASS
ODM /1d06a7b5_ClassificationFuncti JAVA CLASS
ODM /1d099755_ComparisonFunction JAVA CLASS
ODM /1d20a8e8_MiningLiftResult JAVA CLASS
ODM /1dcfa278_AssociationRulesFunc JAVA CLASS
ODM /1df85012_ODMBundle_de JAVA CLASS
ODM /1fd72287_CategoryComparator JAVA CLASS
ODM /2105813f_Version JAVA CLASS
ODM /21e1730a_PairCombinationsOpti JAVA CLASS
ODM /2400ace9_VersionException JAVA CLASS
ODM /25181124_ABNPredRes JAVA CLASS
ODM /2638d26_UtilBundle_fr JAVA CLASS
ODM /268a902c_RecordInst JAVA CLASS
ODM /274368c0_LocationEqualityLeve JAVA CLASS
ODM /27ac914e_ClassificationTestTa JAVA CLASS
ODM /282f7675_PredicateRuleCompone JAVA CLASS
ODM /29063ad7_PMMLARModelExport JAVA CLASS
ODM /294e8d54_VersionSQLWrapper JAVA CLASS
ODM /2be8f56b_AttributeHistogramEn JAVA CLASS
ODM /2c4c146c_ODMClusteringModel JAVA CLASS
ODM /2dec8432_AttributeImportanceM JAVA CLASS
ODM /2e0ebc4b_AdaptiveBayesNetwork JAVA CLASS
ODM /2ee98003_PMMLModelImport JAVA CLASS
ODM /2f7f1de2_DMSBuildTaskODM_ABN_ JAVA CLASS
ODM /30c590e1_AdaptiveBayesNetwork JAVA CLASS
ODM /317f635b_UtilBundle_pt_BR JAVA CLASS
ODM /3530881c_StringTooLongExcepti JAVA CLASS
ODM /35e620cd_DiscretizationSpecif JAVA CLASS
ODM /376a4253_AdaptiveBayesNetwork JAVA CLASS
ODM /37c1b05c_NonTransactionalData JAVA CLASS
ODM /3828fb5e_TableInfo JAVA CLASS
ODM /38fb5148_SimplePredicate JAVA CLASS
ODM /3a719753_ABNPredGroup JAVA CLASS
ODM /3a938395_EnumerationsMessageT JAVA CLASS
ODM /3ad5315f_MiningDataTask JAVA CLASS
ODM /3b74fe0_MiningTaskStatus JAVA CLASS
ODM /3c950e87_ABNMiningRule JAVA CLASS
ODM /3efcd62d_OClusterAlgorithmSet JAVA CLASS
ODM /40eb06e7_StringCheck JAVA CLASS
ODM /4165d653_DMSBuildTaskODM_CLUS JAVA CLASS
ODM /41f15e03_LiftResultElement JAVA CLASS
ODM /43a31c52_ApplySourceAttribute JAVA CLASS
ODM /44e9b5fd_ODMMiningTask JAVA CLASS
ODM /45220d4b_DMSModelSeekerTask JAVA CLASS
ODM /4598304d_EnumerationsMessageL JAVA CLASS
ODM /46c30b44_TargetList JAVA CLASS
ODM /46d4c445_RuleSortCriteria JAVA CLASS
ODM /47125f6c_UtilBundle_it JAVA CLASS
ODM /48120052_ClusteringMiningRule JAVA CLASS
ODM /4c4413d8_MiningBuildResult JAVA CLASS
ODM /4dd86d0a_DataUsageEntry JAVA CLASS
ODM /4e20842f_ODMNaiveBayesModel JAVA CLASS
ODM /4e3ff070_RuleComponent JAVA CLASS
ODM /4f6eff2c_DMSBuildTask JAVA CLASS
ODM /4ff58c70_DMSTask JAVA CLASS
ODM /50e68960_CategoryMatrixConsta JAVA CLASS
ODM /525f4c2a_DMSBuildTaskMODEL_TY JAVA CLASS
ODM /531b7f89_PMMLNBModelImport JAVA CLASS
ODM /5477a88b_UtilBundle JAVA CLASS
ODM /5545bde5_DMSBuildTaskMODEL_TY JAVA CLASS
ODM /5675b4a4_UtilBundle_de JAVA CLASS
ODM /569451e6_MiningTestResult JAVA CLASS
ODM /56cd02f_PMMLModelExport JAVA CLASS
ODM /57da8d10_EnumerationsVersionC JAVA CLASS
ODM /58af1fcb_Resources JAVA CLASS
ODM /5afdfc15_ShareUtils JAVA CLASS
ODM /5e6889f5_ClusterCentroidEntry JAVA CLASS
ODM /62130238_MiningApplyOutput JAVA CLASS
ODM /656469f4_CategoricalDiscretiz JAVA CLASS
ODM /67aa6ef1_ODMAdaptiveBayesNetw JAVA CLASS
ODM /67b2a06a_ODMBundle_ko JAVA CLASS
ODM /67d68b96_DMSApplyTask JAVA CLASS
ODM /69150f79_EnumerationsTraceSet JAVA CLASS
ODM /6b8da521_ODMBundle_es JAVA CLASS
ODM /6c124880_LocationAccessData JAVA CLASS
ODM /6c6e8cc_PriorProbabilitiesEnt JAVA CLASS
ODM /6f68c673_MiningFunctionSettin JAVA CLASS
ODM /7052e2ba_InvalidArgumentExcep JAVA CLASS
ODM /72092e56_Transformation JAVA CLASS
ODM /72141ce1_NumericalBin JAVA CLASS
ODM /7266a413_ODMBundle_fr JAVA CLASS
ODM /7344d889_EnumerationsTraceSet JAVA CLASS
ODM /736e3c42_MiningModelDMT_ODM JAVA CLASS
ODM /73ac2533_EnumerationsVersionC JAVA CLASS
ODM /765fda1b_ConditionalProbabili JAVA CLASS
ODM /770c622a_MiningAlgorithmSetti JAVA CLASS
ODM /7797b779_ODMModelSeekerResult JAVA CLASS
ODM /77b075bc_NetworkFeature JAVA CLASS
ODM /782575ff_BooleanPredicate JAVA CLASS
ODM /7872b479_ODMBundle JAVA CLASS
ODM /789b73e5_NaiveBayesSettings JAVA CLASS
ODM /79d0525d_ClusterDistribution JAVA CLASS
ODM /7ad8f30a_AttributeImportanceE JAVA CLASS
ODM /7b051d30_TransformationSqlSta JAVA CLASS
ODM /7d8a82ac_DMSModelImportTask JAVA CLASS
ODM /7d9b0453_MiningStandardType JAVA CLASS
ODM /7da0ffdc_SupervisedFunctionSe JAVA CLASS
ODM /7f3008cd_ModelTimingRecord JAVA CLASS
ODM /8124719c_EISUtilsODM_MINING_T JAVA CLASS
ODM /8231a6a9_CrossValidateTask JAVA CLASS
ODM /82a1aa8b_ODMInternalException JAVA CLASS
ODM /840e07a6_ODMBundleKeys JAVA CLASS
ODM /86534ad5_ODMMiningFunctionSet JAVA CLASS
ODM /87256bea_NumericalDiscretizat JAVA CLASS
ODM /879dc192_EISUtils JAVA CLASS
ODM /880dc299_ClusteringModel JAVA CLASS
ODM /8937c255_DMSBuildTaskODM_ASSO JAVA CLASS
ODM /89cf9f1b_ODM_MiningRuleSet JAVA CLASS
ODM /89d76ab5_LocationCellAccessDa JAVA CLASS
ODM /8af03889_ModelSeekerResult JAVA CLASS
ODM /8e775023_ABNModelBuildState JAVA CLASS
ODM /8eae009a_ODMModelSeekerResult JAVA CLASS
ODM /8f7758b0_DMSBuildTaskODM_NAIV JAVA CLASS
ODM /90fe7e3d_ODMVersion JAVA CLASS
ODM /91408856_NaiveBayesModel JAVA CLASS
ODM /927d52bc_DMSBuildTableSet JAVA CLASS
ODM /934109d9_ModelSeekerTask JAVA CLASS
ODM /93d4b621_RecordInstance JAVA CLASS
ODM /93eb3aa_MiningApplyResult JAVA CLASS
ODM /95e58cb4_DataUsageSpecificati JAVA CLASS
ODM /993b5f80_AttributeInstance JAVA CLASS
ODM /9993c2f7_AttributeHistogram JAVA CLASS
ODM /99fe3898_AttributeDiscretizat JAVA CLASS
ODM /9aa703dc_ODMAttributeImportan JAVA CLASS
ODM /9b90aa28_MessageLog JAVA CLASS
ODM /9c80ea87_StringCheckLengthDef JAVA CLASS
ODM /9ed492d4_EnumerationsMessageG JAVA CLASS
ODM /a048deeb_UtilityException JAVA CLASS
ODM /a126fc0a_ODMAssociationRulesM JAVA CLASS
ODM /a1f5a30a_TableInfoManager JAVA CLASS
ODM /a2d88cfa_ApplyContentOptionIt JAVA CLASS
ODM /a57a7b96_MessageLog1 JAVA CLASS
ODM /a758865f_MiningAttribute JAVA CLASS
ODM /a7be420a_UtilBundle_ko JAVA CLASS
ODM /a7e93d38_MiningApplyTask JAVA CLASS
ODM /a9b3f34_ABNModelBuildType JAVA CLASS
ODM /ab91f2ef_DBUtils JAVA CLASS
ODM /abbda4e3_MiningModel JAVA CLASS
ODM /ada60494_PhysicalDataSpecific JAVA CLASS
ODM /adb2cb64_EISTablePrefixes JAVA CLASS
ODM /ae2fd51c_ARMiningRuleCursor JAVA CLASS
ODM /b07a2284_RuleAnnotationType JAVA CLASS
ODM /b0e92c97_EnumerationsMessageL JAVA CLASS
ODM /b1835b7b_RuleRes JAVA CLASS
ODM /b1fb510d_DMSTestTask JAVA CLASS
ODM /b3ea618a_ODMBundle_ja JAVA CLASS
ODM /b4593976_SupervisedModel JAVA CLASS
ODM /b521cc49_ModelImportTask JAVA CLASS
ODM /b54a6d9b_ApplyContentItem JAVA CLASS
ODM /b6432737_RuleGroup JAVA CLASS
ODM /b6538f9b_DMSModelExportTask JAVA CLASS
ODM /b9d3cf0a_RuleAnnotation JAVA CLASS
ODM /ba32e420_VersionBase JAVA CLASS
ODM /bbd46f03_ODMBundle_zh_CN JAVA CLASS
ODM /bc21e77a_ODMBundle_it JAVA CLASS
ODM /bf856ef0_ModelExportTask JAVA CLASS
ODM /c24af74e_AttributeImportanceA JAVA CLASS
ODM /c2533f23_KMeansAlgorithmSetti JAVA CLASS
ODM /c2ced68b_ODMClassificationTes JAVA CLASS
ODM /c3660255_EnumerationsMessageS JAVA CLASS
ODM /c67be34a_ODMSupervisedModel JAVA CLASS
ODM /c6a1c1e8_PredictionGroup JAVA CLASS
ODM /c78509ce_AttrInst JAVA CLASS
ODM /c8e0af84_ModelSeekerResultEnt JAVA CLASS
ODM /c90ede34_MessageLogConstants JAVA CLASS
ODM /caf41d30_MiningResult JAVA CLASS
ODM /cb230cfe_MiningOperationExcep JAVA CLASS
ODM /cda429ed_MiningLiftTask JAVA CLASS
ODM /cebb939a_AssociationRulesMode JAVA CLASS
ODM /cf4d4a01_ObjectMigrationTool JAVA CLASS
ODM /cfa0c89f_EnumerationsMessageG JAVA CLASS
ODM /d1889073_ClusteringAlgorithmS JAVA CLASS
ODM /d4c0cbcb_UtilBundle_zh_CN JAVA CLASS
ODM /d5434149_ApplyResultContentOp JAVA CLASS
ODM /d5a6cce5_EnumerationsMessageS JAVA CLASS
ODM /d6538bb_DistanceFunction JAVA CLASS
ODM /d753eb3b_DMSCrossValidateTask JAVA CLASS
ODM /d7eba09b_Security JAVA CLASS
ODM /d8335b8_Enumerations JAVA CLASS
ODM /d8d3e4e_ODMBundle_pt_BR JAVA CLASS
ODM /d9789a95_PMMLModelExportXMLSt JAVA CLASS
ODM /dc00fca5_TransformationConsta JAVA CLASS
ODM /ddd4a0ab_MiningTaskException JAVA CLASS
ODM /de3029c0_DMSTaskExecutionExce JAVA CLASS
ODM /e1006c44_UtilBundle_ja JAVA CLASS
ODM /e364c41c_EnumerationsMessageT JAVA CLASS
ODM /e373578f_EnumerationsInfo JAVA CLASS
ODM /e6a2424f_PriorProbabilities JAVA CLASS
ODM /e78173a6_DMSBuildTaskODM_ATTR JAVA CLASS
ODM /e8a6e21e_LogicalDataSpecifica JAVA CLASS
ODM /e8ba3cc8_DataMiningServer JAVA CLASS
ODM /e915cc6d_ApplyTargetProbabili JAVA CLASS
ODM /e9cdef63_ApplyRuleItem JAVA CLASS
ODM /ea1a930f_MiningRuleSet JAVA CLASS
ODM /ee94fc4e_ConnectionTest JAVA CLASS
ODM /ef441d65_EnumerationsComponen JAVA CLASS
ODM /ef6c7bb6_CategoryGroup JAVA CLASS
ODM /f03a548_CategoryMatrixEntry JAVA CLASS
ODM /f1056fdd_DMSMonitor JAVA CLASS
ODM /f2867c7b_PMMLNBModelExportODM JAVA CLASS
ODM /f2e28f8_AttributeImportanceFu JAVA CLASS
ODM /f30c9b4b_PredictorVarianceSet JAVA CLASS
ODM /f323afb7_DataPreparationStatu JAVA CLASS
ODM /f346fe7a_CombinationModelSett JAVA CLASS
ODM /f3756960_TransactionalDataSpe JAVA CLASS
ODM /f3ef0f59_ClusteringFunctionSe JAVA CLASS
ODM /f405d8d6_MiningBuildTask JAVA CLASS
ODM /f4493039_TargRec JAVA CLASS
ODM /f4974690_ModelSeekerClassific JAVA CLASS
ODM /f4aea501_PredRes JAVA CLASS
ODM /f74db4f7_DMSTableSet JAVA CLASS
ODM /f766b63d_ClusteringStoppingCr JAVA CLASS
ODM /f82164a1_MessageLogException JAVA CLASS
ODM /f95195a2_ODMMiningModel JAVA CLASS
ODM /f9d24f1c_DMSLiftTask JAVA CLASS
ODM /fa663ea7_ConditionalProbabili JAVA CLASS
ODM /fc361ca3_CombinationAdaptiveB JAVA CLASS
ODM /fc97d9_AlterSession JAVA CLASS
ODM /fde30dbf_UtilBundle_es JAVA CLASS
ODM /fee3e008_MiningObjectExceptio JAVA CLASS
ODM /ff4ee56d_PMMLNBModelExport JAVA CLASS
ODM /ffd93009_ABNMiningRuleCursor JAVA CLASS
ODM /fff11812_ApplyMultipleScoring JAVA CLASS
ODM oracle/dmt/dmutil/base/Enum JAVA CLASS
ODM oracle/dmt/odm/AccessData JAVA CLASS
ODM oracle/dmt/odm/AttributeType JAVA CLASS
ODM oracle/dmt/odm/AttributeUsage JAVA CLASS
ODM oracle/dmt/odm/BooleanOperator JAVA CLASS
ODM oracle/dmt/odm/Category JAVA CLASS
ODM oracle/dmt/odm/CategoryMatrix JAVA CLASS
ODM oracle/dmt/odm/Connection JAVA CLASS
ODM oracle/dmt/odm/DataFormatType JAVA CLASS
ODM oracle/dmt/odm/DataType JAVA CLASS
ODM oracle/dmt/odm/Enum JAVA CLASS
ODM oracle/dmt/odm/LocatableObject JAVA CLASS
ODM oracle/dmt/odm/Location JAVA CLASS
ODM oracle/dmt/odm/LockObject JAVA CLASS
ODM oracle/dmt/odm/MiningAlgorithm JAVA CLASS
ODM oracle/dmt/odm/MiningFunction JAVA CLASS
ODM oracle/dmt/odm/MiningObject JAVA CLASS
ODM oracle/dmt/odm/MiningTaskState JAVA CLASS
ODM oracle/dmt/odm/ODMConnection JAVA CLASS
ODM oracle/dmt/odm/ODMException JAVA CLASS
ODM oracle/dmt/odm/ODMVersion JAVA CLASS
ODM oracle/dmt/odm/SortOrder JAVA CLASS
ODM oracle/dmt/odm/UsageAdjustment JAVA CLASS
ODM oracle/dmt/odm/data/Attribute JAVA CLASS
ODM oracle/dmt/odm/model/Cluster JAVA CLASS
ODM oracle/dmt/odm/model/TreeNode JAVA CLASS
ODM oracle/dmt/odm/rule/ItemValue JAVA CLASS
ODM oracle/dmt/odm/rule/MiningRule JAVA CLASS
ODM oracle/dmt/odm/rule/Predicate JAVA CLASS
ODM oracle/dmt/odm/rule/TargetItem JAVA CLASS
ODM oracle/dmt/odm/task/MiningTask JAVA CLASS
SPT MCV PROCEDURE
WKSYS WK$POST_OPTIMIZE_INDEX PROCEDURE
WKSYS WK$PRE_OPTIMIZE_INDEX PROCEDURE
WKSYS WK$USERID FUNCTION
OLAPSYS DBMS_AW_UTILITIES PACKAGE BODY
OLAPSYS CWM2_OLAP_AW_ACCESS PACKAGE BODY
WKSYS WK_QUERYAPI PACKAGE BODY
WKSYS WK_ERR PACKAGE BODY
WKSYS WK_JOB PACKAGE BODY
WKSYS WKDS_ADM PACKAGE BODY
WKSYS WK_CRW PACKAGE BODY
WKSYS WK_ADM PACKAGE BODY
WKSYS WK_UTIL PACKAGE BODY

483 rows selected

SQL>

[edersondesouzaParticipante]

Galera.

Instalei o 10GR2 e fiz um import full de uma versão 9i.

Os objetos acima, mesmo depois de recompilados permanecem inválidos.

algum DBA de plantão teria uma solução ?

At.

Ederson

[edersondesouzaParticipante]

Galera,

rodando o sql abaixo, reduziu significativamente o número de objetos inválidos.

sqlplus “/ as sysdba” @$ORACLE_HOME/rdbms/admin/utlrp.sql

OWNER OBJECT_NAME OBJECT_TYPE

---

ODM AQ$DMS_QUEUE_TABLE VIEW
OLAPSYS CWM2_OLAP_AW_ACCESS PACKAGE BODY
OLAPSYS ALL$OLAP2_AW_MAP_ATTR_USE VIEW
OLAPSYS DBMS_AW_UTILITIES PACKAGE BODY
OLAPSYS ALL$OLAP2_AW_MAP_MEAS_USE VIEW
OLAPSYS ALL$OLAP2_AW_MAP_DIM_USE VIEW
PUBLIC ALL_OLAP2_AW_MAP_ATTR_USE SYNONYM
PUBLIC ALL_OLAP2_AW_MAP_MEAS_USE SYNONYM
PUBLIC WK$SYS_ADMIN_LIST SYNONYM
PUBLIC WK$INST_LIST SYNONYM
PUBLIC ALL_OLAP2_AW_MAP_DIM_USE SYNONYM
SPT MCV PROCEDURE
WKSYS WK$POST_OPTIMIZE_INDEX PROCEDURE
WKSYS WK$PRE_OPTIMIZE_INDEX PROCEDURE
WKSYS WK_ADM PACKAGE BODY
WKSYS WK$USERID FUNCTION
WKSYS WK$SYS_ADMIN_LIST VIEW
WKSYS WK$IS_ADMIN FUNCTION
WKSYS WK_QUERYAPI PACKAGE BODY
WKSYS WK_ERR PACKAGE BODY
WKSYS WK_JOB PACKAGE BODY
WKSYS WK_UTIL PACKAGE BODY
WKSYS WKDS_ADM PACKAGE BODY
WKSYS WK_CRW PACKAGE BODY
WKSYS WK$INST_LIST VIEW

[LoadingXpParticipante]

Ederson qual o patch do Bd Oracle 10g você está usando???
Algumas releases do 10g tem muito problemas.

Atualiza ele primeiro e depois faz um upgrade do Oracle… Se ainda tiver objetos INVALID, tenta copiar o codigo SQL da geração do objeto no Oracle 9. (Antes de copiar verifica se ele tem alguma dependence com a view DBA_DEPENDENCES).

Luciano Alvarenga Maciel Pires
http://www.fulloracle.blogspot.com
lucianoalvarenga@gmail.com

[Autor]

Posts