[ОТВЕТИТЬ]
Опции темы
26.06.2012 10:38  
Kryukov
В базе инвалиды что с ними делать прогнал по теме не помогло ...

OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_AGGREGATION_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_AWVIEWCOLS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_AWVIEWS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_CATALOGS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_CATALOG_ENTITY_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_CUBES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_CUBE_DIM_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_CUBE_MEASURES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_CUBE_MEASURE_MAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_CUBE_MEAS_DIM_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIMENSIONS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_ATTRIBUTES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_DIM_ATTR_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_HIERARCHIES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_HIERS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_DIM_HIER_LEVEL_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_LEVELS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_LEVELS_KEYMAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_DIM_LEVEL_ATTRIBUTES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_DIM_LEVEL_ATTR_MAPS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_ENTITY_DESC_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_ENTITY_EXT_PARMS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_ENTITY_PARAMETERS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_FACTTBLFCTMAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_FACTTBLKEYMAPS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_FACT_LEVEL_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_FACT_TABLE_GID
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_HIERDIMS
SYNONYM INVALID

PUBLIC.DBA_OLAP2_HIERDIM_KEYCOL_MAP
SYNONYM INVALID

PUBLIC.DBA_OLAP2_HIER_CUSTOM_SORT
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_JOIN_KEY_COLUMN_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_LEVEL_KEY_COL_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP2_LISTDIMS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP2_MR_MEASDIMVIEW
SYNONYM INVALID

PUBLIC.DBA_OLAP2_RUFCTTBLKYMAPS
SYNONYM INVALID

PUBLIC.DBA_OLAP9I1_HIER_DIMENSIONS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP9I2_HIER_DIMENSIONS
SYNONYM INVALID

PUBLIC.DBA_OLAPMR_DIM_LEVELS_KEYMAPS
SYNONYM INVALID

PUBLIC.DBA_OLAPMR_FACTTBLFCTMAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAPMR_FACTTBLKEYMAPS
SYNONYM INVALID

PUBLIC.DBA_OLAP_CATALOGS
SYNONYM INVALID

PUBLIC.DBA_OLAP_CATALOG_ENTITY_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_COLUMNS
SYNONYM INVALID

PUBLIC.DBA_OLAP_CUBES
SYNONYM INVALID

PUBLIC.DBA_OLAP_CUBE_DIM_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_CUBE_MEASURES
SYNONYM INVALID

PUBLIC.DBA_OLAP_CUBE_MEASURE_DIM_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP_CUBE_MEASURE_MAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_DESCRIPTORS
SYNONYM INVALID

PUBLIC.DBA_OLAP_DESCRIPTOR_TYPES
SYNONYM INVALID

PUBLIC.DBA_OLAP_DIMENSIONS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_DIM_ATTRIBUTES
SYNONYM INVALID

PUBLIC.DBA_OLAP_DIM_ATTR_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP_DIM_HIERARCHIES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_DIM_HIER_LEVEL_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP_DIM_LEVELS
SYNONYM INVALID

PUBLIC.DBA_OLAP_DIM_LEVEL_ATTRIBUTES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_DIM_LEVEL_ATTR_MAPS
SYNONYM INVALID

PUBLIC.DBA_OLAP_ENTITY_DESC_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP_FACT_LEVEL_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_FOREIGN_KEYS
SYNONYM INVALID

PUBLIC.DBA_OLAP_FUNCTIONS
SYNONYM INVALID

PUBLIC.DBA_OLAP_FUNCTION_ARGUMENTS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_FUNCTION_PARAMETERS
SYNONYM INVALID

PUBLIC.DBA_OLAP_FUNCTION_USAGES
SYNONYM INVALID

PUBLIC.DBA_OLAP_JOIN_KEY_COLUMN_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_KEYS
SYNONYM INVALID

PUBLIC.DBA_OLAP_KEY_COLUMN_USES
SYNONYM INVALID

PUBLIC.DBA_OLAP_LEVEL_KEY_COLUMN_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBA_OLAP_TABLES
SYNONYM INVALID

PUBLIC.DBMS_AWM
SYNONYM INVALID

PUBLIC.DBMS_AW_UTILITIES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.DBMS_ODM
SYNONYM INVALID

PUBLIC.MGMT$ALERT_CURRENT
SYNONYM INVALID

PUBLIC.MGMT$ALERT_HISTORY
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$AVAILABILITY_CURRENT
SYNONYM INVALID

PUBLIC.MGMT$AVAILABILITY_HISTORY
SYNONYM INVALID

PUBLIC.MGMT$BLACKOUT_HISTORY
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$CLUSTER_INTERCONNECTS
SYNONYM INVALID

PUBLIC.MGMT$CSA_CLIENTS
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_COOKIES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$CSA_HOST_CPUS
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_CUSTOM
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_IOCARDS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$CSA_HOST_NICS
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_OS_COMPONENTS
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_OS_FILESYSTEMS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$CSA_HOST_OS_PROPERTIES
SYNONYM INVALID

PUBLIC.MGMT$CSA_HOST_SW
SYNONYM INVALID

PUBLIC.MGMT$DB_CONTROLFILES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DB_DATAFILES
SYNONYM INVALID

PUBLIC.MGMT$DB_DBNINSTANCEINFO
SYNONYM INVALID

PUBLIC.MGMT$DB_FEATUREUSAGE
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DB_INIT_PARAMS
SYNONYM INVALID

PUBLIC.MGMT$DB_LICENSE
SYNONYM INVALID

PUBLIC.MGMT$DB_REDOLOGS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DB_ROLLBACK_SEGS
SYNONYM INVALID

PUBLIC.MGMT$DB_SGA
SYNONYM INVALID

PUBLIC.MGMT$DB_TABLESPACES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_COMPONENTS
SYNONYM INVALID

PUBLIC.MGMT$DELTA_COMPONENT_DETAILS
SYNONYM INVALID

PUBLIC.MGMT$DELTA_FS_MOUNT
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_HARDWARE
SYNONYM INVALID

PUBLIC.MGMT$DELTA_HOST_CONFIG
SYNONYM INVALID

PUBLIC.MGMT$DELTA_INIT
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_ONEOFF_PATCHES
SYNONYM INVALID

PUBLIC.MGMT$DELTA_ORACLE_HOME
SYNONYM INVALID

PUBLIC.MGMT$DELTA_OS_COMPONENTS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_OS_COMP_DETAILS
SYNONYM INVALID

PUBLIC.MGMT$DELTA_OS_KERNEL_PARAMS
SYNONYM INVALID

PUBLIC.MGMT$DELTA_PATCHSETS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_PATCHSET_DETAILS
SYNONYM INVALID

PUBLIC.MGMT$DELTA_TABLESPACES
SYNONYM INVALID

PUBLIC.MGMT$DELTA_VENDOR_SW
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$DELTA_VIEW
SYNONYM INVALID

PUBLIC.MGMT$DELTA_VIEW_DETAILS
SYNONYM INVALID

PUBLIC.MGMT$ECM_CURRENT_SNAPSHOTS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$ECM_VISIBLE_SNAPSHOTS
SYNONYM INVALID

PUBLIC.MGMT$GROUP_DERIVED_MEMBERSHIPS
SYNONYM INVALID

PUBLIC.MGMT$GROUP_FLAT_MEMBERSHIPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$GROUP_MEMBERS
SYNONYM INVALID

PUBLIC.MGMT$HA_BACKUP
SYNONYM INVALID

PUBLIC.MGMT$HA_FILES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$HA_INFO
SYNONYM INVALID

PUBLIC.MGMT$HA_INIT_PARAMS
SYNONYM INVALID

PUBLIC.MGMT$HA_MTTR
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$HA_RMAN_CONFIG
SYNONYM INVALID

PUBLIC.MGMT$HW_NIC
SYNONYM INVALID

PUBLIC.MGMT$INTERFACE_STATS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$METRIC_COLLECTION
SYNONYM INVALID

PUBLIC.MGMT$METRIC_CURRENT
SYNONYM INVALID

PUBLIC.MGMT$METRIC_DAILY
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$METRIC_DETAILS
SYNONYM INVALID

PUBLIC.MGMT$METRIC_HOURLY
SYNONYM INVALID

PUBLIC.MGMT$MISSING_TARGETS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$MISSING_TARGETS_IN_GROUPS
SYNONYM INVALID

PUBLIC.MGMT$OS_COMPONENTS
SYNONYM INVALID

PUBLIC.MGMT$OS_FS_MOUNT
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$OS_HW_SUMMARY
SYNONYM INVALID

PUBLIC.MGMT$OS_KERNEL_PARAMS
SYNONYM INVALID

PUBLIC.MGMT$OS_PATCHES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$OS_SUMMARY
SYNONYM INVALID

PUBLIC.MGMT$RACDB_INTERCONNECTS
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_COMPONENTS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$SOFTWARE_COMPONENT_ONEOFF
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_COMP_PATCHSET
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_DEPENDENCIES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$SOFTWARE_HOMES
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_ONEOFF_PATCHES
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_OTHERS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$SOFTWARE_PATCHES_IN_HOMES
SYNONYM INVALID

PUBLIC.MGMT$SOFTWARE_PATCHSETS
SYNONYM INVALID

PUBLIC.MGMT$TARGET
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$TARGET_COMPONENTS
SYNONYM INVALID

PUBLIC.MGMT$TARGET_COMPOSITE
SYNONYM INVALID

PUBLIC.MGMT$TARGET_PROPERTIES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MGMT$TARGET_TYPE
SYNONYM INVALID

PUBLIC.MGMT_TARGET_BLACKOUTS
SYNONYM INVALID

PUBLIC.MRV_OLAP1_FACTTBLFCTMAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP1_FACTTBLKEYMAPS
SYNONYM INVALID

PUBLIC.MRV_OLAP1_POP_CUBES
SYNONYM INVALID

PUBLIC.MRV_OLAP1_POP_DIMENSIONS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AGGREGATION_USES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AWS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AWVIEWCOLS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AWVIEWS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_ATTRIBUTES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_CUBES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AW_CUBE_AGG_LVL
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_CUBE_AGG_MEAS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_CUBE_AGG_OP
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AW_CUBE_AGG_SPECS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_CUBE_DIM_USES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_CUBE_MEASURES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AW_DIMENSIONS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_DIM_HIER_LVL_ORD
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_DIM_LEVELS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AW_MAP_ATTR_USE
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_MAP_DIM_USE
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_MAP_MEAS_USE
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_AW_PHYS_OBJ
SYNONYM INVALID

PUBLIC.MRV_OLAP2_AW_PHYS_OBJ_PROP
SYNONYM INVALID

PUBLIC.MRV_OLAP2_CATALOGS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_CATALOG_ENTITY_USES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_CUBE_MEASURES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_DESCRIPTORS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_DIM_ATTRIBUTES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_DIM_HIERS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_DIM_HIER_LEVEL_USES
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_DIM_LEVEL_ATTR_MAPS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_ENTITY_DESC_USES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_ENTITY_EXT_PARMS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_ENTITY_PARAMETERS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_FACTTBLFCTMAPS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_FACTTBLKEYMAPS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_HIERDIMS
SYNONYM INVALID

PUBLIC.MRV_OLAP2_HIERDIMS_CC
SYNONYM INVALID

PUBLIC.MRV_OLAP2_HIERDIM_KEYCOL_MAP
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_HIER_CUSTOM_SORT
SYNONYM INVALID

PUBLIC.MRV_OLAP2_JOIN_KEY_COL_USES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_LISTDIMS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP2_LISTDIMS_CC
SYNONYM INVALID

PUBLIC.MRV_OLAP2_POP_CUBES
SYNONYM INVALID

PUBLIC.MRV_OLAP2_POP_DIMENSIONS
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.MRV_OLAP_CWM1_AGGOP
SYNONYM INVALID

PUBLIC.MRV_OLAP_CWM1_AGGORD
SYNONYM INVALID

PUBLIC.OLAPDIMVIEW
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.OLAPFACTVIEW
SYNONYM INVALID

PUBLIC.OLAP_SYS_AW_ACCESS_CUBE_VIEW
SYNONYM INVALID

PUBLIC.OLAP_SYS_AW_ACCESS_DIM_VIEW
SYNONYM INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------
OBJECT_TYPE STATUS
------------------- -------
PUBLIC.OLAP_SYS_AW_ENABLE_ACCESS_VIEW
SYNONYM INVALID

PUBLIC.SETEMVIEWUSERCONTEXT
SYNONYM INVALID


356 rows selected.
 
26.06.2012 10:46  
OlegON
В базе, откуда делал импорт, больше мусора, чем в этой...
Я обычно ленюсь разбираться, смотрю, если некритично - прогоняю скриптик:
Цитата:
begin
for c in (select OBJECT_NAME from dba_objects where owner!='SYS' and object_type = 'SYNONYM' and status='INVALID')
Loop
begin
execute immediate
'drop public synonym ' || c.object_name;
end;
end loop;
end;
/
 
26.06.2012 10:50  
Kryukov
Цитата:
Сообщение от OlegON
В базе, откуда делал импорт, больше мусора, чем в этой...
Я обычно ленюсь разбираться, смотрю, если некритично - прогоняю скриптик:
Это в базе с которой экспортировал ?
 
26.06.2012 10:52  
Kryukov
PL/SQL procedure successfully completed.
SQL>

за 2 секунды
 
27.06.2012 18:53  
[3com]K
При переходе с 9-ки на 10-ку десять SYNONYM оказались в статусе "INVALID". @?/rdbms/admin/utlrp и все стало на свои места.
 
27.06.2012 19:05  
OlegON
Цитата:
Сообщение от [3com]K
При переходе с 9-ки на 10-ку десять SYNONYM оказались в статусе "INVALID". @?/rdbms/admin/utlrp и все стало на свои места.
Это если опции выставленные в старой и в новой БД совпадают.
 
10.07.2012 14:22  
Kryukov
SQL> select owner||'.'||object_name,object_type, status from dba_objects where status='INVALID' orde
r by 1;

OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SYS._ALL_REPCOLUMN_GROUP
VIEW INVALID

SYS._ALL_REPCONFLICT
VIEW INVALID

SYS._ALL_REPPARAMETER_COLUMN
VIEW INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SYS._ALL_REPRESOLUTION
VIEW INVALID

WMSYS.LTDDL
PACKAGE BODY INVALID

WMSYS.LTRIC
PACKAGE BODY INVALID


OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
WMSYS.LT_EXPORT_PKG
PACKAGE BODY INVALID

WMSYS.UD_TRIGS
PACKAGE BODY INVALID

WMSYS.WM_DDL_UTIL
PACKAGE BODY INVALID


9 rows selected.

SQL>
 
10.07.2012 14:27  
OlegON
Цитата:
@?/rdbms/admin/utlrp
пробовал уже?
 
10.07.2012 14:29  
Kryukov
Цитата:
Сообщение от OlegON
пробовал уже?
да по нулям
 
10.07.2012 14:32  
Kryukov
SQL> connect sys/qqq@dbcentr
Connected.
SQL>
SQL> @utlrp.sql;

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2012-07-10 14:31:32

DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.


TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2012-07-10 14:31:34


PL/SQL procedure successfully completed.

DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
0


PL/SQL procedure successfully completed.

SQL>
 
 


Опции темы



Часовой пояс GMT +3, время: 17:33.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.