Increase the size of Tablespace

[Kishore]

Hi
Can any one help me to increase the size of Tablespace without allowing Fragementation to happen.

Presently I have 256MB size. I want to add 100 MB. What is the best way of doing it.

My Oracle Block size is 8KB. Do I need to consider any thing else.

[Halo]

alter database datafile 'path_name' resize 356M;

[raghucharan]

Use an alter tablespace add datafile followed datafile name with size u want

[Kishore]

Thanks for that. My question is, will that ensure that for the next insertsions, it does not do any Fragmentation

[Halo]

Most likely there won't be frag. in the ts.

[Kishore]

Thanks Halo