IP2016 LOCAL_XE Initialization Failing with ORA-01754: a table may contain only one column of type LONG (Doc ID 2231319.1)

Last updated on FEBRUARY 09, 2017

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms


When creating the LOCAL_XE database using LocalDbSetup.exe, it fails in the clone_ddlimp.log with:

[ODBC Oracle driver][Oracle]ORA-01754: a table may contain only one column of type LONG

This is because the server database is MS SQL Server database and there are no restrictions on the number of VARCHAR(MAX) columns in a table. The custom extension table(s) have more than one VARCHAR(MAX) columns. When the clone_ddl.ctl file it created, it sets the physical data type to LONG. 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms