select using database link returning only 26 characters of a column
SQL: select object_name from dba_objects@dblink. The resulting rows only returns 26 characters.
I compared parameters between the databases (they are both a clone of production). I found nothing significant.
What could be causing this?
** Using db link
select object_name from user_objects@dblink where object_name like '%%BUILDING_ACQU%';
OBJECT_NAME
--------------------------------------------------------------------------------XTEST_BUILDING_ACQUISITION
FXTEST_BUILDING_ACQUISITION
MLOG$_XTEST_BUILDING_ACQUI
** No db link
select object_name from dba_objects where object_name like '%BUILDING_ACQU%'
OBJECT_NAME
--------------------------------------------------------------------------------
XTEST_BUILDING_ACQUISITION
XTEST_BUILDING_ACQUISITION
MLOG$_XTEST_BUILDING_ACQUISITION
Thank you