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

On 8 Nov 2004 05:05:15 -0800, 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

There is no "alter table" statement to do so, instead you specify it directly with the insert statement(s) on the table

insert /*+append*/ into mytab values (....);

insert /*+append*/ into mytab select * from anothertab;

• Kenneth Koenraadt