How to change the size of a existing datafile to a new size. I really appreciate if you can provide a syntax for this. And also I want to know that what will happen if we give less size to the existing file size in this resize?
Answer by Leigh Riffel ·
You can find the syntax in the documentation (11.2 syntax). As for shrinking the size, here is what the documentation linked to says:
It is not always possible to decrease the size of a file to a specific value. It could be that the file contains data beyond the specified decreased size, in which case the database will return an error.