Why do you think the file will shrink? https://docs.oracle.com/cd/E17275_01/html/api_reference/C/dbdel.html doesn't mention file shrinking, anyway thats the real documentation