Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: can alter table command indicate data is placed at the end of the table or any free space

Re: can alter table command indicate data is placed at the end of the table or any free space

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Nov 2004 19:18:52 -0800
Message-ID: <1099970259.226069@yasure>


db2group88_at_yahoo.com wrote:

> in DB2, we can use "alter table" statement to Indicates whether data
> is appended to the end of the table data or placed where free space is
> available in data pages. so on oracle db 10g, do we have similar way
> to do it ? thanks

Use the APPEND hint in Oracle.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 08 2004 - 21:18:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US