asked on ORA-27044 while moving .dbf file path
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
C:\temp\USERS01.DBF';
データベース・ファイル'C:\TEMP\USERS0
ORA-27044: ファイルのヘッダー・ブロックを書き込めません。
OSD-04008: WriteFile()?？??s???？????B?
One instance on expert exchange says it is because of bug and suggestion was to add "control_file_record_keep_
Any suggestion please?
Trying to move .dbf file but getting ORA-27044 cannot write header of file
SQL> ALTER DATABASE MOVE DATAFILE 'C:\APP\<DBFOLDER>\ORADATA
C:\temp\USERS01.DBF';
データベース・ファイル'C:\TEMP\USERS0
ORA-27044: ファイルのヘッダー・ブロックを書き込めません。
OSD-04008: WriteFile()?？??s???？????B?
One instance on expert exchange says it is because of bug and suggestion was to add "control_file_record_keep_
Any suggestion please?
ExchangeDatabasesOracle Database
Last Comment
Chandan Pratihast
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
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.
ASKER
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.
Your point was correct my data size was 24GB and the target space was less than that.
Thanks for helping to resolve it.
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.