change postgreSQL database to oracle database in confluence

SherryX

Does anyone has experience for changing postgreSQL to oracle database for confluence?

I exported .xml file in confluence with postgreSQL database and imported to the same version confluence but with empty database (oracle), the import failed with error:

Caused by: java.sql.SQLException: ORA-12899: value too large for column "CONFUSER"."ATTACHMENTS"."ATTACHMENT_COMMENT" (actual: 259, maximum: 255)

I checked the data in postgreSQL database, the comment do have 255 characters, but why it became 259 characters in Oracle?

I ran the following SQL and returned is UTF8:

SELECT pg_encoding_to_char(encoding) FROM pg_database WHERE datname = 'confluence';

The new oracle database is using UTF8 encoding.

Anyone can help? Thanks

MJ

It is possible that certain special characters in the comment take up more than 1 value, causing the total value to go over the maximum of 255. Please have a look at this page to see if it contains any useful information for you.