Datafile name must be specified when Creating New Tablespace using EM and OMF
Last updated on APRIL 03, 2015
Applies to:Enterprise Manager for Oracle Database - Version 184.108.40.206.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.
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