27.1.11

SAP Note 19324 - SAPDBA: Tabsp. reorg. on NT: error deleting files

Symptom:

Reorganization of tablespace with datafile:
Old data files cannot be deleted; as a result, the tablespace cannot be regenerated.

The error message when CREATING a data file may be as follows:
ORA-01119: error in creating database file
'g:\oracle\t22\sapdata1\ddicd.data1'
ORA-09200: sfccf: error creating file
OSD-04012: file size mismatch

Cause and prerequisites

In contrast to the UNIX environment, a file cannot be deleted under NT as long as it is still open by another process.

Solution
Before you reorganize a tablespace with data files, you must make sure that no other processes are accessing any data files.
The only way to be certain is to shut down R/3 and exit sqldba/sqlplus and any other programs that might access data files on the DB.
Observe any warning messages issued by SAPDBA!

Important! Note:
The NT File Manager can also block database files.
Therefore, when message
"SAPDBA: Scripts are prepared. Do you want to start now?"
appears, shut down the File Manager before starting.

No comments:

Post a Comment