Originally posted by anujpathak
in a tablespace i have a data file of 600mb where only 11 mb is used. and in same tablespace i have another data file of 200 mb which is 120 mb used
when i create a table with a storage clause of initial 400 mb it gives message that unable to create initial size though in my first data file 589 mb is unused available.
why its not creating initial size of 400mb in first data file ?
can i specify data file of a tablespace while creating a table ?
can i re create the first data file to remove the frgmentation of the data file ?