Friday, February 28, 2014

ORA-01653: unable to extend table in tablespace SYSTEM

You tried to allocate an extent for a table segment in the specified tablespace.

1) FIRST WE NEED TO CHECK THE SPACE  IN TABLESPACE

SELECT TABLESPACE_NAME, SUM(BYTES) FREE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

SELECT SUM(BYTES)/(1024*1024) AS MB
FROM DBA_FREE_SPACE  WHERE TABLESPACE_NAME='SYSTEM';

2) BELOW ARE THE PATH WHERE TABLESPACE RESIDE IN DB IT IS PHYSICALLY.

     C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF

3 RUN THE BELOW MENTION QUERY  FOR EXTAND IT.
ALTER DATABASE DATAFILE 'C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF' RESIZE 2000000;

SIZE IS MORE THE EARLIER SIZE .............



SELECT SUM(BYTES)/(1024*1024) AS MB
FROM DBA_FREE_SPACE  WHERE TABLESPACE_NAME='SYSTEM';

No comments:

Post a Comment

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...