Thursday, 27 November 2014

While loading data, we got the error,fixing this issue

Tablespace Name SALESUNIT Throwing error
"BYTES" column shows maximum size of this tablespace in bytes. If value of "AUTOEXTENSIBLE" column is NO, then Oracle don't extends the maximum size of tablespace. If this value is YES, then Oracle extends tablespace when no more space in it.
SELECT FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE FROM DBA_DATA_FILES WHERE TABLESPACE_NAME=’SALESUNIT’

Now your tablespace is AUTOEXTENSIBLE YES and it will grow if need
Now a look
Again try this
You will get success, if DISK full then you will get error because of disk full (mount point full).

Popular Posts