Total Pageviews

Sunday, August 28, 2022

ORA-01658: unable to create INITIAL extent for segment in tablespace SYSTEM

Import terminated successfully with warnings.

ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' RESIZE 3000M;

Or by adding a second datafile to the tablespace:

ALTER TABLESPACE SYSTEM

ADD DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'

SIZE 1000M;

Or just allow the datafile to auto extend:

ALTER DATABASE

DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'

AUTOEXTEND ON

MAXSIZE UNLIMITED;

No comments:

Post a Comment

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...