Datafile name must be specified when Creating New Tablespace using EM and OMF
(Doc ID 1990344.1)
Last updated on FEBRUARY 25, 2019
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Database is using Oracle Managed files (OMF)
When creating New tablespace and adding first datafile to EM You have to manually put the file name.
1 - From the Tablespaces page in OEM click on the button "Create"
2 - Provide a name for the tablespace, leave everything else as defaults and click on the button "Add" to add a datafile
3 - The field beside datafile name is empty
4 - Leaving all values as defaults click on the "Continue" button the following error is Received "A datafile name must be specified"
5 - Add another datafile and there is <Default> in the file name filed and second data file is named using the OMF rules.
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