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

Thread: file name where pagesize can be changed

  1. #1
    Join Date
    Dec 2000
    Posts
    8

    Question

    I'm using oracle 8i and when I run a script in the worksheetplus or sqlplus My return is only 14 rows before It lists the field names again.

    In oracle 8 the folder was call login.sql.
    I want to change the pagesize from 14 to 50 or more.
    I dont want to do just a temp fix but in the login in file I would like to change it .
    Does anyone know what the name of the file is for 8i 1.6
    thanks,
    Mark

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You can either change it for yourself only in login.sql as long as login.sql is in your $SQLPATH. Otherwise, you can change it in glogin.sql in $OH/sqlplus/admin directory.
    Jeff Hunter

  3. #3
    Join Date
    Dec 2000
    Posts
    8
    Thank you I found that file glogin.sql
    I'm new to oracle I'm in school now taking the intro to oracle sql and pl/sql for dba track.

    When I opened the file I did not see where I could change the pagesize number from 14 to something higher is the default 14. Do i need to enter in a statement telling it to change the pagesize to higher.

    this is for my computer at home I have a server set up with the enterprise edition on win2000 server.

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    This Gives you all the SQLPLUS parms and you can ask to show specific parm as shown :
    <font face=courier>
    SQL> show all
    appinfo is ON and set to "SQL*Plus"
    arraysize 15
    autocommit OFF
    autoprint OFF
    autotrace OFF
    blockterminator "." (hex 2e)
    ......
    ......
    </font>

    <font face=courier>
    SQL> show user
    USER is "SYSTEM"
    </font>

    [Edited by sreddy on 01-18-2001 at 06:11 PM]

  5. #5
    Join Date
    Dec 2000
    Posts
    8
    Ok thank you very much I got the pagesize fixed for sql plus.

    sql*plus worksheet is still set on 14 is there a different file for that one.

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