Oracle error: ORA-01119: error in creating database file and ORA-27038: file exists

Article:TECH11517  |  Created: 2001-01-08  |  Updated: 2002-01-27  |  Article URL http://www.symantec.com/docs/TECH11517
Article Type
Technical Solution

Product(s)

Environment

Issue



Oracle error: ORA-01119: error in creating database file and ORA-27038: file exists

Error



Oracle error: ORA-01119: error in creating database file and ORA-27038: file exists

Solution



When trying to create the table space with the command shown in the VERITAS File System for Solaris System Administrator's Guide in Chapter 8 of Quick I/O for Databases, in the section titled Using Quick I/O with Oracle Databases, it is failing with an Oracle error.

SVRMGR> create tablespace pr_data
2>   datafile '/ora3/oradata/ess/pr_data_1.dbf'
3>   size 10m
4> ;
create tablespace pr_data
*
ORA-01119: error in creating database file '/ora3/oradata/ess/pr_data_1.dbf'
ORA-27038: skgfrcre: file exists          



In order to get this statement to work correctly, add the "reuse" keyword to the command.

SVRMGR> create tablespace pr_data
2>   datafile '/ora3/oradata/ess/pr_data_1.dbf'
3>   size 10m reuse
4> ;


This command is published correctly in the VERITAS Database Edition � 2.2 for Oracle ® Database Administrator's Guide Solaris


Legacy ID



237331


Article URL http://www.symantec.com/docs/TECH11517


Terms of use for this information are found in Legal Notices