i have a table "DEPT" , let me know how to increase the size of a table.
+1
A:
Are you talking about increasing the size of the TableSpace?
Here is the command for that
alter database datafile '<full_file_name>' resize <size>M;
example
ALTER DATABASE
DATAFILE '/u01/oradata/userdata01.dbf'
RESIZE 500M;
SQLMenace
2010-08-10 20:08:26