We have a database of 2000 users.
We will drop all remaining schemas, leaving only 2 end users, excluding Internal (Oracle maintained) users.
After this operation, there will be a very high reduction in database size. And we want to delete all unused datafiles first from the database and then physically from the server.
Is it possible to process it? How can we plan this operation? Can you help with exact commands?