Since the actual problem is the following error comes when
i create the table.

ORA-01658: unable to create INITIAL extent for segment in tablespace USERS2


This error is due to fregmentation of the tablespace so
coalesce of tablespace should have worked but its not working

second option in my mind is of
1.export of the tablespace
2.drop all the tables
3.import the dmp again

since there is no table in the tablespace as we have droped them therefore there will be all free extent available in the tablespace.

when we will import it will automatically asign the new continus extents

am i right ????

ON 13-1-2001 I will attempt this option in between if u have any suggestion please do let me know

from Anuj Pathak
Hero Financial Services Ltd.