PLSQL_ARCHIVE Missing from Generation Script
DenisJCilliers
Posts: 24 New member
When running the generated script for a schema compare with a blank schema
CREATE SEQUENCE dev.seq_wt_wkshop_tt_cancel MINVALUE 0 NOCACHE; ...This is the first line of the gene script and I get the following error
4 ORA-04088: error during execution of trigger 'DEV.PLSQL_ARCHIVER_TRG' ORA-00604: error occurred at recursive SQL level 1 ORA-06550: line 4, column 5: PLS-00201: identifier 'PLSQL_ARCHIVER.ARCHIVE_VERSION' must be declared ORA-06550: line 4, column 5:
Why is the PLSQL_ARCHIVE table missing from the script?
Answers
https://technology.amis.nl/it/plsql-source-code-control-inside-the-database-after-compile-trigger-for-automatic-archiving/
I will have to figure it out this side