Oracle Database Discussions

Hi

I was trying to shrink table to reset the high water mark but some unknown reason it failed.

Please help me


SQL> declare
stmt varchar2(100);
cursor cur is
select object_name from user_objects where substr(object_name,1,1)='A'
and object_type='TABLE';
begin
for i in cur loop
stmt :='alter table '||i.object_name ||' shrink space';
execute immediate stmt;
end loop;
END;
/
declare
*
ERROR at line 1:
ORA-10631: SHRINK clause should not be specified for this object
ORA-06512: at line 9


Regards

Jewel