I'm trying to run an SQL but can't, get error message - use set command to reduce ARRAYSIZE or increase MAXDATA. Can someone tell me about ARRAYSIZE and MAXDATA, the syntax and how I can get the SQL to run.
The error you get indicates that the number of rows or the number of columns that will be returned are to big. You can try to decrease the ARRAYSIZE and increase MAXDATA, but you can also select less rows/columns. (ROWNUM < 100).
I think the last solution is the best since it is hard to give correct figures for ARRAYSIZE and MAXDATA bevause this depends on the resulstset of your query.
This problem is related to SQL*PLUS. If you have any other query tool (TOAD, SQL commandor) use that instead of SQL*PLUS.