SQL Language (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center