Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding datafile - ORA-27038

Sree BellJun 15 2012 — edited Sep 16 2012

Hello,

Trying to add data file and getting following error:
alter tablespace SALES_BIG1 add datafile '/u02/oracle/admin/SALES/dbf/sales_big1_02.dbf' SIZE 4G REUSE;

*
ERROR at line 1:
ORA-01119: error in creating database file
'/u02/oracle/admin/SALES/dbf/sales_big1_02.dbf'
ORA-27038: created file already exists
HPUX-ia64 Error: 17: File exists
Additional information: 2

There is soft link exists but there is no physical file.

How can I add a datafile if that symbolic link exists?

Database is 10.2.0.4

Thanks
Bell

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2012

Added on Jun 15 2012

#general-database-discussions

3 comments

11,645 views