IP2016 LOCAL_XE Initialization Failing with ORA-01754: a table may contain only one column of type LONG
Last updated on FEBRUARY 09, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms