Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CTAS command giving an error ORA-64203

2754189Feb 18 2016 — edited Feb 24 2016

I have 2 databases.

One database is called CREDO database which has the character set of WE8MSWIN1252. and another database called Maxi with character set AL32UTF8.

I created a dblink from CREDO to MAXI to pull some data into a view in CREDO but when I do a Create table as Select * from view. I get the above error. The error is on a column which have a clob data.

I have used the DBMS.LOB(substr) to cast the byte to 4000 Bytes in size but still having an issue. Can someone help me.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2016

Added on Feb 18 2016

#database-key-features, #globalization-support

11 comments

10,298 views