Can you make a datafile auto extendible. if yes, how
Answers
Answered by
4
That depends on what database system you are using, so the answer may be “yes” or “no”. It is possible in Informix, for example. I cannot speak authoritatively about any others, but I can say that Informix is not unique in this capability.
How? In Informix once a datafile is installed in the server as what is known in Informix parlance as a “chunk” you issue an SQL API function “modify chunk extendable” passing the chunk “number”. Simple. The API function “modify space sp_sizes” sets that amount of space added each time an extendable chunk needs to grow.
How? In Informix once a datafile is installed in the server as what is known in Informix parlance as a “chunk” you issue an SQL API function “modify chunk extendable” passing the chunk “number”. Simple. The API function “modify space sp_sizes” sets that amount of space added each time an extendable chunk needs to grow.
Similar questions