Automatic Extension for a Datafile with filesystem full
We are working on a database Oracle10g 10.2.0.4 on HP-UX 11.31 (Itanium |
PA-RISC)
We would create our database by enabling the Automatic Extension for our Datafiles
(both setting the max size limit or leaving it unlimited)
Our question is:
what happen to the database in case of file system full when any of the datafiles needs to be automatically extended?
Does the datafile being extended become corrupted or the db stop its activity?
We would create our database by enabling the Automatic Extension for our Datafiles
(both setting the max size limit or leaving it unlimited)
Our question is:
what happen to the database in case of file system full when any of the datafiles needs to be automatically extended?
Does the datafile being extended become corrupted or the db stop its activity?
Marco
0