rajendra_thanekar

 Profile Answers by rajendra_thanekar 

• Jun 25th, 2008

 

hi,

We can resize the datafiles which in turn resize the tablespace for which the datafile belongs. The command is

alter database datafile '<datafile_name>'  resize(size)M;

By this command the datafile size will increase and intrun the tablespace size.

We can add the datafiles to the tablespace to increase the size of the tablespace. The command is

alter tablespace <tablespace_name> add datafile <datafile_name>' size(size)m;

nafees

 Profile Answers by nafees 

• Jul 22nd, 2008

 

Hi all,

Yes i agree with the answer but resize in the sense,the size should also get decrease.

we can decrease even the size of the datafile but the condition is the datafile should be empty.