I've installed Oracel 9i and created many users in the database.
This is installed on Windows machine.
The Disk on which this is installed is totally run out of space and so I tried dropping few usrs using "drop user username cascade;" command, but no luck.
The disk is still full and the size of dbf file is no reduced.
Do you know, how to compress the dbf file size, pls let me know.
Thanks in advance.