Maximum size of Linesize

[orajit]

I am using Oracle 10g

Could you please tell me maximum linesize to be set in Oracle.

I have set upto 10000 ..could u please tell me the maximum linesize.

Thanks in advance ,

[amitpatel66]

[code=oracle]

-- Oracle 10g

SQL> SET LINESIZE 400000
SP2-0267: linesize option 400000 out of range (1 through 32767)
SQL>

[/code]

[swatikumari028]

SQL> set linesize 40000
SP2-0267: linesize option 40000 out of range (1 through 32767)
SQL> set pagesize 100000
SP2-0267: pagesize option 100000 out of range (0 through 50000)

[swatikumari028]

How can i check the default linesize and pagesize in Oracle?

[swatikumari028]

After some research, i got to know how to find the default pagesize and linesize.

SQL> show linesize
linesize 80
SQL> show pagesize
pagesize 14