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

Subscribe Post Reply

31769

amitpatel66

2,367

Expert 2GB

Expand|Select|Wrap|Line Numbers

  
-- Oracle 10g
 
SQL> SET LINESIZE 400000

SP2-0267: linesize option 400000 out of range (1 through 32767)

SQL>

Jun 30 '08 #2

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)

Sep 4 '13 #3

swatikumari028

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

Sep 4 '13 #4

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

Sep 4 '13 #5

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...

PHP

maximum size of a database/tablespace

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? ...

DB2 Database

Maximum Datagram size for UDP Sockets

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!

C# / C Sharp

Setting linesize and column size in MySQL 4.1.1?

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...

MySQL Database

Retrieving the index of the maximum value in a vector

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...

C / C++

Maximum upload size

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. ...

Perl

Maximum size of table is 512G??

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...

DB2 Database

Line size in MySql

by: jith87 | last post by:

How do u set the line size in MySql????? i.e equivalent to set linesize 400; in Oracle........

MySQL Database

beg needs help: find the maximum value of an array

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...

C / C++

Basic concepts of WebLogic Admin training?

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...

Oracle Database

https redirect with reverse proxy

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...

IIS / Internet Information Server

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...

General

How to layout php header location with a variable as the location?

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. ...

PHP

How to use http requests (Get function) to get variable value?

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...

Python

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

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...

General

How do I view Redshift db tables in Alteryx

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...

General

FPGA Question

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...

General

One of the easiest ways to set the background color of Excel documents in Java

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....

General

Similar topics