| tablespace filled ! [message #90457] |
Mon, 13 October 2003 18:03  |
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 #90460 is a reply to message #90458] |
Tue, 14 October 2003 13:21  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
