We are working with a database of size 46GB on Windows NT.
Our HDD is 80GB wiht 2gb Ram.

We have a Tablespace of 37 GB. It contains a Total free space is 2GB, but The maxmimum freespace is only 9mb. There are 1321 fragmentations.. Tables with the next extent of even 10mb cannot extend and shows errors while import happens. The Tablespace is Dictionary managed. The Tablespace Contains 1417 objects of two schema.

How can we defragment the Tablespace and make use of the 2GB. Will converting the Tablespace to LMT solve the problem. IF so how long(time) will it take to convert a 37gb Tablespace to LMT. If any other options are possible please provide it. All the objects are self contained in the same tablespace for both schemas.

Import And Export cannot be done on that box because of space constraint.

Thanks