drop tablespace ... including contents and datafiles cascade constraints; doesn't delete datafiles
I'm trying to completely wipe out every trace of a user (or two users) from an instance including the .DBF files in \app\me\oradata\orcl
and when executing the following script, the datafiles are still there in that directory, leading to a conflict when I run the subsequent install script
that tries to crerate these datafiles.
drop user exabsp cascade; drop user sysadm cascade ; alter tablespace exabsp_data offline; drop tablespace exabsp_data including contents and datafiles cascade constraints; drop tablespace exbsp_temp; commit;
Note below: both users (exabsp and sysadm) are altered to the default tablespace exabsp_data and temp tablespace exabsp_temp.