ORA-27044 while moving .dbf file path

Chandan Pratihast
Chandan Pratihast used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
That post on here was from 2001 and from Oracle version 8.  You need to be careful when trying random stuff on the Internet.

I see some references to these errors being caused by there not being enough free space to perform the copy.

Make sure you have enough space.

Why are you wanting to copy the datafile to TEMP?

Author

Commented:
Hi

On my laptop the main drive storage space is mostly used. And at times I need to import DB data from different test environment. So trying to store all major datafiles on a separate USB or Micro SSD storage.

In the process tried to move it first to a local directory.
It was failing. Today try with 32GB micro sd card.

Thanks.

Author

Commented:
The filesystem of SD Card was FAT32. Formatted it to NTFS.

The main point was that the file size was 24GB which was more than the target available space.

Thanks for the help to resolve it.

Author

Commented:
The file system on the SSD storage was FAT32 and I formatted it to NTFS and then was able to move the file.

Your point was correct my data size was 24GB and the target space was less than that.

Thanks for helping to resolve it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial