Hi all,
Oracle 81730/NT.
Example: I took export of XYZ schema which belongs to XYZ tablespace. That time, free space in XYZ was 50M. XYZ tablespace size is 100M. Then, I dropped all the objects and coalesced XYZ tablespace. Now, it showed free space of 100M.
Then, I imported the XYZ schema back. In the middle of import, I started getting errors that unable to allocate next extent, unable to allocate initial extent. Then I checked the free space left in XYZ. It was showing as zero.
Howcome, there is a free space problem when I am importing the same amount of data back and there was actually free space before I dropped all the objects from XYZ table space.
Pl. note here that I took export with COMPRESS=N so that is not the problem.
Pl. help me understand.
Thanks in Adv.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart