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

 BEST PYSPARK LEARNING SITES https://www.youtube.com/watch?v=s3B8HXLlLTM&list=PL2IsFZBGM_IHCl9zhRVC1EXTomkEp_1zm&index=5 https://www...