This trigger below need be created before the impdp – execution. This will avoid ORA-39405 During Import – The insane way<\/p>\n\n\n\n
Create the trigger below and replace the property according to your error. This will correct\/update the timezone – but this will work only if your imported data will not have columns with timezone property. Make your adjusts – like the owner, the table name and property values.<\/p>\n\n\n\n
CREATE OR REPLACE TRIGGER sys.create_table_trigger\n AFTER CREATE ON DATABASE\ndeclare\n sql_text varchar2(200);\nBEGIN\n IF DICTIONARY_OBJ_TYPE = 'TABLE' and ora_dict_obj_name = 'SYS_IMPORT_FULL_01' and ORA_SYSEVENT = 'CREATE' THEN\n sql_text := 'CREATE OR REPLACE TRIGGER update_timezone BEFORE INSERT OR UPDATE ON sys.SYS_IMPORT_FULL_01 ' ;\n sql_text := sql_text || ' FOR EACH ROW WHEN (new.property > 0) BEGIN ';\n sql_text := sql_text || ' if ' || ':' || 'new.property=32 then ';\n sql_text := sql_text || ' :' || 'new.property:=42;';\n sql_text := sql_text || ' end if;';\n sql_text := sql_text || ' END; ';\n execute immediate sql_text ;\n end if;\nEND;\n\n\n\n<\/code><\/pre>\n\n\n\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"This trigger below need be created before the impdp – execution. This will avoid ORA-39405 During Import – The insane way Create the trigger below and replace the property according to your error. This will correct\/update the timezone – but … Continue lendo