jueves, 3 de septiembre de 2009
RZ20: ALERTS for LogonLoadQuality 6
Si el sistema en el que sale la alerta está compuesto únicamente de un único sistema SAP se puede ignorar la alerta (nota 962209) y desactivarla.
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:
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