Re: ORA-1652 Error during data migration

# John, remember that Oracle also uses temp segments when it creates and extends objects.  The segment extent is a temp segment until such time as the rdbms dictionary is updated to make the extent permanent.  So the error can have nothing to do with true temporary segments.

Thanks Mark ... probably been 10 years or more since I saw a tablespace actually fill up ... not a believer in taking 1652's on the chin.

Some of us are kind of overly pro active on space management ... easier to do for some than others depending on how many database instances one is supporting and the mix of what kind of database instances they are. Received on Wed Jun 20 2012 - 14:09:51 CDT