Re: max # of columns in the table (again!)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 15 Feb 2003 17:35:16 -0000
Message-ID: <b2lton$hro$1$8300dec7@news.demon.co.uk>

Good test.

Alternatively, you could create the table, insert one row, then dump the block. This would show you the four row pieces recorded in the block.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


dias wrote in message
<55a68b47.0302150246.3fbd5c04_at_posting.google.com>...


>Hi,

>

>I have the answer ... whith a small test

>It's still the case in 9i.

>The stats "table fetch continued row" are incremented when a select

is


>made on a table with more than 255 columns.

>

>Dias

>

Received on Sat Feb 15 2003 - 11:35:16 CST