martes, 22 de mayo de 2018

ORA-38802: ORA-02063: Edition doesn't exists, having only one edition through database link

I only have one edition

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.

 

No hay comentarios.:

Publicar un comentario