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';
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