select * from dba_editions;
ORA$BASE YES
It is the default edition
SELECT property_value FROM database_properties WHERE property_name = 'DEFAULT_EDITION';
ORA$BASE
making a select through a database link
select * from dual@database_with_problem.world
I starting to get the error:
ORA-38802: Edition does not exists
ORA-02063:
I executed the command:
ALTER DATABASE DEFAULT EDITION = ORA$BASE;
And it get solved, magically.