Skip to Content
0
Former Member
Apr 15, 2014 at 06:28 AM

Move tables/data of one datafile to another datafile - oracle

1915 Views

Hi,

is it possible to move certain amt of tables/data from one datafile to another datafile of same tablespace to reduce

the size of the datafile.

one of the datafile is of size 10g . so i want to reduce the size of the datafile by moving the content to another datafile which is of size 2G.

Kindly suggest.

Regards

Yugandhar.