miércoles, 24 de octubre de 2012

Importando imp and valid objects



Verificar los objetos inválidos: 

 SELECT  *   from   dba_objects  order by   owner,  object_type


SELECT *     FROM DBA_OBJECTS
   WHERE owner = 'SYS' and object_name = 'ENABLED$INDEXES' and
            object_type = 'TABLE' and rownum <=1;


  SELECT COUNT(*) "ERRORS DURING RECOMPILATION" from utl_recomp_errors;

 ALTER INDEX Esquema.indice_Name REBUILD TABLESPACE name_tbs;

USUARIOS

SELECT * from all_USERS ORDER BY USERNAME ;

SELECT *  FROM dba_users  ORDER BY 1;
SELECT username, password, external_name  FROM dba_users  ORDER BY 1;

First import the dump by excluding the indexes and later import the same dump by including the indexes as below.   




1.)  impdp system/xxxx DUMPFILE=SHAIK72_01.dmp LOGFILE=SHAIK72_imp.log remap_schema= SHAIK72:SHAIK72  exclude=indexes 

2.)  impdp system/xxxx  DUMPFILE=SHAIK72_01.dmp LOGFILE=SHAIK72_imp1.log remap_schema= SHAIK72:SHAIK72  include=indexes 




No hay comentarios: