SQL> ALTER SESSION SET current_schema = sys;

Session altered.

SQL> ALTER USER bguiney ENABLE EDITIONS FORCE;

User altered.

SQL> CREATE EDITION test_edition AS CHILD OF ORA$BASE;

Edition created.

SQL> GRANT USE ON EDITION test_edition TO bguiney;

Grant succeeded.

SQL> ALTER SESSION SET current_schema = bguiney;

Session altered.

SQL> ALTER SESSION SET edition = test_edition;

Session altered.

SQL> CREATE TABLE test_drop_col(col1 VARCHAR2(10), col2 NUMBER);

Table created.

SQL> CREATE OR REPLACE EDITIONING VIEW test_drop_col_vw AS SELECT col1, col2 FROM test_drop_col;

View created.

SQL> CREATE OR REPLACE TRIGGER test_drop_col_trg
BEFORE INSERT OR UPDATE ON test_drop_col_vw
FOR EACH ROW
BEGIN
  :NEW.col1 := 'TEST';
END;
/  2    3    4    5    6    7

Trigger created.

SQL> SELECT object_name, status FROM dba_invalid_objects WHERE owner='BGUINEY';

no rows selected

SQL> ALTER TABLE test_drop_col ADD (col3 NUMBER);

Table altered.

SQL> SELECT object_name, status FROM dba_invalid_objects WHERE owner='BGUINEY';

no rows selected

SQL> ALTER TABLE test_drop_col DROP COLUMN col3;

Table altered.

SQL> SELECT object_name, status FROM dba_invalid_objects WHERE owner='BGUINEY';

OBJECT_NAME                                                                                                                      STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
TEST_DROP_COL_TRG                                                                                                                INVALID

SQL>