I am new to Oracle. I have dropped some users from my database using:
DROP USER username cascade;
The issue is that the
.dbf file still exists in the
$ORACLE_HOME/dbs/oradata/ directory, which is creating disk space issues.
Can I remove the unused file directly or by some other processes? Also the size of the
.trc file has increased to 16 GB. How can I clean that up?
I can delete these file directly but not sure that it may cause any start up or configuration issue, which I don't want.
Simply my concern is to get rid of disk space issue from the above unwanted files.