What is the environment that you are working. Win/Unix. If its win, then your datafile can be at most 2GB max. On Unix, depending on the version, the size would differ. So as a safty cap, stop your datafile growth at 2GB. One other thing is try to create the table space as locally managed and have even number of extents. This would reduce fragmentation.
Sam




Reply With Quote