| Create Datafile Automatically [message #371746] |
Fri, 01 December 2000 09:10  |
Henry
Messages: 14
Registered: November 2000
|
Junior Member |
|
|
|
I am looking for a script that will query dba_free_space and will the automatically create a script that will add a datafile to a tablespace when the free space in a tablespace falls below a certain value.
|
|
|
|
| Re: Create Datafile Automatically [message #372337 is a reply to message #371746] |
Fri, 02 February 2001 17:38  |
Tuan Tran
Messages: 1
Registered: February 2001
|
Junior Member |
|
|
Hi, instead of creating a script to add a new datafile each time free space is low, and wasting resources in the monitoring. I think it's easier to turn on AUTOEXTEND. Thus when more tablespace is need, the database will extend the datafile to fit more information.
ALTER DATABASE DATAFILE '\DATABASE\DATAFILE' AUTOEXTEND ON
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
