gajananpkini,

You need to estimate the table growth properly, and size your tablespace accordingly.

Did you consider 2 GB data file instead of 1 GB datafile?

Did you talk to the appln team about what this tablespace (tables) is being used for?

How long do you want to keep the data in those tablespace?

Tamil