Datafile Is Missing From DBA_DATA_FILES (Doc ID 1580381.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***

Symptoms

alter tablespace R01_GEN_D add datafile '/ptr_live/data/r01_gen_d08.dbf' size 10M autoextend on next 100M maxsize UNLIMITED
*
ERROR at line 1:
ORA-01119: error in creating database file '/ptr_live/data/r01_gen_d08.dbf'
ORA-17502: ksfdcre:3 Failed to create file /ptr_live/data/r01_gen_d08.dbf
ORA-17500: ODM err:ODM ERROR V-41-4-1-166-11 Resource temporarily unavailable
 

Changes

 Adding a data file to an exsisting table space

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