472,353 Members | 2,195 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Maximum size of Linesize

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 31769
2,367 Expert 2GB
Expand|Select|Wrap|Line Numbers
  2. -- Oracle 10g
  4. SQL> SET LINESIZE 400000
  5. SP2-0267: linesize option 400000 out of range (1 through 32767)
  6. SQL>
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

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...
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? ...
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!
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...
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...
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. ...
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...
by: jith87 | last post by:
How do u set the line size in MySql????? i.e equivalent to set linesize 400; in Oracle........
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...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....

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.