troubleshooting Question

ORA-27044 while moving .dbf file path

Avatar of Chandan Pratihast
Chandan Pratihast asked on
ExchangeDatabasesOracle Database
4 Comments1 Solution241 ViewsLast Modified:
Hi Experts

Trying to move .dbf file but getting ORA-27044 cannot write header of file

SQL> ALTER DATABASE MOVE DATAFILE 'C:\APP\<DBFOLDER>\ORADATA\ORCL\USERS01.DBF' TO '
C:\temp\USERS01.DBF';

データベース・ファイル'C:\TEMP\USERS01.DBF'の作成中にエラーが発生しました。
ORA-27044: ファイルのヘッダー・ブロックを書き込めません。
OSD-04008: WriteFile()????s????????B?t?@?C???????????????????S-Error:

One instance on expert exchange says it is because of bug and suggestion was to add "control_file_record_keep_time=0" in init.ora. Done that and restarted instance but same result. My Oracle version is 12.1.0.2.0.
Any suggestion please?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros