Tell me more ×  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.
share|improve this question add comment  migrated from Nov 20
'12 at 7:45  This question came from our site for professional
and enthusiast programmers.  1 Answer  Datafiles are allocated
to tablespaces, not users. Dropping the users will remove the
tables etc. from the tablespace, but the underlying storage is
not affected.  Don't delete the dbf files from the filesystem
directly, you'll get your database into a mess. To re