E1: DB: How Can Customer Remove Datafiles From Oracle Database (Tablespace)?

(Doc ID 2341207.1)

Last updated on DECEMBER 19, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Goal

How to remove a datafile from a tablespace?  Customer had added a file with the incorrect extension and now needs to remove it.  The customer is using Oracle Database - Standard Edition 11.2.0.3 / Microsoft Windows x64 (64-bit) 2008 R2.  The screen shows the tablespace needs media recovery.

See Enterprise Manager screenshot below:


 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms