Database Administration (MOSC)

MOSC Banner

Drop pluggable database not remove datafiles

Hello, 


In my daily development flow we're cloning PDB.


From time to time we are unable to clone db cuz errors:


ORA-27040: file create error, unable to create file


[2023-12-13T21:34:34.405Z] OSD-04002: unable to open file


[2023-12-13T21:34:34.405Z] O/S-Error: (OS 5) Access is denied.


What we do


Set all data files to offline by:

ALTER DATABASE DATAFILE 'db.DBF' OFFLINE FOR DROP

and next drop db by

DROP PLUGGABLE DATABASE DB INCLUDING DATAFILES;


Unfortunately this command does not remove files and these files are still used by OracleServices ( I have to manually restart service )


I do not see these files in any oracle dictionary

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