Page size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Page size

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    page size

    Hi folks,

    When i query a big table in server manager, i am not able to see the top portion of the table. Is there any way to set the page size in server manager; why doesn't this set command work in svrmgr;
    and again could anybody tell me how to do it in SQLPLUS.

    Regards
    sonia

  2. #2
    Join Date
    Dec 2001
    Posts
    221
    svrmgrl is the utility to execute from dos prompt. so there is no need to use set command for that. simply increase the buffer size of that command window.

    for sql plus use
    set pagesize 1000 or whatever u want. either u can use the OPTION menu



    Santosh Jadhav
    8i OCP DBA

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