Categoria: Sem categoria
Dropping redo log group thread Migrate RAC to Single
Causa Erro ao dropar redo instance migrada de Rac para Single SYS@OLTP> alter database drop logfile group 10;alter database drop logfile group 10*ERROR at line 1:ORA-01567: dropping log 10 would leave less than 2 log files for instance oltp2 (thread 2)ORA-00312: online log 10 thread 2: ‘/u01/oracle/oradata/OLTP/redo_10.log’ Consultando Group Redo / Threads Consultando as threads…
Triggers enable/disable/recreate/ddl/status
How to enable the trigger in Oracle How to disable the trigger in Oracle How to check Trigger status in Oracle How to Check Triggers TABLE_NAME How to recreate TRIGGER DDL How to enable all the trigger on a table How to list all disabled triggers How to List All Triggers in Tables