SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer bug in exporting triggers and sequences

garbuyaJul 11 2023 — edited Jul 27 2023

I'm using version 23.1.0.097 to export DDL for database with multiple schemas as one big file and then run it as admin in another database.
All objects are exported with schema names except triggers with sequences

CREATE OR REPLACE EDITIONABLE TRIGGER schema.tgrigger 
BEFORE INSERT ON [no schema] table
FOR EACH ROW
BEGIN
   SELECT [no schema] sequence.NEXTVAL INTO :new.column FROM dual;
END;

As a result, compilation fails when compile a whole file outside each schema

As a temporary solution we have to export DDL for each schema objects into a separate file and then execute it in another database as different users