Conevntional INSERT

Hi,

In Conventional Insert oracle uses cache buffer and inserts data in the cache buffer block first ,then writes the cache block to disc as part of checkpointing .

In this case is the below scenario possible :

Oracle insert new row in a table , row is inserted in the cache block , redo is generated . User commits , redo is written to redo log files and user gets no error . Checkpointing of the redo starts , inserted data in cache block is tried to be written in disc , but finds that the datafile has no free block available nor can it extend further . So write error occurs and datafile goes offline . Checkpoint is not completed ,so the online redo log can not be overwritten and database haults . But user knows