Hi,

I have two problems:

1)I have a table with chained rows. But the table contains a LONG column. How to solve this problem? Because if there is a LONG Column, we cannot create temporary table to hold the chained rows (as the create temp as select from the chained table fails). How to remove chanined rows in case of a table having LONG columns??

2)How can I modify the storage parameter PCT_FREE for a table. I am getting the following error:

structure of TEMP:

x varchar2(10)
y varchar2(10)
z long

alter table temp storage(pct_free 20);

ORA-02143: invalid STORAGE option


PLEASE HELP as it is very urgent!

Thanks in advance for the time and patience