martes, 14 de julio de 2009

Error tras reorganización Oracle

Después de haber hecho una reorganización de una tabla en Base de Datos aparece el error:

ORA-12091: cannot online redefine table with materialized views

Solución:

If a materialized view or a log file for a materialized view already exists for a table, an online reorganization will lead to an ORA-12091 error message. The error occurs if the online reorganization for a table is stopped improperly and you then try to restart the online reorganization. To solve the problem, you must end the interrupted reorganization using DBMS_REDEFINITION.ABORT_REDEF_TABLE. Then you must drop the table #$. You can also use the following BRSPACE command to clean up after old reorganizations:

brspace -u / -f tbreorg -t "*" -a cleanup


Publicado por en

No hay comentarios:

Publicar un comentario

Suscribirse a: Enviar comentarios (Atom)