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.