alter database datafile 'E:\ORACLE\ORADATA\ORCL\TABLE_NAME.DBF' resize XXXM;
just make sure you have enough free space on disk to do that.
Also you dont extend tables, you extend tablespaces.
never ever do you update data dictionary tables (you cant anyway becuase they are views)
but never even try to do that




Reply With Quote