tags:

views:

15

answers:

1

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