Database Administration (MOSC)

MOSC Banner

11g to 12c migration issue, view columns changed from char to byte semantics

edited Jul 6, 2016 5:04AM in Database Administration (MOSC) 7 commentsAnswered

Hi All,

11g to 12c   migration issue, view columns changed from char to byte semantics.

NLS and semantics(BYTE) are same for both the 11g and 12c DBs. but for few columns it shows byte semantics in the 12c database. Please let me know if anyone faced this issue.

For example:

col1 is number

create view t1( col1 ) as to_char(col1)  from table1.

In source:

Above statement in source producing    col1   - varchar2(10 char)     -  11g

Above statement in target producing      col1  = varchar2(10 byte)   - 12c

I checked all NLS_database parameters all seems same. Let me know If I am missing anything.

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