Database Administration (MOSC)

MOSC Banner

drop tablespace ... including contents and datafiles cascade constraints; doesn't delete datafiles

edited Aug 13, 2015 8:08AM in Database Administration (MOSC) 10 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center