Geek Answers Handbook

Why doesn't Oracle DROP USER CASCADE delete all deleted user data from disk?

I need to eliminate all residuals of specific users from the Oracle 11g R2 database. This means not only deleting users one by one, but also deleting all objects associated with that user, in addition to all physical remnants of the disk, such as files .dbf.

I read several articles offering syntax for this, and settled on the following series of two lines for each user:

DROP USER <username> CASCADE;
DROP TABLESPACE <username> INCLUDING CONTENTS AND DATAFILES;

Then I typed SELECT USERNAME, DEFAULT_TABLESPACE FROM DBA_USERS;and confirmed that USER with a specific username was not included in the results.

But I also have a folder containing the files .dbf, and I notice that the files are not deleted, although the Oracle SQL Developer interface tells me that both of these two commands completed successfully. .dbf

What specific syntax or other actions should be taken to remove EACH user remainder and associated schema, etc. from an Oracle 11g R2 database?

IDENTIFICATION:

After reading the @EliasGarcia approach, I tried my first command select tablespace_name from dba_data_files where file_name = 'file_including_path'for the same username that was used in previous commands in OP. But this query did not give any results, because the tablespace was deleted by the two commands shown above in my OP.

, , , - , OP- @EliasGarcia? , - DROP USER username CASCADE INCLUDING CONTENTS AND DATAFILES;

.dbf .

+4
1

, . .. , .

dbf , . , , , :

select tablespace_name
from   dba_data_files
where  file_name = <file name with full path>;

(), :

drop tablespace <tablespace_name> including contents and datafiles;

, , , . , :

select * from dba_segments
where  tablespace_name = <tablespace to drop>;

-, , .

+5

More articles:


All Articles