My Oracle Support Banner

Drop Tablespace On NFS Still Holding Data Files On OS Level (Doc ID 1348699.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.0.6.0 to 11.2.0.2 [Release 8.0.6 to 11.2]
Information in this document applies to any platform.
Affected Database: Generic (All Databases)



Symptoms

After dropping a tablespace and corresponding datafiles on located on a Network File System (NFS), you find that the OS is still holding the data-files.



The OS is still holding the data-files:

-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfs77DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfs87DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfs97DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfsA7DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfsB7DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfsC7DB1
-rw-r----- 1 oracle oinstall 8388616192 Aug 3 23:29 .nfsD7DB1
-rw-r----- 1 oracle oinstall 6291464192 Aug 3 23:29 .nfsE7DB1
-rw-r----- 1 oracle oinstall 6291464192 Aug 3 23:29 .nfsF7DB1
-rw-r----- 1 oracle oinstall 6291464192 Aug 3 23:29 .nfs08DB1

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.