ORA-01792: maximum number of columns in a table or view is 1000 in Talend

[sinformasi1636539922]

hi all,

first I want to ask how to run this query (alter session set "_fix_control"='17376322:OFF';) ontalend, because I use tDBrow the result is Error

and also the query I run in talend there is an error "Maximum number of columns in a table or view is 1000"

is there any solution?

[Anonymous]

Hello,

As far as I know, Max of 1000 columns always has been in Oracle. Only thing you can do is to split the columns to multiple tables and join them. Oracle can hold only up to 255 columns in single block so there are certain consequences when a table has more columns.

There is limitation in oracle doc for 18c

https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/logical-database-limits.html#GUI...

Best regards

Sabrina

[sinformasi1636539922]

hi sabrina

thanks for the answer, I'll try it first and I'll let you know the results later

[Anonymous]

Hello,

Don't hesitate to post your issue here.

Best regards

Sabrina

[sinformasi1636539922 · Accepted solution]

I have found another way, how this query can run with the help of "Alter Session".in tDBrow we have to edit the alter session query to be

BEGIN

EXECUTE IMMEDIATE 'ALTER session SET \"_fix_control\"=''17376322:OFF'' ';

END;

this worked for me, without having to split the query

[Anonymous]

Hello,

Thanks for sharing your solution with us on community.

Best regards

Sabrina