Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: What is an overflow segment?
Try this :
alter table <table_name> add overflow tablespace <overflow tablespace name>;
A little note on overflow :
The structure of index organized tables is like a btree index.
If the row size exceeds a specified threshold (PCTTHRESHOLD - specifies
the percentage of space reserved in the index block for a row), then that
row
is split at a column boundary into a head piece and a tail piece.
The head piece is stored in the index segment and the tail piece is stored
in
the overflow segment specified by the OVERFLOW clause. The index segment has
a
pointer to the tail piece segment (much like a chained row)
HTH,
Ranga Chakravarthi
"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message
news:a8n4otknhl4l214ab9funvpdbo5ni2o8m9_at_4ax.com...
> Dear all,
>
> When we are in the process of installing Axapta (an ERP from Europe),
> we encounter the following error message (with explanation from the
> doc):
>
> "ORA-01429 Index-Organized Table: no data segment to store overflow
> row-pieces
>
> Cause: No overflow segment defined.
>
> Action: Add overflow segment."
>
> The problem is I don't know anything about an overflow segment,
> although I did learn IOT before. I checked Kevin Loney, Jason Couchman
> and Noel Yuhanna books, no overflow segment is mentioned (sorry
> Jonathan, don't have your book yet). Although there are some material
> in the doc and metalink, but I still cannot figuer out a basic idea
> about it. I need straight and basic definition about what an overflow
> segment is. Anyone helps me out? Thanks in advance.
>
> Dino
>
>
Received on Tue Aug 21 2001 - 09:51:52 CDT