miércoles, 28 de marzo de 2018

After renaming database ORA-00604: error occurred at recursive SQL level 2

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-25153: Temporary Tablespace is Empty

You have to disable database triggers, before renaming, or after recreating the database.

SHUTDOWN IMMEDIATE
 STARTUP UPGRADE ;

SELECT 'ALTER TRIGGER '||OWNER||'.'||TRIGGER_NAME||' DISABLE;' FROM DBA_TRIGGERS WHERE base_object_type LIKE '%DATABASE%';

No hay comentarios.:

Publicar un comentario