ORA-19502: write error on file

Description:
Adding a new tablespace threw the following Oracle error, the sql file contained the following statement:

PROMPT Creating Tablespace TS_SCHMASK2
create tablespace TS_SCHMASK2
datafile '/data/oradata/FTEST2/TS_SCHMASK201.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK202.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK203.DBF' SIZE 32000M REUSE autoextend on next 1000M,
 '/data/oradata/FTEST2/TS_SCHMASK204.DBF' SIZE 20000M REUSE autoextend on next 1000M;

Symptom:

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 8 10:30:34 2015
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @ebs_storage_schmask2_02
Creating Tablespace TS_SCHMASK2
create tablespace TS_SCHMASK2
*
ERROR at line 1:
ORA-19502: write error on file “/tribal/oradata/FTEST2/TS_SCHMASK201.DBF”,
block number 3633792 (block size=8192)
ORA-27072: File I/O error
Additional information: 4
Additional information: 3633792
Additional information: 491520
Cause:
The filesystem has insufficient disk space available.
Resolution:
Free up disk space.
You can drop any tablespaces and datafiles which are no longer required if there are any with the following statement:
DROP TABLESPACE  INCLUDING CONTENTS AND DATAFILES;
Other housekeeping on the filesystem can be carried out as necessary.


Posted

in

by

Comments

One response to “ORA-19502: write error on file”

  1. Petre avatar

    Thanx. I was very Helpful

Leave a Reply

Your email address will not be published. Required fields are marked *