-
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.
-
alter database datafile 'path_name' resize 356M;
-
Use an alter tablespace add datafile followed datafile name with size u want
-
Thanks for that. My question is, will that ensure that for the next insertsions, it does not do any Fragmentation
-
Most likely there won't be frag. in the ts.
-