DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sql

  1. #1
    Join Date
    Oct 2000


    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.

    many thanx.

  2. #2
    Join Date
    Oct 2000

    Resultset of query is to large


    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.

    Kind regards,


  3. #3
    Join Date
    Oct 2000

    Red face

    got it working by reducing the arraysize to 5, however can someone tell me how to use ROWNUM, an example of the syntax. Thanx.

  4. #4
    Join Date
    Jan 2001
    As Paul has mentioned you can fetch less number of records, but if the problem still persists, run the following at the SQL prompt and trying running the query.

    SQL> set array 1

    This sets the arraysize for you and the query should work fine.
    - Mayur.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.