[ODBC Oracle Driver][Oracle]ORA-01792: Maximum Number Of Columns In A Table Or View Is 1000

(Doc ID 2241178.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

On : 15.9 [IP2015] version, Configuration - Dev Env

When attempting to extract Local DB,the following error occurs.

ERROR
-----------------------
DBCLog DBCLogError 1 00000002589800a8:0 2017-02-06 17:40:00 [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
SQLDBUtilityLog SQLDBUtilityLog 3 00000002589800a8:0 2017-02-06 17:40:00
SQLDBUtilityLog SQLDBUtilityLog 3 00000002589800a8:0 2017-02-06 17:40:00 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. When Customer was trying to extract Local DB occur Error :
DBCLog DBCLogError 1 00000002589800a8:0 2017-02-06 17:40:00 [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000
SQLDBUtilityLog SQLDBUtilityLog 3 00000002589800a8:0 2017-02-06 17:40:00
SQLDBUtilityLog SQLDBUtilityLog 3 00000002589800a8:0 2017-02-06 17:40:00 S1000: [tp][ODBC Oracle driver][Oracle]ORA-01792: maximum number of columns in a table or view is 1000

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