473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Maximum size of Linesize

75
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 ,
Jun 30 '08 #1
4 32142
amitpatel66
2,367 Expert 2GB
Expand|Select|Wrap|Line Numbers
  1.  
  2. -- Oracle 10g
  3.  
  4. SQL> SET LINESIZE 400000
  5. SP2-0267: linesize option 400000 out of range (1 through 32767)
  6. SQL>
  7.  
  8.  
Jun 30 '08 #2
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)
Sep 4 '13 #3
How can i check the default linesize and pagesize in Oracle?
Sep 4 '13 #4
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
Sep 4 '13 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: chotiwallah | last post by:
there seems to be a maximum size (in px) for images created with imagecreatetruecolor (somewhere between 4000 px and 4500 px). if the image is bigger than that size, the browser doesn't display it...
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
4
by: Gregory Hassett | last post by:
Hello, Does anyone know how to get the maximum size of a datagram for a UDP Socket created via .NET's System.Net.Sockets.Socket class? Thanks!
0
by: Keith Lee | last post by:
All: In Oracle, you can set the iinesie and column size so the screen output looks nice and uniform. What are the equivalent commands in Mysql 4.1.1? Thank you. Keith
3
by: Madmartigan | last post by:
Hello I have the following task but am battling with the final output. How do I keep two different vectors in sync and how would I retrieve the index for the maximum value of one of the vectors??...
2
by: skyy | last post by:
Hi.. i am doing some uploading of files using CGI with perl script.. the $CGI::POST_MAX is used to limit the maximum size of the upload file. Did anyone know what is the maximum size that i can...
2
by: Woody Ling | last post by:
I am now using db2 v8.2 64bits without DPF. I want to create a very large table which is about 1000G and the record length is suitable for 32K page size. I find in the manual that the maximum size...
1
by: jith87 | last post by:
How do u set the line size in MySql????? i.e equivalent to set linesize 400; in Oracle........
2
choke
by: choke | last post by:
I need to write a function in devc++ that creates an array of n integers, each element is equal to n*n+i*i-n*i where i is from 0 to n-1 as the array index. Within the same function I need to find...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.