I met ORA-01114 wrong today!

1. A user's feedback was received today and the following error was encountered when entering the window (Material supply system-redeployment slip):

2. The error message for the http://tahiti.oracle.com query about ORA-01114 is as follows:

ORA-01114 IO Error writing block to file string (Block # String)

Cause: the device on which the file resides is probably offline. If the file is a temporary file, then it are also possible that device has run out of spaces. This could happen because disk space of temporary files are not necessarily at file allocated time.

Action: Restore access to the device or remove unnecessary.

3. View the physical disk remaining space and more than 20 g, to eliminate the reasons for insufficient disk space.

4. View individual data file sizes:

Sql> SELECT bytes/1024/1024/1024 as "size (G)", NAME from V$datafile order by bytes;

Size (G) NAME
---------- 　　--------------------------------------------------------------------------------
0.00488281 D:/ORACLE/ORADATA/KDC/TEMP02. ORA
0.01525878 C:/datafile/kdcwz_plan. ORA
0.01678466 d:/oracle/oradata/kdc/tools01. Dbf
0.01953125 d:/oracle/oradata/kdc/cwmlite01. Dbf
0.01953125 d:/oracle/oradata/kdc/drsys01. Dbf
0.01953125 d:/oracle/oradata/kdc/odm01. Dbf
0.02441406 d:/oracle/oradata/kdc/indx01. Dbf
0.03723144 d:/oracle/oradata/kdc/xdb01. Dbf
0.14587402 d:/oracle/oradata/kdc/example01. Dbf
0.34765625 D:/datafile/kdcwz_bill. ORA
0.41015625 d:/oracle/oradata/kdc/system01. Dbf
0.49328613 E:/datafile/kdcwz_stock. ORA
1.50741577 d:/oracle/oradata/kdc/undotbs01. Dbf
2.03735351 d:/oracle/oradata/kdc/users01. Dbf

14 Lines selected

Sql> SELECT bytes/1024/1024/1024 as "size (G)", NAME from V$tempfile order by bytes;

Size (G) NAME
---------- --------------------------------------------------------------------------------
8.00000000 D:/oracle/oradata/kdc/temp01. Dbf

See the maximum data file D:/oracle/oradata/kdc/temp01 in the system. The DBF size is 8G and is initially estimated to be the reason that the temp table space cannot be expanded.

5. Rebuild Temp Table space:

1. Log in as Sysdba

2. Create temporary table space for temporary transit TEMP2

sql> Create temporary tablespace TEMP2 tempfile D:/oracle/oradata/kdc/tem
P02. DBF ' SIZE 5M reuse autoextend on NEXT 640K MAXSIZE Unlimited
2/

The table space has been created.

3. Modify the default temp table space for TEMP2

sql> ALTER DATABASE default temporary tablespace temp2;

The database has changed.

4.drop Original temporary table space temp:

sql> Drop Tablespace temp including contents and datafiles;

Table space has been discarded.

5. Re-create temporary table space Temp:

sql> Create temporary tablespace TEMP tempfile D:/oracle/oradata/kdc/tem
P01. DBF ' SIZE 5M reuse autoextend on NEXT 640K MAXSIZE Unlimited
2/

The table space has been created.

6. Change the default temporary table space to temp:

sql> ALTER DATABASE default temporary tablespace temp;

The database has changed.

7.drop Temporary table Space TEMP2

Sql> drop tablespace temp2 including contents and datafiles;

Table space has been discarded.

6. Re-entry (Material supply system-transfer list) window, success, problem solving.