Yes. You could have 1000 columns of varchar2(4000) and if you filled each
to capacity then that would be larger than a data block. Or have a column
of long. The block will be chained to other blocks.
Jim
"Y" <a_at_b.c> wrote in message news:3C747214.66D81386_at_b.c...
> This make me think of one thing, does oracle allow the rowsize (no LOB and
no user
> defined type) bigger than data block?
> TIA
>
> damorgan wrote:
>
> > Only with a nested table. With heap tables (regular tables) it can not
be.
> >
> > Daniel Morgan
> >
> > Luis Nobre wrote:
> >
> > > Can anyone please explain me how a block may contain rows from more
than one table?
> > >
> > > Thanks!!
> > > LCLN
>
Received on Wed Feb 20 2002 - 23:32:05 CST
