Re: Automatic free space managment?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Wed, 13 Nov 2002 16:27:19 GMT
Message-ID: <3DD27D67.AD451064@peasland.com>

> 1. Is there a utility in oracle 7 & 8 such as the "Automatic free space
> managment" in oracle 9.

No. There is not.

> 2. Is there a monitor in oracle that can notify me on "space related errors".

Yes. It is called Oracle Enterprise Manager (OEM). You can set up alerts to warn you of impending problems. In 9i, you can suspend transactions on some space related errors so that the DBA can fix the problem without killing the transaction. You will find this in the documentation under the header "Resumable Transactions".

HTH,
Brian Received on Wed Nov 13 2002 - 10:27:19 CST