How to Offline a PDB Datafile in NOARCHIVELOG mode CDB which is not Open in Read Write (Doc ID 2240730.1)

Last updated on MARCH 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
How to put a datafile in offline mode, when the database is running in noarchivelog mode. This would be the case if the datafile is missing.

Symptoms

Attempt to offline a datafile results in error when the database is running in NOARCHIVELOG mode and is not open in read write mode: 

 

 

Cause

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