My Oracle Support Banner

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 01, 2019

Applies to:

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


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. 


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.