Home » Developer & Programmer » Designer » tablespace filled !
tablespace filled ! [message #90457] Mon, 13 October 2003 18:03 Go to next message
Upperm
Messages: 95
Registered: July 2003
Member
Hello Folks :)

I've created many users for my database.

I've forced them all to create their tables into the tablespace "USERS" which contains one and only datafile named "USERS01.DBF".

This datafile "users01.dbf" of which the size is 10M (ten megabytes) wasn't created with the option AUTOEXTEND.

My Question is:

In case the datafile "users01.dbf" is full filed. What should I do to keep my database always running and accessible?

thank you for help :)
Re: tablespace filled ! [message #90458 is a reply to message #90457] Tue, 14 October 2003 03:08 Go to previous messageGo to next message
Lu Xiang
Messages: 4
Registered: October 2003
Junior Member
ALTER DATABASE
DATAFILE 'C:ORACLEORADATAORCLDRSYS01.DBF' AUTOEXTEND ON NEXT 645K

You can get it from the OEM gui tool.
Re: tablespace filled ! [message #90460 is a reply to message #90458] Tue, 14 October 2003 13:21 Go to previous messageGo to next message
Upperm
Messages: 95
Registered: July 2003
Member
Hello Xiang,

Thanks for the reply, though I perfectly know the solution you suggested.

Even if we make the datafile auto-extensible, and if we suppose that the size of the Hard Drive isn't too large (this si my case), we will be sooner in front of a tablespace full filed.
My whish then is to know other solutions that I can afford.
.. Waiting for a reply.. And always with thanks :)
Re: tablespace filled ! [message #90461 is a reply to message #90460] Wed, 15 October 2003 15:49 Go to previous message
Manish
Messages: 79
Registered: December 2000
Member
You could write a shell script which periodically logs into the database and looks for events like tablespace running out of space etc.

Manish
Previous Topic: Table sizing
Next Topic: Storage parameters
Goto Forum:
  


Current Time: Tue Mar 19 05:00:19 CDT 2024