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;
USUARIOS
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
Referencia:
No hay comentarios:
Publicar un comentario