SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can I alter a table and add freelists?

Guess2Nov 30 2007 — edited Dec 1 2007

got this off the web: http://www.remote-dba.net/oracle_10g_tuning/t_tuning_table_freelists.htm
version 10.2

here is my test case

create table x(y varchar2(10), xx int);

Table created.

alter table x freeists 5;

alter table x freeists 5
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2007

Added on Nov 30 2007

2 comments

962 views