Originally posted by gajananpkini
I just wanted to know and see , that what i have done is correct ( ie by manually adding the datafile each time when the tablespace gets full) or i should have given autoextend option in the begining itself.
well let's do some mathematics, maximum size of a datafile normally is 2gb unless you enable large fs support, a tablespace can have at least 1024 datafiles, multiply 2gb and 1024 get you 2 TB, do you have a tablespace which is gonna be 2TB?

Plus mariest has already told you where to look this sort of things, how about make some effort yourself and look the doc?