Re: ORA-01654 Fix?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 21 Dec 2005 13:32:13 -0800
Message-ID: <1135200732.934451.291680@g44g2000cwa.googlegroups.com>

Sybrand is correct in that you will probably have to re-create the database to resize the SYSTEM tablespace in order to reclaim the file space.

I consider your problem just another example of why extendable datafiles are not a good idea. I can monitor file space utilization in a couple of minutes per database per week. Fixing a mess like this often takes midnight and weekend maintenance windows. I work enough of those anyway just to apply modifications for production enhancements.

IMHO -- Mark D Powell -- Received on Wed Dec 21 2005 - 15:32:13 CST