Oracle Database Discussions

Hello,

I have an Oracle DB Version 11.2.0.4.0. My Problem is that the same fields are handled different in Views and MViews.

e.g. I have the following column:

The View and the MView get their data from the same source via a DB-Link.

create materialized view T_Server as select * from fachcmdb.server@cmdb;

create or replace force view V_Server as select * from fachcmdb.server@cmdb;

But the content in this column looks different.

In the MView: '739PNV392Q2U29                            '

In the View: '5BVKN3ZNLGH5MT'

So I have a lot of empty spaces in the MView but I don't know why.

If it helps, my DB has the following NLS-Settings:

Can you tell me what's the problem?